Related:
- Calculate each number is 1st time happen
- Calculate Time Between 2 Dates in Excel - How-To - Excel
- Excel - Calculation between time interval - How-To - Excel
- Time calculation ✓ - Forum - Excel
- Time calculations on a 24-hr clock ✓ - Forum - Excel
- One cell calculation Excel - Time Interval ✓ - Forum - Excel
6 replies
rizvisa1
- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
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
tan
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
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
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
tan
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.
tan
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
