Hi there,
I'm working on a spreadsheet for a hotel where I have 1500 (ish) Different customers.
I want to give each customer a unique number to identify them.
However, some customers appear more than once, where all the fields in the row are the same as previous row, so I'd like to give the repeating rows the same number to avoid confusion.
I'm not very good with Excel and this has been driving me insane trying to work out so any help would be very much appreciated!
Many Thanks!
Bookmarks