I have a spreadsheet problem that I am trying to solve.. and turning to the good ship BBS to see if anyone can help.
I have a spreadsheet as such
A1 Name B1 Class C1 Comment
A2 Joe Bloggs B2 Y1 Red C2 BLANK
A3 Eva Ready B3 Y1 Blue C3 This is a filled cell.
I want to be able to search and return either how many blanks or non blanks there are for each class. So column B may have 10-15 Y1 Red in, I want to match those with column C.
i.e. in the example above, there is 1 BLANK for Y1 Red.
Anyone got any ideas?
I have a spreadsheet as such
A1 Name B1 Class C1 Comment
A2 Joe Bloggs B2 Y1 Red C2 BLANK
A3 Eva Ready B3 Y1 Blue C3 This is a filled cell.
I want to be able to search and return either how many blanks or non blanks there are for each class. So column B may have 10-15 Y1 Red in, I want to match those with column C.
i.e. in the example above, there is 1 BLANK for Y1 Red.
Anyone got any ideas?
0 commentaires:
Enregistrer un commentaire