A ahhhmed Member Sep 30, 2011 #1 Hi, I have columns A to E Names appear in these columns some names appear in all columns some only appear in 3 or 2 columns How to find those names which appear in all columns and put them in F How to find the names which appear in 4 columns and put them in G etc. ?
Hi, I have columns A to E Names appear in these columns some names appear in all columns some only appear in 3 or 2 columns How to find those names which appear in all columns and put them in F How to find the names which appear in 4 columns and put them in G etc. ?
Hui Excel Ninja Staff member Oct 1, 2011 #2 Ahhhmed Are the names in the same row or all over the place?
Hui Excel Ninja Staff member Oct 1, 2011 #4 Can you make a new Column of the combined Columns A-E Then make a list of the unique entries in the above column, using Advanced Filter Then do a Countif of each
Can you make a new Column of the combined Columns A-E Then make a list of the unique entries in the above column, using Advanced Filter Then do a Countif of each
M mycko New Member Oct 4, 2011 #6 =(SUMPRODUCT((A$1:A$100=$A1)*1)>0)*1+(SUMPRODUCT((B$1:B$100=$A1)*1)>0)*1+.....
