If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to count the gap
also posted elsewhere
"Michael168" wrote in message ... Let say in A1:A1000, "Dave" have appear a total of 10 times. How I do count the gap between the times and write the answer using the row number in other cell of the same row. But plse remember that "Dave" will appear more than 10 times in the future. e.g. In C1=Dave In D1=First time In E1= Second time and so on until the end. Thanks Michael168 ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
How to count the gap
"in other cell of the same row" is not very descriptive. Perhaps an
illustration with two Dave's in A1:A5 and showing what's to appear in D1 and E1. Alan Beban Michael168 wrote: Let say in A1:A1000, "Dave" have appear a total of 10 times. How I do count the gap between the times and write the answer using the row number in other cell of the same row. But plse remember that "Dave" will appear more than 10 times in the future. e.g. In C1=Dave In D1=First time In E1= Second time and so on until the end. Thanks Michael168 ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|