Hi,
I have 4 columns in my excel sheet. Some of the cells (content) appear in all columns and some don't.
I would like to have a formula which finds the cells that appear in all 4 columns and would write them in a different column.
Is there such a formula?
Thank you,
Keren
how about the following - looking at columns a:d for "thing"
if(and(countif(a:a,"thing")>0,countif(b:b,"thing")>0,countif(c:c,"thing")>0,countif(c:c,"thing")>0),"thing","")
search for at least one occurance of "thing" in each of columns a:d
not a professional, just trying to assist.....
I don't know the "thing" I'm looking for in advance.
I need it to give me all the strings that appear in all 4 columns.
Thanks for the suggestion anyway.
well then instead of counting "thing", count whatever is in column a
if(and(countif(a:a,a1)>0,countif(b:b,a1)>0,countif(c:c,a1)>0,countif(c:c,a1)>0),a1,"")
maybe in column e and copied down for the rows of data?
alternatively, a macro could do the same search
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks