Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
match between worksheets
I have three worksheets with similar pieces of information never formatted
the same, but need to match. Exp 1: worksheet 1 Full Name JDE OW GERARD ZITTOUN ZITTOUN GERARD ZITTOUN TSZITTOUN NATASHA MOTON MOTON4 NATASHA MOTON MOTON3 NATASHA MOTON MOTON2 NATASHA MOTON MOTON REMI VILLENEUVE ZVILLENE REMI VILLENEUVE TSZVILLENE Exp 2: worksheet 2 Full Name AS400 Gerard Zittoun Zittoun NATASHA MOTON Moton Exp 3: worksheet 3 Full Name NT Gerard Zittoun Zittoun NATASHA MOTON Moton REMI VILLENEUVE ZVILLENE Exp 4: end result (regardless if it is in same worksheet or new one) Full Name NT JDE OW AS400 GERARD ZITTOUN Zittoun ZITTOUN Zittoun GERARD ZITTOUN TSZITTOUN NATASHA MOTON Moton MOTON4 Moton NATASHA MOTON MOTON3 NATASHA MOTON MOTON2 NATASHA MOTON MOTON REMI VILLENEUVE ZVILLENE ZVILLENE TSZVILLENE |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up worksheets to match? | Setting up and Configuration of Excel | |||
trying to match text in 2 worksheets | Excel Worksheet Functions | |||
How to match to Worksheets | Excel Worksheet Functions | |||
Look for match on two worksheets | Excel Worksheet Functions | |||
Can you match records from two different worksheets | Excel Worksheet Functions |