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.

6 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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
0
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.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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
0
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.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Dec 6, 2011 at 06:28 AM
Not sure fully what you are asking. Have you looked at COUNTIF ?
0

Didn't find the answer you are looking for?

Ask a question
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
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Dec 8, 2011 at 12:38 PM
what you mean not work in mix case ?
0
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!
0