Calculate each number is 1st time happen

Solved/Closed
bs - Dec 2, 2011 at 12:52 AM
zhikim528 Posts 1 Registration date Friday December 9, 2011 Status Member Last seen December 9, 2011 - Dec 9, 2011 at 01:35 AM
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.
Related:

6 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 2, 2011 at 06:30 AM
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.
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 5, 2011 at 08:58 AM
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.
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 6, 2011 at 06:28 AM
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
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 8, 2011 at 12:38 PM
what you mean not work in mix case ?
zhikim528 Posts 1 Registration date Friday December 9, 2011 Status Member Last seen December 9, 2011
Dec 9, 2011 at 01:35 AM
rizvisa1, Thank you for the information you provided!