Hi,
My requirement is that, say for example
i have column A and B in excel. the data is alphanumeric, some cells are blank too.
In cell c i want to obtain a value called "match" for 2 conditions one if the cells match with value(cell A3 has "MA21" and cell B3 has "MA21") and second if the cells match when both are blank (cell A4="" and Cell B4="".
If cell A5 is blank and cell b5 has value or if cell A5 has value and does not match with Cell B5 then i want the value to be "no match"
Thanks
mp
Bookmarks