Question in 2 parts (refer attached spreadsheet)
Using Office 365
1. Using formula =IFERROR(INDEX($O$3:$O$29, MATCH(0,INDEX(COUNTIF($B$36:B36,$O$3:$O$29),0,0),0)),"") is there a way to stop column B in the bottom table form inserting 0 when it encounters a mismatch (i.e can 0 be changed to a blank cell)? I want Cell B39 to be blank.
2. Using formula =COUNTIF($O$3:$O$29,"="&$B37) is there a way to stop column C in the bottom table from counting blanks? I want Cells C40:C54 to be blanks (like Cell C39).
New User so apologies if this is not in the correct thread.
Thanks Andrew
Bookmarks