Thread: Finding the location of what was summed
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] calibansfolly@gmail.com is offline
external usenet poster
  
Posts: 11
Default Finding the location of what was summed
On May 21, 1:55 pm, Mike H wrote:
If it is the most common item then:

MODE(A1:A36533)

will do it

Mike


It's the least

Reply With QuoteReply With Quote