check how many times the number

[maorphp]

Hello everyone,
How to check how many times the number appears
And to show me the number that appears most often
Up to the number that appears the least

Thank you all

example --

[Glenn Kennedy]

I do not understand your requested answers! Please check them and explain in different words.

[maorphp]

how many times the same number appears
As in the I attached

[AliGW]

Please manually add the results you want to see in the format you want to see them. There is nothing there regarding how often the numbers appear, and I don't believe you really want this column by column, do you?

[Glenn Kennedy]

Look at J4:J7. Why are they to appear IN THAT ORDER? I cannot understand why 13 appears first, then 2x22 and finally 4???!!!

[MrShorty]

How to check how many times the number appears

I would expect a COUNTIFS() function: https://support.office.com/en-us/art...c-aa8c2a866842 Something like =COUNTIFS($H$4:$H$7,M7) will count how many times the number 37 (in M7) occurs in the A range.

And to show me the number that appears most often Up to the number that appears the least

Might depend on exactly what you are trying to do with this step. My first thought, after getting the counts from the COUNTIFS() function, simply sort each pair of columns by the counting column. Sort by ascending or descending depending on which you want to appear that the top.

Will something like that work?

[FlameRetired]

There is probably a shorter way than this. I used FREQUENCY for the counts.

In N4:N7

Please Login or Register  to view this content.

copy that range and paste into cells P4, R4 and T4.

Then to get the numbers in M4:M7

Please Login or Register  to view this content.

copy and paste that range accordingly.

[CAABYYC]

M4=IFERROR(LARGE(IF((COUNTIF(H$4:H$7,H$4:H$7)=N4)*(MATCH(H$4:H$7,H$4:H$7,)=ROW(H$4:H$7)-3),H$4:H$7,"/"),COUNTIF(N$4:N4,N4)),"")
n4=IFERROR(LARGE(IF(MATCH(H$4:H$7,H$4:H$7,)=ROW(H$4:H$7)-3,COUNTIF(H$4:H$7,H$4:H$7),"/"),ROW(A1)),"")


(if H4:H7 has 15,15,37,37 and you want to see 37 in M4 and 15 in M5 )

[maorphp]

You can bring an example please with a file

[kvsrinivasamurthy]

In T5 then copied to other cells

=COUNTIF(INDEX($H$4:$K$7,,MATCH(S$3,$H$3:$K$3,0)),S4)

[FlameRetired]

You can bring an example please with a file

To whom addressed?

This attached is simpler than my first formulas. For the listed unique numbers (descending) in M4:M7

Please Login or Register  to view this content.

then the counts are the same as kvsrinivasamurthy's. In N4:N7

Please Login or Register  to view this content.