**Question description:**

*This user has given permission to use the problem statement for this blog.*

I have a list of email addresses in row A1. I would like to create a unqiue ID for each unique row in column B1 using excel either with formula

Solved by E. E. in 40 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
13/09/2017 - 07:56

Hi, Hello

User
13/09/2017 - 07:56

hi

Excelchat Expert
13/09/2017 - 07:56

Welcome to got it pro

User
13/09/2017 - 07:57

Im tryin to type in excel but not letting me

User
13/09/2017 - 07:57

the id can be numbers

User
13/09/2017 - 07:57

begining from 1

User
13/09/2017 - 07:58

So abc@gmail.com appears twice the id will be the same

User
13/09/2017 - 07:58

i.e. in this case its 2

Excelchat Expert
13/09/2017 - 07:58

okay i get it

Excelchat Expert
13/09/2017 - 07:58

that is possible using formula

User
13/09/2017 - 07:59

thanks

Excelchat Expert
13/09/2017 - 07:59

i think i will try using count and max function

User
13/09/2017 - 08:00

okay

Excelchat Expert
13/09/2017 - 08:00

wait

Excelchat Expert
13/09/2017 - 08:00

it would be somehow long

User
13/09/2017 - 08:01

is it too much?

Excelchat Expert
13/09/2017 - 08:02

no, i meant please wait a moment

User
13/09/2017 - 08:02

oh okay

Excelchat Expert
13/09/2017 - 08:07

are you using excel or gsheet?

User
13/09/2017 - 08:08

excel

Excelchat Expert
13/09/2017 - 08:09

then i have to write in my own excel

Excelchat Expert
13/09/2017 - 08:09

because the formula will be different if write on screen

User
13/09/2017 - 08:09

okay can you paste the formula here

User
13/09/2017 - 08:10

i have 6mins left

Excelchat Expert
13/09/2017 - 08:11

please extend the time

Excelchat Expert
13/09/2017 - 08:11

np

Excelchat Expert
13/09/2017 - 08:11

you have to press extend

Excelchat Expert
13/09/2017 - 08:12

sorry for long time

Excelchat Expert
13/09/2017 - 08:12

this will auto extend

Excelchat Expert
13/09/2017 - 08:12

another 20 minutes

User
13/09/2017 - 08:13

okay i have extended

Excelchat Expert
13/09/2017 - 08:14

just half typing it

User
13/09/2017 - 08:19

hello have you go it?

Excelchat Expert
13/09/2017 - 08:19

yes

Excelchat Expert
13/09/2017 - 08:20

1 minute

Excelchat Expert
13/09/2017 - 08:20

sorry long formula and testing

User
13/09/2017 - 08:21

no problem

Excelchat Expert
13/09/2017 - 08:27

wait it show error again

User
13/09/2017 - 08:28

Maybe its best to copy the emails to another sheet. make them unique, add a unique id manually to each email, then use vlookup to get the unique ids from sheet2 to sheet1?

User
13/09/2017 - 08:29

Thats one way i think i can resolve it, just though there might be an easy formula to this

Excelchat Expert
13/09/2017 - 08:29

yes

Excelchat Expert
13/09/2017 - 08:29

sorry

Excelchat Expert
13/09/2017 - 08:30

there is a way to do that

Excelchat Expert
13/09/2017 - 08:30

copy it

Excelchat Expert
13/09/2017 - 08:30

click data

Excelchat Expert
13/09/2017 - 08:30

data menu

Excelchat Expert
13/09/2017 - 08:30

remove duplicate

Excelchat Expert
13/09/2017 - 08:31

then use vlookup function

User
13/09/2017 - 08:31

okay thanks il do it my way

Excelchat Expert
13/09/2017 - 08:31

see orange

Excelchat Expert
13/09/2017 - 08:31

thats the vlookup function

Excelchat Expert
13/09/2017 - 08:32

to refer to another table which you has removed the duplicate

User
13/09/2017 - 08:32

yeah i know how to use vlookup

Excelchat Expert
13/09/2017 - 08:32

sorry for this inconvenience

User
13/09/2017 - 08:32

No worries

Excelchat Expert
13/09/2017 - 08:32

i am still attaching the progress

Excelchat Expert
13/09/2017 - 08:33

i was trying to solve by formula

[Uploaded an Excel file]

Excelchat Expert
13/09/2017 - 08:33

really sorry and apologize

User
13/09/2017 - 08:34

That's fine, that is a really confusing formula

User
13/09/2017 - 08:34

which i wouldn't have got it

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*