how to put serial number based on a cell value / name

**jilaba** · 02-14-2019, 02:12 PM

Ref. Attached file quest.xlsx

Column A has Person's name. I need to give unique serial number for each person in B column.

How to do this.

Thanks in advance.

**63falcondude** · 02-14-2019, 02:18 PM

There is probably a cleaner way to do this but this works:

B1 =IF(COUNTIF(A$1:A1,A1)>1,"",SUMPRODUCT(--(FREQUENCY(MATCH(A$1:A1,A$1:A1,0),ROW(A$1:A1)-ROW(A$1)+1)>0)))

Drag the formula down.

**jilaba** · 02-14-2019, 02:25 PM

Thanks a lot, it did its work.

**63falcondude** · 02-14-2019, 02:26 PM

You're welcome. Happy to help.

how to put serial number based on a cell value / name

LinkBack

Thread Tools

Rate This Thread

Display

how to put serial number based on a cell value / name

Re: how to put serial number based on a cell value / name

Re: how to put serial number based on a cell value / name

Re: how to put serial number based on a cell value / name

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Generate Serial number based on date

match the loans based off of the serial number

Serial Number generated with sequential letter based on Date

code to generate serial number based on number of records

[SOLVED] Serial Number Allotment based on data in Column B

[SOLVED] Create serial numbers based on a single input number.

Finding a serial number in a list of serial numbers

Bookmarks

Bookmarks

Posting Permissions