I need to do some text comparisons in excel, about 20-50 of them. I would like the result of these if statements to be within a single cell. Here is how I WISHED it would work:
=IF("Test1"="","Equal1","Not equal1")
=IF("Test1"="","Equal1","Not equal1")
=IF("Test1"="","Equal1","Not equal1")
=IF("Test1"="","Equal1","Not equal1")
If that did work, I would like to see the following in the cell:
Not Equal1
Not Equal1
Not Equal1
Not Equal1
Is there any way, maybe using some advanced method, to calculate multiple string comparisons like this, all within a single cell?
={SUM(IF(A1:A4<>B1:B4,1,0))}
will return the number or rows (1-4) where column A <> Column B. If you can make your question more clear I might be able to provide an answer.