Finding the location of what was summed
If it is the most common item then:
MODE(A1:A36533)
will do it
Mike
" wrote:
I'm using this formula to sum how many times a unique order number
appears in column A:
=SUM(IF(FREQUENCY(A1:A36533,A1:A36533)=N,1))
where N is the number of times it appears.
There is one order that appears six times and I need to find out what
that order number is. Any suggestions?
|