Thread: Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches
View Single Post
  #27   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Maddening Dilemma - Compare each cell within column a to each cell
Sorry, slight overkill there. Only the source numbers in col A need to be
rounded.

Should have read as
So in C1, array-entered, copied down:
=IF(B1="","",IF(ISNUMBER(MATCH(-ROUND(A1,2)&"_"&B1,ROUND($A$1:$A$100,2)&"_"&$B$1:$ B$100,0)),"",ROW()))

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


Reply With QuoteReply With Quote