How to find blank cells in a range and the get reference to them

[Tyrel Smith]

Can anyone help me please,

I'm trying to find blank cells in a range (O2142:O2206) and the get reference to those cells.

And is there a way to only get reference to the row.

see image below:


I want it to look for the blank cells in column O (Date Job Delivered) because if there is cells that are blank, that means those jobs haven't been delivered and then I want it to get reference to column H (customer part number)

so that for the cells that are blank it gives me the part number in a list and that list would be a list of the parts that haven't been delivered.

Any help would be muchly appreciated, if there isn't a way to do it can you please show me a vba script that will work
Thank you

 

[Norie]

Which version of Excel are you using?

If its one, e.g. Excel 365, that has the FILTER function you could try something like this.

=FILTER(H2:H22, O2:O22="")

 

[Tyrel Smith]

Which version of Excel are you using?

If its one, e.g. Excel 365, that has the FILTER function you could try something like this.

=FILTER(H2:H22, O2:O22="")

I'm using 2010

 

[Tyrel Smith]

Which version of Excel are you using?

If its one, e.g. Excel 365, that has the FILTER function you could try something like this.

=FILTER(H2:H22, O2:O22="")

I tried it but it doesnt work it says Filter function is in valid

 

[Norie]

Which version of Excel are you using?

 

[Tyrel Smith]

Which version of Excel are you using?

2010