Please help me on the following problem. I need the solution urgently.
There are 2 columns, suppose A and B. A contains only name and B contains value of "True" and "False" (which is calculated based on certain formulas). Now i want to display in another sheet (MIS Purpose) those names from column A against which the value in column B is "False". No other Value from column A. For Example, out of 10 values in column A only 3 is False. I want to display those three names in another sheet.
I have tried the if function, but unable to avoid other values.
Please help me.....
Bookmarks