Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing matches
Does anyone know how to do this?
Master sheet: A B C D sam 1 10 100 sam 2 20 200 sam 3 30 300 sam 4 40 400 Tom 5 6 7 Compare sheet: A B C D Sam Sam Tom Compare sheet after running the program: A B C D Sam 1 10 100 Sam 2 20 200 3 30 300 4 40 400 Tom 5 6 7 -- Message posted via http://www.officekb.com |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing matches
Not a very good example - what's it meant to show? Apart from Sam's
name missing twice, the tables are identical. Pete On Apr 23, 6:33*pm, "saman110 via OfficeKB.com" <u35670@uwe wrote: Does anyone know how to do this? Master sheet: A * * * *B * * * C * * * D sam * *1 * * * 10 * * 100 sam * *2 * * * 20 * * 200 sam * *3 * * * 30 * * 300 sam * *4 * * * 40 * * 400 Tom * *5 * * * *6 * * *7 Compare sheet: A * * * * * B * * * *C * * * *D Sam * * * * * * Sam * * * * * * Tom * * * * * * Compare sheet after running the program: A * * * * B * * * *C * * * *D Sam * * 1 * * * 10 * * *100 Sam * * 2 * * * 20 * * *200 * * * * * * 3 * * * 30 * * *300 * * * * * * 4 * * * 40 * * *400 Tom * * *5 * * * *6 * * * *7 -- Message posted viahttp://www.officekb.com |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing matches
It compares "sam" in master sheet with any matches in compare sheet and if it
finds one, it will copy and paste the corresponding cells into master sheet. Now in compare sheet there are only 2 sams and in master sheet there are 4 sams, so it should find matches in 2 sams copy the other sams below them. Thank you for your response. saman110 wrote: Does anyone know how to do this? Master sheet: A B C D sam 1 10 100 sam 2 20 200 sam 3 30 300 sam 4 40 400 Tom 5 6 7 Compare sheet: A B C D Sam Sam Tom Compare sheet after running the program: A B C D Sam 1 10 100 Sam 2 20 200 3 30 300 4 40 400 Tom 5 6 7 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200804/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum Multiple Matches | Excel Worksheet Functions | |||
Comparing 2 column for matches | Excel Discussion (Misc queries) | |||
matches | Excel Discussion (Misc queries) | |||
Multibul matches | Excel Discussion (Misc queries) | |||
matches | Excel Discussion (Misc queries) |