Hi
I am hoping one of the Excel experts on the forum can help me with a solution I need in Excel.
I have a table of data, sales invoices, which I need to assign line numbers to for each detail line. So the range starts from 1 at every change in invoice number. There are thousands of lines, so not practical to do manually.
My starting point would look like this:
A B
Invoice Number Line
20004924
20004924
20004924
20004924
20004925
20004926
20004926
20004926
20004927
20004927
20004927
20004927
20004927
20004927
20004927
And I am looking to achieve:
A B
Invoice Number Line
20004924 1
20004924 2
20004924 3
20004924 4
20004925 1
20004926 1
20004926 2
20004926 3
20004927 1
20004927 2
20004927 3
20004927 4
20004927 5
20004927 6
20004927 7
Can anyone advise what function I can use to achieve this and how to do it.
Many thanks.
Alan