| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data analysis/comparison
If comparing to a theoretically identical layout of the same data, I
always just use AND since it is easy to type quick and gives basic true/false response. =AND(A1=Sheet2!A1) Copy where needed. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
data analysis/comparison
Why the AND?
What is different from just =(A1=Sheet2!A1) ? -- David Biddulph "Spiky" wrote in message ... If comparing to a theoretically identical layout of the same data, I always just use AND since it is easy to type quick and gives basic true/false response. =AND(A1=Sheet2!A1) Copy where needed. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
data analysis/comparison
Thanks Spiky,
I found my solution. BEst. "Spiky" wrote: If comparing to a theoretically identical layout of the same data, I always just use AND since it is easy to type quick and gives basic true/false response. =AND(A1=Sheet2!A1) Copy where needed. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
data analysis/comparison
Good point.
About half the time I do this sort of check, it has multiple arguments and needs AND. Maybe I just carry it over from that. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Comparison | Excel Discussion (Misc queries) | |||
| Data comparison | Excel Worksheet Functions | |||
| Why " data analysis plus " override " data analysis " once instal. | Excel Worksheet Functions | |||
| Data comparison | Excel Worksheet Functions | |||
| Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) | |||
Linear Mode
