counting the number of rooms

  • Thread starter Thread starter salaam
  • Start date Start date
S

salaam

room no name
125 shiyam
143 jabui
125 slim



total No. of room ?

i have lot of rooms like this but i just want calculate number of rooms.
 
room no name
125     shiyam
143     jabui
125     slim

total No. of room ?

i have lot of rooms like this but i just want calculate number of rooms.
Click to expand...

Sorry if I'm not understanding your question correctly, but I think a
COUNT function should do this. =COUNT(A2:A4) will tell you that the
table above has 3 rooms.
 
I'm guessing that you want to count *unique* room numbers.

=SUMPRODUCT(--(FREQUENCY(A2:A10,A2:A10)>0))

Result = 2
 
Back
Top