Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
sample:
location number product 4 100600 A 4 100600 A 5 103200 A 6 103500 A 6 103500 A 11 106600 B 15 106600 A 18 119200 A 20 119200 B 8 103200 A 9 103800 A 19 105000 B 13 105000 B what I need is: lookup at columns A and B, if number is same and location is same then do nothing. if the number is same and the location is different, then copy that row range like (A7-C7 and A8-C8) to G7 and G8. check sample below: location number product 4 100600 A 4 100600 A 5 103200 A 6 103500 A 6 103500 A 11 106600 B 11 106600 B 15 106600 A 15 106600 A 18 119200 A 18 119200 A 20 119200 B 20 119200 B 8 103200 A 9 103800 A 19 105000 B 19 105000 B 13 105000 B 13 105000 B |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I creat a macro to delete the first 20 cell characters | Excel Worksheet Functions | |||
creat a macro to save a copy with different file name | Excel Discussion (Misc queries) | |||
Creat | Excel Discussion (Misc queries) | |||
How can I creat | Excel Discussion (Misc queries) | |||
creat a macro to look for a file | Excel Discussion (Misc queries) |