2 Columns - Show extra items in Column B
I have 2 Columns A & B
Column B contains all of the data in Column A and then some. I need a function that will show all of the extra items in Column B. |
Put this formula in C2 and copy down the length of column B's entries
"orbojeff" wrote: I have 2 Columns A & B Column B contains all of the data in Column A and then some. I need a function that will show all of the extra items in Column B. |
Try...
C1, copied down: =INDEX($B$1:$B$100,SMALL(IF(COUNTIF($A$1:$A$50,$B$ 1:$B$100)=0,ROW($B$1:$B $100)-ROW($B$1)+1),ROWS($C$1:C1))) To include an error trap, try... =IF(ROWS($C$1:C1)<=SUM(--(COUNTIF($A$1:$A$50,$B$1:$B$100)=0)),INDEX($B$1: $B$100,SMALL(IF(COUNTIF($A$1:$A$50,$B$1:$B$100)=0, ROW($B$1:$B$100)-ROW($B $1)+1),ROWS($C$1:C1))),"") Both formulas need to be confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Adjust the ranges accordingly. Hope this helps! In article . com, "orbojeff" wrote: I have 2 Columns A & B Column B contains all of the data in Column A and then some. I need a function that will show all of the extra items in Column B. |
Oops...
Put this formula in C2 and copy it down the length of column B's entries =IF(COUNTIF(A:A,B2)=0,"Unique","") "orbojeff" wrote: I have 2 Columns A & B Column B contains all of the data in Column A and then some. I need a function that will show all of the extra items in Column B. |
Hi,
You can use the following array formula (Ctrl+Shift+Enter) =if(or(exact(A3,$B$3:$B$80)),"",A3) Regards, Ashish Mathur "orbojeff" wrote: I have 2 Columns A & B Column B contains all of the data in Column A and then some. I need a function that will show all of the extra items in Column B. |
All times are GMT +1. The time now is 11:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com