Take me to the number
I've used this formula to count the number of order numbers that
appear X number of times in one column:
=SUM(IF(FREQUENCY(A1:A36533,A1:A36533)=X,1))
There is one order number that appears 6 times in column A and I need
to find it. Is there a way to copy that order number or at least use
conditional formatting to highlight it? Suggestions?
|