I have a 2 columns of data. Sometimes, the second column has some blank cells due to a condition that I set. I want to list in another part of the spreadsheet, the values in the left hand column when that second column value is blank. In other words, if this was my data
january cold
february
March warm
April
May hot
I would want the formula to search this array and return February and April (the list of Column A values that has no value in column B) because the second column was blank.
Can somebody help!
january cold
february
March warm
April
May hot
I would want the formula to search this array and return February and April (the list of Column A values that has no value in column B) because the second column was blank.
Can somebody help!