Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to check two rows for equivalence
In Excel 2003, I have a sheet with multiple columns of various different data
types (numeric, date, text, etc.). Is there a simple formula that can check whether one row is equivalent to the next (i.e., A1 = A2, B1 = B2, . . . , M1 = M2)? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to check two rows for equivalence
Please expand your question a bit. I'm gathering that you want to be
notified somehow if the data types are not the same? How would you like to be notified? There's also a lot of different data types. What I think you need is located within the "cell" function. Look that up in the Excel Help (F1) and you'll see all the data types available. Do you simply need to know if two types are the same, or what type it is? - Eric "Eric_NY" wrote: In Excel 2003, I have a sheet with multiple columns of various different data types (numeric, date, text, etc.). Is there a simple formula that can check whether one row is equivalent to the next (i.e., A1 = A2, B1 = B2, . . . , M1 = M2)? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to check two rows for equivalence
No, I wasn't clear. All the rows have the same data types.
What I want to do is simply to check the values, i.e., to check whether row 1 equals row 2 all the way across, etc. (My point in mentioning data types was simply to make clear that this is not a simple format where everything is numeric, or everything is text, etc.) I'm basically looking for a formula which returns TRUE if the current row is the same as the previous and FALSE if not. Thanks. "ak_edm" wrote: Please expand your question a bit. I'm gathering that you want to be notified somehow if the data types are not the same? How would you like to be notified? There's also a lot of different data types. What I think you need is located within the "cell" function. Look that up in the Excel Help (F1) and you'll see all the data types available. Do you simply need to know if two types are the same, or what type it is? - Eric "Eric_NY" wrote: In Excel 2003, I have a sheet with multiple columns of various different data types (numeric, date, text, etc.). Is there a simple formula that can check whether one row is equivalent to the next (i.e., A1 = A2, B1 = B2, . . . , M1 = M2)? Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to check two rows for equivalence
For versions of Excel prior to XL2007, try this...
=IF(SUMPRODUCT(--(1:1=2:2))=256,"Equal","Not Equal") For XL2007, try this... =IF(SUMPRODUCT(--(1:1=2:2))=16384,"Equal","Not Equal") -- Rick (MVP - Excel) "Eric_NY" wrote in message ... No, I wasn't clear. All the rows have the same data types. What I want to do is simply to check the values, i.e., to check whether row 1 equals row 2 all the way across, etc. (My point in mentioning data types was simply to make clear that this is not a simple format where everything is numeric, or everything is text, etc.) I'm basically looking for a formula which returns TRUE if the current row is the same as the previous and FALSE if not. Thanks. "ak_edm" wrote: Please expand your question a bit. I'm gathering that you want to be notified somehow if the data types are not the same? How would you like to be notified? There's also a lot of different data types. What I think you need is located within the "cell" function. Look that up in the Excel Help (F1) and you'll see all the data types available. Do you simply need to know if two types are the same, or what type it is? - Eric "Eric_NY" wrote: In Excel 2003, I have a sheet with multiple columns of various different data types (numeric, date, text, etc.). Is there a simple formula that can check whether one row is equivalent to the next (i.e., A1 = A2, B1 = B2, . . . , M1 = M2)? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to check for cells merged across rows | Excel Discussion (Misc queries) | |||
String equivalence | Excel Worksheet Functions | |||
Page Setup Margin Value Equivalence in cm | Excel Discussion (Misc queries) | |||
function to check rows | Excel Worksheet Functions | |||
Equivalence of two sets of data | Excel Discussion (Misc queries) |