Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Generate new account numbers?
I have a spreadsheet with 900 ish account names. I want to know if there is
a way to have Excel auto generate a unique account number for each one. I will then input this number in my contact manager database for identifying unique accounts, VLOOKUP's, etc........ Thanks! Alan |
#2
|
|||
|
|||
you could use autofilling
type the 1st acc no - 10123 and the 2nd - 10124 select both cells and replicate down as ness "Alan" wrote in message ... I have a spreadsheet with 900 ish account names. I want to know if there is a way to have Excel auto generate a unique account number for each one. I will then input this number in my contact manager database for identifying unique accounts, VLOOKUP's, etc........ Thanks! Alan |
#3
|
|||
|
|||
Easy enough! Thanks for the help!
"JethroUK©" wrote in message ... you could use autofilling type the 1st acc no - 10123 and the 2nd - 10124 select both cells and replicate down as ness "Alan" wrote in message ... I have a spreadsheet with 900 ish account names. I want to know if there is a way to have Excel auto generate a unique account number for each one. I will then input this number in my contact manager database for identifying unique accounts, VLOOKUP's, etc........ Thanks! Alan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Account Numbers | Excel Worksheet Functions | |||
macro to eliminate repeating account numbers | New Users to Excel | |||
generate consecutive numbers | New Users to Excel | |||
How do I delete 100 account numbers from a spreadsheet colume wer. | Excel Worksheet Functions | |||
generate random numbers | Excel Worksheet Functions |