Thread: Find the most common number in a excel sheet
View Single Post
 
Old 04-19-2017, 07:50 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
=index(a1:a6,mode(match(a1:a6,a1:a6,0)))
Reply With Quote