Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula That Checks For Changes
I have a spreadsheet with the following columns:
* Col. A: Part numbers * Cols. B, C, and D: Current data that pertains to part numbers in col. A * Cols. E, F, and G: Proposed new data that pertains to said part numbers. Such data is obtained by formulas linked to other spreadsheets. What I would like to do is have a formula in col. H that inserts an "X" if any data in cols. B-D is different than that in cols. E-G. If none of the data is different, then it should insert a blank (""). Thanks for your help. -- tb |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula that checks balances | Excel Programming | |||
need help with creating a formula which checks more than 40 cells | Excel Worksheet Functions | |||
Formula which checks multiple criteria before counting | Excel Discussion (Misc queries) | |||
Formula that checks several criteria before returing the value??? | Excel Discussion (Misc queries) | |||
Formula/function that checks for a set of values. | Excel Worksheet Functions |