how to apply distinct (like in oracle sql) to count the rows of the same value as one

  • Thread starter Thread starter malay_ko
  • Start date Start date
M

malay_ko

how will i count the rows if it appears lets say 3 times and i want to
count it only as one?


1
2
3
5
5
5
4


# of times 1 appeared: 1

# of times 2 appeared: 1

# of times 3 appeared: 1

# of times 5 appeared: 3

# of times 4 appeared: 1


pls help me. ([email protected])
 
One way

=SUM(IF(A1:A50<>"",1/COUNTIF(A1:A50,A1:A50)))

entered with ctrl + shift & enter
 
thank you for helping me.

how about this,

what function should i use to be able to accept small letter a, an
capital letter A. I want it not to be case sensitive. pls help m
again. this is part of my school homework. thanks
 
Back
Top