| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
number alpha list w/duplications
I have a list of 1400 names/entries with many names listed two/three times.
I need to assign one number to each person (skipping the duplications). This is a UIL list where each child is entered in several events therefore the duplications. Each child needs to have one id number assigned to him/her. Any ideas ? thanks... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
number alpha list w/duplications
If the names are in a column then select them and any associated columns and
sort by your names and duplicates should come together Then put a 1 in a helper column alongside the top name. We will assume this is in B1. Put this in B2 and drag down for the length of your names =IF(A2=A1,B1,B1+1) Mike "Deb" wrote: I have a list of 1400 names/entries with many names listed two/three times. I need to assign one number to each person (skipping the duplications). This is a UIL list where each child is entered in several events therefore the duplications. Each child needs to have one id number assigned to him/her. Any ideas ? thanks... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
number alpha list w/duplications
thanks - I almost got it, here is a little more info for you and I know you
can completly solve for me. Last name is in column B, First name is in column C and I'll use column G for my helper. "Mike H" wrote: If the names are in a column then select them and any associated columns and sort by your names and duplicates should come together Then put a 1 in a helper column alongside the top name. We will assume this is in B1. Put this in B2 and drag down for the length of your names =IF(A2=A1,B1,B1+1) Mike "Deb" wrote: I have a list of 1400 names/entries with many names listed two/three times. I need to assign one number to each person (skipping the duplications). This is a UIL list where each child is entered in several events therefore the duplications. Each child needs to have one id number assigned to him/her. Any ideas ? thanks... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
number alpha list w/duplications
So if you put 1 in G1, the formula in G2 would be
=IF(AND(B2=B1,C2=C1),G1,G1+1) -- David Biddulph "Deb" wrote in message ... thanks - I almost got it, here is a little more info for you and I know you can completly solve for me. Last name is in column B, First name is in column C and I'll use column G for my helper. "Mike H" wrote: If the names are in a column then select them and any associated columns and sort by your names and duplicates should come together Then put a 1 in a helper column alongside the top name. We will assume this is in B1. Put this in B2 and drag down for the length of your names =IF(A2=A1,B1,B1+1) Mike "Deb" wrote: I have a list of 1400 names/entries with many names listed two/three times. I need to assign one number to each person (skipping the duplications). This is a UIL list where each child is entered in several events therefore the duplications. Each child needs to have one id number assigned to him/her. Any ideas ? thanks... |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
number alpha list w/duplications
PERFECT - THANKS !! I just wasn't sure about the AND or where to place it.
"David Biddulph" wrote: So if you put 1 in G1, the formula in G2 would be =IF(AND(B2=B1,C2=C1),G1,G1+1) -- David Biddulph "Deb" wrote in message ... thanks - I almost got it, here is a little more info for you and I know you can completly solve for me. Last name is in column B, First name is in column C and I'll use column G for my helper. "Mike H" wrote: If the names are in a column then select them and any associated columns and sort by your names and duplicates should come together Then put a 1 in a helper column alongside the top name. We will assume this is in B1. Put this in B2 and drag down for the length of your names =IF(A2=A1,B1,B1+1) Mike "Deb" wrote: I have a list of 1400 names/entries with many names listed two/three times. I need to assign one number to each person (skipping the duplications). This is a UIL list where each child is entered in several events therefore the duplications. Each child needs to have one id number assigned to him/her. Any ideas ? thanks... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search list for non-alpha characters | Excel Worksheet Functions | |||
| How do I create/filter a list of names without duplications | Excel Discussion (Misc queries) | |||
| Alpha sort excel mail list | Excel Discussion (Misc queries) | |||
| How do I count the number of alpha occurences in a range? | Excel Worksheet Functions | |||
| How do I find random number in list of random alpha? (Position is. | Excel Discussion (Misc queries) | |||
Linear Mode
