excel newbie help

[angie301]

...this may hav been covered before so i will appreciate if sme 1 can direct me to it or jus lemme hav it here

so i have 2 excel work sheets, they both have 10,000+ records. one of the sheets has been supplied to me by a medical company, n their listing is by names and cert# . our records list names and account #. the problem wit our records (or the records i have to work wit) is that 1 record uses 3 rows wen i convert it from a txt file.

a record from the medical company also picks up more than one row cause they hav 'sub' info for a particular person

the prob is that the 2 sheets that suppose to be saying the same ting isn't. the dollar value is way off...

how do i compare these 2 sheet so that i can identify wer it is off? or who doesn't belong?

btw, we are using office 2000 (i dont knw why)

 

[PaddyD]

hi - welcome to the board.

If the 'unique key' between the two lists is name, but they're not formatted the same, then you're going to need to give us a few examples before anything meaningful can be said...

 

[angie301]

well i was able to pull out just names and a number - like a list of names from sheet1 wit a certificate # and sheet 2 which has a list of names and ac#.
( im thinking jus to do a quick report so i can hand up sumptin )

so - how do i match these names and pull out the odd one?

 

[PaddyD]

If the names are the same (i.e. if Bob Smith turns up as "Bob Smith" in both lists), then you could use a vlookup.

You might also have a look at the techniques here:

http://www.mrexcel.com/forum/showthread.php?t=38643

 

[angie301]

tnxs... im gonna try to figure out how to do that now

 

[angie301]

feel free to send me any 'eaiser' tips or links for me to go (google not being too friendly to me 2day)

i was also told i can do an "OALP query" ...not too sure bout that - wat r ur thoughts?

 

[PaddyD]

Please give us an example of the data & use it to take us through exactly what you're trying to achieve - we need the details, not just the form of your problem to make specific recommendations...

 

[angie301]

took me a while - had to edit name n #s

this is jus a small portion of wat i hav to deal with

 

[PaddyD]

so, you don't have names in the same format in the two sheets. Ergo, you can't match them.

 

[angie301]

well dat was easy to get the names to look the same

jack&" * "&mary to get jack * mary

....i still cant merg this?