i know this is probably too specific to be an entire thread, but i really need someones help and soon. If i have a list of a few hundred unit numbers in excel, and i want to find any dupilcates, how do i do that. Is there a way to isolate the duplicate numbers? I know i could arrange the column numberically, but that would still be super inefficient. Thanks guys.
Dan.
__________________
Quote:
Navin: I had the craziest fantasy that I could rise up and float right down the end of this coronet, right through here, through these valves, right along this tube, and right up against your lips and give you a kiss.
Marie: Why didn't you?
Navin: I didn't want to get spit on me.
they're 16 digit numbers, so after looking at them for a few minutes, it becomes impossible to consentrate.
__________________
Quote:
Navin: I had the craziest fantasy that I could rise up and float right down the end of this coronet, right through here, through these valves, right along this tube, and right up against your lips and give you a kiss.
Marie: Why didn't you?
Navin: I didn't want to get spit on me.
yeah...the help feature doesn't help at all. It tells me to buy an add on. The thing is, excel can do so many things. I know there has to be away to do this, I just can't figure it out.
__________________
Quote:
Navin: I had the craziest fantasy that I could rise up and float right down the end of this coronet, right through here, through these valves, right along this tube, and right up against your lips and give you a kiss.
Marie: Why didn't you?
Navin: I didn't want to get spit on me.