Calculate each number is 1st time happen
Solved/Closed
bs
-
Dec 2, 2011 at 12:52 AM
zhikim528
zhikim528
- Posts
- 1
- Registration date
- Friday December 9, 2011
- Status
- Member
- Last seen
- December 9, 2011
Related:
- Calculate each number is 1st time happen
- Calculate Time Between 2 Dates in Excel - How-To - Excel
- Time calculation ✓ - Forum - Excel
- Time calculations on a 24-hr clock ✓ - Forum - Excel
- One cell calculation Excel - Time Interval ✓ - Forum - Excel
- Time calculation (TimeXnumber) ✓ - Forum - Excel
6 replies
rizvisa1
Dec 2, 2011 at 06:30 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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
Dec 5, 2011 at 08:58 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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
Dec 6, 2011 at 06:28 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Dec 6, 2011 at 06:28 AM
Not sure fully what you are asking. Have you looked at COUNTIF ?
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
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
Dec 8, 2011 at 12:38 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Dec 8, 2011 at 12:38 PM
what you mean not work in mix case ?
zhikim528
Dec 9, 2011 at 01:35 AM
- 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!