I have huge amount of data in 3 columns A, B, and C. Going in reverse order column C is just some code letters, not important. Column B has sequential numbers from 1 to between 65 and 85. Always starts with 1, but every sequence has different number of digits in it, ex. 1-68, 1-81, 1-76 etc. There are no blank cells, as soon as one sequence ends, new one starts. In column A I need to number every sequence so that every digit in a sequence in column B would have a corresponding number in column A, and for every digit of the same sequence the number in column A would be same, ex. every digit in first sequence in column B would have 1 in corresponding row in column A, every digit in second sequence would have 2 in corresponding row in column A etc.
Can anyone help? I'm using Excel 2010.
Thank you!
I think I understand what you are looking for. In cell A1, type 1. In A2 type this formula: =if(B2=1, A1+1, A1).
Copy the formula down the A column.
Alan
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
Thank you, Alan!I can't believe I didn't figure this out myself. Usually I'm pretty good with formulas
pzak, before you post your next question, take a moment to read the forum rules and show some respect for them, especially regarding meaningful thread titles.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks