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 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 4, 2014 at 12:11 AM
venkat1926 Posts 1863 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?
Related:
- Last ID # Entered
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history. - Facebook Forum
- We couldn't find an account matching the login info you entered ✓ - Gmail Forum
- Matching Names to Id Numbers - Excel Forum
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history - Facebook Forum
- The email address you entered isn't connected to an account. - Facebook Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jan 4, 2014 at 12:11 AM
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
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
