|
Returning the desired value if multiple values exist????
Hi......big question he
please look at this chart: SHEET1 SHEET2 Shape | Color Shape | Color ------------------------ ------------------------- box blue box blue box red box red box pink box pink circle blue cirlcle blue circle green circle green circle pink circle aquamarine circle red circle red SHEET3 Shape | Color --------------------------- circle pink so, I want to verify that the contents in Sheet1 are the same as Sheet 2....if not, I want to record the changes in sheet3 (only show the changes). How do I search Sheet2 for pink circle? What function would I use? |
Returning the desired value if multiple values exist????
sorry about the previous post.... .here is a cleaned up version of
the table. A big concern of mine is: What if a row is added on the next run....like another box is added, will this mess things up? SHEET1 SHEET2 Shape | Color Shape | Color ------------------------ ------------------------- box blue box blue box red box red box pink box pink circle blue cirlcle blue circle green circle green circle pink circle aquamarine circle red circle red SHEET3 Shape | Color --------------------------- circle pink njuneardave wrote: Hi......big question he please look at this chart: SHEET1 SHEET2 Shape | Color Shape | Color ------------------------ ------------------------- box blue box blue box red box red box pink box pink circle blue cirlcle blue circle green circle green circle pink circle aquamarine circle red circle red SHEET3 Shape | Color --------------------------- circle pink so, I want to verify that the contents in Sheet1 are the same as Sheet 2....if not, I want to record the changes in sheet3 (only show the changes). How do I search Sheet2 for pink circle? What function would I use? |
| All times are GMT +1. The time now is 10:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com