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
zhikim528 Posts 1 Registration date Friday December 9, 2011 Status Member Last seen December 9, 2011 - Dec 9, 2011 at 01:35 AM
Related:
- Calculate each number is 1st time happen
- Popcorn time download - Download - Movies, series and TV
- Facebook id verification time - Guide
- Ocarina of time rom - Download - Action and adventure
- How to change time in whatsapp - Guide
- 1st mass mailer - Download - Email
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
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
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.
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
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
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.
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
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
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
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
Dec 9, 2011 at 01:35 AM
rizvisa1, Thank you for the information you provided!
