Calculate each number is 1st time happen

[Solved/Closed]
Report
-
Posts
1
Registration date
Friday December 9, 2011
Status
Member
Last seen
December 9, 2011
-
Hello,
Pls do help me.. By using what method ( Auto calclulate ) that can help us to
find out each number is first time happen ?
Eg: Cut Apple : 1
Cut Orange : 2
Cut Apple : 1
Cut Apple : 1
Cut Orange : 2
Cut Papaya : 3
Cut papaya : 3
Cut Orange : 2
Cut Apple : 1
Cut Orange : 2
Cut Papaya : 3
In manual calculatioon: " 3 " number is 1st time happen before. ( ie.: 1,2 & 3 )

Thank you in advance & looking forward.

6 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
I am sorry but I am not able to understand your question

from what you said "find out each number is first time happen"

that to me means
1 appears first time on row 1
2 appears first time on row 2
3 appears first time on row 6

but you say "In manual calculatioon: " 3 " number is 1st time happen before. ( ie.: 1,2 & 3 ) "
So I am at lost how two parts are connected
Dear Rizvisal
Fr: bstan

Good day.
Very sorry for my poor question
In fact what bstan question is to known total how many type of fruits
that I have cut / month. ( Each fruit will repesent by the number respectively, that wise base on my previous question, the answer is 3 - type of fruits been cut. )
Hope this may give you a more clear picture & able to hlep me soonest.
Thank you in advance.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
see this

http://office.microsoft.com/en-us/excel-help/count-occurrences-of-values-or-unique-values-in-a-data-range-HP003056118.aspx
Dear Rizvisal
Fr: bstan
Thank you very much...problem been solved with your kind support.
btw, can you teach me how to " Count the number of unique TEXT ( such as " A ~ Z " ) by using functions formula ?

Thank you in advance.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Not sure fully what you are asking. Have you looked at COUNTIF ?
Dear Rizvisal
Fr: bstan

Oh... my question is ,how to " find out how many unique values & alphabet exist " in a range that contains duplicate values & aplhabet respectively in a cell by using the functions formula ?
e.g: 1) 1
2) 1
3) 2
4) 1
5) a
6) b
7) 2
8) b
9) c
10) 3

Note: COUNTIF been tried but not work in this mix case.

Tks
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
what you mean not work in mix case ?
Posts
1
Registration date
Friday December 9, 2011
Status
Member
Last seen
December 9, 2011

rizvisa1, Thank you for the information you provided!