Formula to find all the blank cells in a particular week and return all attributing PO numbers

horkstar

New Member
Joined
Mar 8, 2016
Messages
9
Hello

Need some help on a formula I'm trying to create.

I have a massive expanse of data, 50000 lines of data. One column is PO number, one is week number and one is a delivery booked column.

I need a formula where by I can type in the week number and then the formula will find the cells for that week, which do not have any data in the delivery booked column and then return the PO number so we can chase the suppliers to complete heir delivery?

I have tried lookups and sumproduct but they don't seem dynamic enough to work.

Any ideas welcome!
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Watch MrExcel Video

Forum statistics

Threads
1,095,480
Messages
5,444,733
Members
405,298
Latest member
fxtrtr17

This Week's Hot Topics

Top