Previous Topic Next Topic

Last ID # Entered

Closed
clg710
Posts
1
Registration date
Thursday January 2, 2014
Status
Member
Last seen
January 2, 2014
 - Jan 2, 2014 at 04:18 PM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 - Jan 4, 2014 at 12:11 AM
I have a very long list of ID #'s that all start with the either BIL_ADMIN_ and then the number or with BIL_RECEIPT_ and then the number. Is there a way to have the last ID # that was entered for each of these automatically show at the top of the spreadsheet?

1 reply

Answer 1 / 1
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 808
Jan 4, 2014 at 12:11 AM
download data from this url

http://speedy.sh/xgrVq/clg710-140104.xlsx


see that columnA contnaing alphanumeric data SORTED ASCNEDING

now see the formulas in B1,C1 and D1
they are copied down.

this is one way of doing it. if you are comfortable with a macro revert back
0