IGNORE BLANK CELLS

[MrsWeet]

I have 22 worksheets with store lists. No 2 worksheets have the same number of stores.

I want to group the worksheets and calculate upper and lower quartile, then colour code using conditional formatting based on those answers.

However, where there are blank cells, the calculation obviously won't work - this is the bit I need help with please!

Many thanks in advance.

 

[HalfAce]

Hello MrsWeet, welcome to the board.
It is not clear to me exactly what you want to do and therefore what you need help with.

Do you want to delete the rows containing the blanks?

What calculation(s) are you using that give the problem where there are blanks?

Or - . . . (?)

 

[Fergus]

Welcome to the Board,

Your question is a bit vague, but can you precede any calculation you want to do with =IF(ISBLANK(cell ref) .... to weed out blank cells?

 

[MrsWeet]

Fergus

I didn't realise that the =quartile formula will ignore text!

The things we learn!

Very many thanks