Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count and Add 1 to the count value
Hi all,
Thanks for this forum for the help rendered in my previous issues. Now stucked up with another one. It is like .... col1 col2 1 2 3 1 2 3 what i am looking is in column 2 a formula or function which gives as follows col1 col2 1 001 2 001 3 001 1 002 2 002 1 003 Hope i am clear in asking the question |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count and Add 1 to the count value
How about:
b1: 1 [format as "000"] b2: =if(a2<a1,b1+1,b1) Copy down Regards, Fred. "Vijay DSK" <Vijay wrote in message ... Hi all, Thanks for this forum for the help rendered in my previous issues. Now stucked up with another one. It is like .... col1 col2 1 2 3 1 2 3 what i am looking is in column 2 a formula or function which gives as follows col1 col2 1 001 2 001 3 001 1 002 2 002 1 003 Hope i am clear in asking the question |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count and Add 1 to the count value
Try this:
=TEXT(COUNTIF($A$1:A1,A1),"000") copy down as far as needed "Vijay DSK" wrote: Hi all, Thanks for this forum for the help rendered in my previous issues. Now stucked up with another one. It is like .... col1 col2 1 2 3 1 2 3 what i am looking is in column 2 a formula or function which gives as follows col1 col2 1 001 2 001 3 001 1 002 2 002 1 003 Hope i am clear in asking the question |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count and Add 1 to the count value
Thanks for your help Teethless Mama,
and another small help required from you. I observed that the formula is giving the number automatically. now what i am looking is the formula should consider the number of entries on a single date and for all them it should maintain the same (only one) number. the number should change only when the date changed. Hope I am clear in asking. Thanks in advance. "Teethless mama" wrote: Try this: =TEXT(COUNTIF($A$1:A1,A1),"000") copy down as far as needed "Vijay DSK" wrote: Hi all, Thanks for this forum for the help rendered in my previous issues. Now stucked up with another one. It is like .... col1 col2 1 2 3 1 2 3 what i am looking is in column 2 a formula or function which gives as follows col1 col2 1 001 2 001 3 001 1 002 2 002 1 003 Hope i am clear in asking the question |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count and Add 1 to the count value
A speedy advice will greatly appreciated from Teethless Mama or any one
"Vijay DSK" wrote: Hi all, Thanks for this forum for the help rendered in my previous issues. Now stucked up with another one. It is like .... col1 col2 1 2 3 1 2 3 what i am looking is in column 2 a formula or function which gives as follows col1 col2 1 001 2 001 3 001 1 002 2 002 1 003 Hope i am clear in asking the question |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count and Add 1 to the count value
I still haven't changed my advice. What happened when you tried it?
Regards, Fred. "Vijay DSK" wrote in message ... A speedy advice will greatly appreciated from Teethless Mama or any one "Vijay DSK" wrote: Hi all, Thanks for this forum for the help rendered in my previous issues. Now stucked up with another one. It is like .... col1 col2 1 2 3 1 2 3 what i am looking is in column 2 a formula or function which gives as follows col1 col2 1 001 2 001 3 001 1 002 2 002 1 003 Hope i am clear in asking the question |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count and Add 1 to the count value
Fred the values are not changing when i increased the value
the following is the result of your advice 1 1 2 1 3 1 4 1 5 1 1 2 1 2 2 2 1 3 3 3 4 3 6 3 Please look into this and a speedy advice not only this but also on my another request in this post. Thanks in advance "Fred Smith" wrote: I still haven't changed my advice. What happened when you tried it? Regards, Fred. "Vijay DSK" wrote in message ... A speedy advice will greatly appreciated from Teethless Mama or any one "Vijay DSK" wrote: Hi all, Thanks for this forum for the help rendered in my previous issues. Now stucked up with another one. It is like .... col1 col2 1 2 3 1 2 3 what i am looking is in column 2 a formula or function which gives as follows col1 col2 1 001 2 001 3 001 1 002 2 002 1 003 Hope i am clear in asking the question |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count and Add 1 to the count value
Had you followed my advice, you would have received the following results:
1 001 2 001 3 001 4 001 5 001 1 002 1 002 2 002 1 003 3 003 4 003 6 003 Is this not what you wanted? If it's not, then tell me what you want. Saying "it doesn't work" doesn't give me much to go on. Also, my records show that you posted your initial question at 7:36 on 09/26. I replied at 7:51 on the same day. I'm sorry if that wasn't speedy enough for you. Regards, Fred. "Vijay DSK" wrote in message ... Fred the values are not changing when i increased the value the following is the result of your advice 1 1 2 1 3 1 4 1 5 1 1 2 1 2 2 2 1 3 3 3 4 3 6 3 Please look into this and a speedy advice not only this but also on my another request in this post. Thanks in advance "Fred Smith" wrote: I still haven't changed my advice. What happened when you tried it? Regards, Fred. "Vijay DSK" wrote in message ... A speedy advice will greatly appreciated from Teethless Mama or any one "Vijay DSK" wrote: Hi all, Thanks for this forum for the help rendered in my previous issues. Now stucked up with another one. It is like .... col1 col2 1 2 3 1 2 3 what i am looking is in column 2 a formula or function which gives as follows col1 col2 1 001 2 001 3 001 1 002 2 002 1 003 Hope i am clear in asking the question |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count and Add 1 to the count value
Fred,
An example of what i am looking is (consider the same example ur using) In your last reply you have mentioned 2 columns. In the 1st column 1 was appearing 4 times and as per my requirement the 4th "1" must have a serial number as "004". but it was showing "003" only. Like wise the number 3 was appearing 2 times, means it should have "002" and like wise number 4 and number 6 also showing different values. I can understand how speed you are. Any how once again thanks for your advice and looking into this. Hope i am clear in asking... Please follow this entire post so that you can find what exactly i am looking at. Thanks "Fred Smith" wrote: Had you followed my advice, you would have received the following results: 1 001 2 001 3 001 4 001 5 001 1 002 1 002 2 002 1 003 3 003 4 003 6 003 Is this not what you wanted? If it's not, then tell me what you want. Saying "it doesn't work" doesn't give me much to go on. Also, my records show that you posted your initial question at 7:36 on 09/26. I replied at 7:51 on the same day. I'm sorry if that wasn't speedy enough for you. Regards, Fred. "Vijay DSK" wrote in message ... Fred the values are not changing when i increased the value the following is the result of your advice 1 1 2 1 3 1 4 1 5 1 1 2 1 2 2 2 1 3 3 3 4 3 6 3 Please look into this and a speedy advice not only this but also on my another request in this post. Thanks in advance "Fred Smith" wrote: I still haven't changed my advice. What happened when you tried it? Regards, Fred. "Vijay DSK" wrote in message ... A speedy advice will greatly appreciated from Teethless Mama or any one "Vijay DSK" wrote: Hi all, Thanks for this forum for the help rendered in my previous issues. Now stucked up with another one. It is like .... col1 col2 1 2 3 1 2 3 what i am looking is in column 2 a formula or function which gives as follows col1 col2 1 001 2 001 3 001 1 002 2 002 1 003 Hope i am clear in asking the question |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count and Add 1 to the count value
Ok, try this:
==if(a2<=a1,b1+1,b1) Regards, Fred "Vijay DSK" wrote in message ... Fred, An example of what i am looking is (consider the same example ur using) In your last reply you have mentioned 2 columns. In the 1st column 1 was appearing 4 times and as per my requirement the 4th "1" must have a serial number as "004". but it was showing "003" only. Like wise the number 3 was appearing 2 times, means it should have "002" and like wise number 4 and number 6 also showing different values. I can understand how speed you are. Any how once again thanks for your advice and looking into this. Hope i am clear in asking... Please follow this entire post so that you can find what exactly i am looking at. Thanks "Fred Smith" wrote: Had you followed my advice, you would have received the following results: 1 001 2 001 3 001 4 001 5 001 1 002 1 002 2 002 1 003 3 003 4 003 6 003 Is this not what you wanted? If it's not, then tell me what you want. Saying "it doesn't work" doesn't give me much to go on. Also, my records show that you posted your initial question at 7:36 on 09/26. I replied at 7:51 on the same day. I'm sorry if that wasn't speedy enough for you. Regards, Fred. "Vijay DSK" wrote in message ... Fred the values are not changing when i increased the value the following is the result of your advice 1 1 2 1 3 1 4 1 5 1 1 2 1 2 2 2 1 3 3 3 4 3 6 3 Please look into this and a speedy advice not only this but also on my another request in this post. Thanks in advance "Fred Smith" wrote: I still haven't changed my advice. What happened when you tried it? Regards, Fred. "Vijay DSK" wrote in message ... A speedy advice will greatly appreciated from Teethless Mama or any one "Vijay DSK" wrote: Hi all, Thanks for this forum for the help rendered in my previous issues. Now stucked up with another one. It is like .... col1 col2 1 2 3 1 2 3 what i am looking is in column 2 a formula or function which gives as follows col1 col2 1 001 2 001 3 001 1 002 2 002 1 003 Hope i am clear in asking the question |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count and Add 1 to the count value
Fred,
Tried your advice again the same issue the last row with the value "6" in col a. it was show the result as "003" instead of "001" as the value 6 is appearing first time. Please advise me correct solution. "Fred Smith" wrote: Ok, try this: ==if(a2<=a1,b1+1,b1) Regards, Fred "Vijay DSK" wrote in message ... Fred, An example of what i am looking is (consider the same example ur using) In your last reply you have mentioned 2 columns. In the 1st column 1 was appearing 4 times and as per my requirement the 4th "1" must have a serial number as "004". but it was showing "003" only. Like wise the number 3 was appearing 2 times, means it should have "002" and like wise number 4 and number 6 also showing different values. I can understand how speed you are. Any how once again thanks for your advice and looking into this. Hope i am clear in asking... Please follow this entire post so that you can find what exactly i am looking at. Thanks "Fred Smith" wrote: Had you followed my advice, you would have received the following results: 1 001 2 001 3 001 4 001 5 001 1 002 1 002 2 002 1 003 3 003 4 003 6 003 Is this not what you wanted? If it's not, then tell me what you want. Saying "it doesn't work" doesn't give me much to go on. Also, my records show that you posted your initial question at 7:36 on 09/26. I replied at 7:51 on the same day. I'm sorry if that wasn't speedy enough for you. Regards, Fred. "Vijay DSK" wrote in message ... Fred the values are not changing when i increased the value the following is the result of your advice 1 1 2 1 3 1 4 1 5 1 1 2 1 2 2 2 1 3 3 3 4 3 6 3 Please look into this and a speedy advice not only this but also on my another request in this post. Thanks in advance "Fred Smith" wrote: I still haven't changed my advice. What happened when you tried it? Regards, Fred. "Vijay DSK" wrote in message ... A speedy advice will greatly appreciated from Teethless Mama or any one "Vijay DSK" wrote: Hi all, Thanks for this forum for the help rendered in my previous issues. Now stucked up with another one. It is like .... col1 col2 1 2 3 1 2 3 what i am looking is in column 2 a formula or function which gives as follows col1 col2 1 001 2 001 3 001 1 002 2 002 1 003 Hope i am clear in asking the question |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count and Add 1 to the count value
Then you want the Countif formula from Teethless Mama. What was wrong with
it? Regards, Fred. "Vijay DSK" wrote in message ... Fred, Tried your advice again the same issue the last row with the value "6" in col a. it was show the result as "003" instead of "001" as the value 6 is appearing first time. Please advise me correct solution. "Fred Smith" wrote: Ok, try this: ==if(a2<=a1,b1+1,b1) Regards, Fred "Vijay DSK" wrote in message ... Fred, An example of what i am looking is (consider the same example ur using) In your last reply you have mentioned 2 columns. In the 1st column 1 was appearing 4 times and as per my requirement the 4th "1" must have a serial number as "004". but it was showing "003" only. Like wise the number 3 was appearing 2 times, means it should have "002" and like wise number 4 and number 6 also showing different values. I can understand how speed you are. Any how once again thanks for your advice and looking into this. Hope i am clear in asking... Please follow this entire post so that you can find what exactly i am looking at. Thanks "Fred Smith" wrote: Had you followed my advice, you would have received the following results: 1 001 2 001 3 001 4 001 5 001 1 002 1 002 2 002 1 003 3 003 4 003 6 003 Is this not what you wanted? If it's not, then tell me what you want. Saying "it doesn't work" doesn't give me much to go on. Also, my records show that you posted your initial question at 7:36 on 09/26. I replied at 7:51 on the same day. I'm sorry if that wasn't speedy enough for you. Regards, Fred. "Vijay DSK" wrote in message ... Fred the values are not changing when i increased the value the following is the result of your advice 1 1 2 1 3 1 4 1 5 1 1 2 1 2 2 2 1 3 3 3 4 3 6 3 Please look into this and a speedy advice not only this but also on my another request in this post. Thanks in advance "Fred Smith" wrote: I still haven't changed my advice. What happened when you tried it? Regards, Fred. "Vijay DSK" wrote in message ... A speedy advice will greatly appreciated from Teethless Mama or any one "Vijay DSK" wrote: Hi all, Thanks for this forum for the help rendered in my previous issues. Now stucked up with another one. It is like .... col1 col2 1 2 3 1 2 3 what i am looking is in column 2 a formula or function which gives as follows col1 col2 1 001 2 001 3 001 1 002 2 002 1 003 Hope i am clear in asking the question |
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count and Add 1 to the count value
Fred,
The Counif formula given by Teethless Mama was working well and accepted on 9/26/2008 9:23 PM PST. But on the same reply, am asking for another help which was pasted here for your ready ref in braces (Thanks for your help Teethless Mama, and another small help required from you. I observed that the formula is giving the number automatically. now what i am looking is the formula should consider the number of entries on a single date and for all them it should maintain the same (only one) number. the number should change only when the date changed. Hope I am clear in asking. Thanks in advance. ) So pls look into this n suggest if u can. I hope we are drifting away from the issue. Thanks once again "Fred Smith" wrote: Then you want the Countif formula from Teethless Mama. What was wrong with it? Regards, Fred. "Vijay DSK" wrote in message ... Fred, Tried your advice again the same issue the last row with the value "6" in col a. it was show the result as "003" instead of "001" as the value 6 is appearing first time. Please advise me correct solution. "Fred Smith" wrote: Ok, try this: ==if(a2<=a1,b1+1,b1) Regards, Fred "Vijay DSK" wrote in message ... Fred, An example of what i am looking is (consider the same example ur using) In your last reply you have mentioned 2 columns. In the 1st column 1 was appearing 4 times and as per my requirement the 4th "1" must have a serial number as "004". but it was showing "003" only. Like wise the number 3 was appearing 2 times, means it should have "002" and like wise number 4 and number 6 also showing different values. I can understand how speed you are. Any how once again thanks for your advice and looking into this. Hope i am clear in asking... Please follow this entire post so that you can find what exactly i am looking at. Thanks "Fred Smith" wrote: Had you followed my advice, you would have received the following results: 1 001 2 001 3 001 4 001 5 001 1 002 1 002 2 002 1 003 3 003 4 003 6 003 Is this not what you wanted? If it's not, then tell me what you want. Saying "it doesn't work" doesn't give me much to go on. Also, my records show that you posted your initial question at 7:36 on 09/26. I replied at 7:51 on the same day. I'm sorry if that wasn't speedy enough for you. Regards, Fred. "Vijay DSK" wrote in message ... Fred the values are not changing when i increased the value the following is the result of your advice 1 1 2 1 3 1 4 1 5 1 1 2 1 2 2 2 1 3 3 3 4 3 6 3 Please look into this and a speedy advice not only this but also on my another request in this post. Thanks in advance "Fred Smith" wrote: I still haven't changed my advice. What happened when you tried it? Regards, Fred. "Vijay DSK" wrote in message ... A speedy advice will greatly appreciated from Teethless Mama or any one "Vijay DSK" wrote: Hi all, Thanks for this forum for the help rendered in my previous issues. Now stucked up with another one. It is like .... col1 col2 1 2 3 1 2 3 what i am looking is in column 2 a formula or function which gives as follows col1 col2 1 001 2 001 3 001 1 002 2 002 1 003 Hope i am clear in asking the question |
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count and Add 1 to the count value
Friends,
it was quite some time am looking for a suggestion. Help me out. "Vijay DSK" wrote: Fred the values are not changing when i increased the value the following is the result of your advice 1 1 2 1 3 1 4 1 5 1 1 2 1 2 2 2 1 3 3 3 4 3 6 3 Please look into this and a speedy advice not only this but also on my another request in this post. Thanks in advance "Fred Smith" wrote: I still haven't changed my advice. What happened when you tried it? Regards, Fred. "Vijay DSK" wrote in message ... A speedy advice will greatly appreciated from Teethless Mama or any one "Vijay DSK" wrote: Hi all, Thanks for this forum for the help rendered in my previous issues. Now stucked up with another one. It is like .... col1 col2 1 2 3 1 2 3 what i am looking is in column 2 a formula or function which gives as follows col1 col2 1 001 2 001 3 001 1 002 2 002 1 003 Hope i am clear in asking the question |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |