Need help with Excel...

[EQTitan]

I'm running a spread sheet right now of Warcrow's contest, and would like to be able to sort out any and all numbers that are duplicates. Can anyone give me a heads up on how this is done.

Thanks

 

[Malak]

Just sort them and go down the list, for the quick and dirty way. I'll look through my book to see if there's some kind of function that will do it.

 

[cronos]

here's one way to do it:

http://office.microsoft.com/en-us/assistance/HA011366161033.aspx

 

[NeoV]

this is easy

let's say column A is your column with all the numbers in it..

in column B, put a 1 next to each and every entry in column A

make a pivot table of the data in columns A and B, and for the row header choose the column A number, and for the data section choose Sum of B, and sort the whole thing in descending order...any dup's will have a total of more than 1 and be at the top of your list...

you could also do an advanced filter on the list, and select unique records only, and put that outcome in another column....then see if the lengths are different - but that would only tell you if any dup's exist, it wouldn't identify them for you

 

[Malak]

Originally posted by: NeoV
this is easy

let's say column A is your column with all the numbers in it..

in column B, put a 1 next to each and every entry in column A

make a pivot table of the data in columns A and B, and for the row header choose the column A number, and for the data section choose Sum of B, and sort the whole thing in descending order...any dup's will have a total of more than 1 and be at the top of your list...

you could also do an advanced filter on the list, and select unique records only, and put that outcome in another column....then see if the lengths are different - but that would only tell you if any dup's exist, it wouldn't identify them for you

Depending on what version of Excel you use, this is done a lot easier in Office XP/2003. All you have to do is put just one 1, autofill down to the bottom. Select both columns and right click the selection, convert to list. You can sort it any way you like with the list, and still add new numbers. I think anything older than Office XP requires pivot tables to do this, but anything new is easier. There are a lot of things easier since Office 2k.

 

[NeoV]

Malak, how does that help you identify dup's?

 

[EQTitan]

Sorry, I'm a noob when it come to doing this stuff. Could someone explain this to me easily. Sorry for the inconvience*

 

[Malak]

Originally posted by: NeoV
Malak, how does that help you identify dup's?

It should have the same affect as was previously described with the proper setup. I had been stuck on Office 2k for the last few months so it's been a while since I've done it.

 

[cronos]

Originally posted by: EQTitan
Sorry, I'm a noob when it come to doing this stuff. Could someone explain this to me easily. Sorry for the inconvience*

just follow the instructions at the link i have posted step by step. it's really easy.

 

[EQTitan]

Originally posted by: cronos

Originally posted by: EQTitan
Sorry, I'm a noob when it come to doing this stuff. Could someone explain this to me easily. Sorry for the inconvience*

just follow the instructions at the link i have posted step by step. it's really easy.

That worked great now to setup the same thing with AT usernames and assign them to their specific values.