Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
want to find two matching answers governed by two separate equatio
There are two columns of data in one spreadsheet. Each column is governned by
a different equation, and I want to know how to find any pair of matching answers between the columns. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
want to find two matching answers governed by two separate equatio
Assuming your data is in Cols. A & B, in Col C enter this in row 1 and copy down as far as needed. Adjust the range to meet your needs: =IF(ISERROR(MATCH(A1,$B$1:$B$1000,0)),"","MATCH FOUND IN ROW "&MATCH(A1,$B$1:$B$1000,0)) Column C will be blank until a match for that row in A is found in B. Then the Row number that matches will be returned in the format "MATCH FOUND IN ROW nn". Of course, if duplicate matches exist, only the first one found will be returned. NOTE: if your data range does not begin in row 1, adjust your formula to account for this by adding row number minus one to the formula. e.g. if your data starts in row 10, add 9 as such: =IF(ISERROR(MATCH(A10,$B$10:$B$1000,0)),"","MATCH FOUND IN ROW "&MATCH(A10,$B$10:$B$1000,0)+9) Does this work for you? Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=485637 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
want to find two matching answers governed by two separate equatio
Hi,
You could use conditional formatting. Let's suppose that the data are in A2:A1001 and B2:B1001. Select the entire data (i.e., A2:B1001) -- "Format" -- "Conditional Formatting" -- in the drop down box under Condition 1, select "Formula Is" -- in the formula bar enter =$A2=$B2 -- Click on "Format" button select "Patterns" and select a color -- "OK" -- "OK". This will color the cell pairs containing matching data. OR In column C2 enter the formula, =IF(A2=B2,"X",""), and fill-in the formula down to the last row. The formula will return an "X" symbol wherever there is a match between columns A and B. Hope this helps, Regards, B. R. Ramachandran "gallie" wrote: There are two columns of data in one spreadsheet. Each column is governned by a different equation, and I want to know how to find any pair of matching answers between the columns. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I compare data in two worksheets to find matching cells? | Excel Discussion (Misc queries) | |||
compare data in two lists to find matching entries | Excel Discussion (Misc queries) | |||
compare data in two lists to find matching entries | Excel Discussion (Misc queries) | |||
compare data in two lists to find matching entries | Excel Discussion (Misc queries) | |||
compare data in two lists to find matching entries | Excel Discussion (Misc queries) |