Hi everyone

I’m very much a beginner with excel and I’m in need of some help.

I’m currently using an excel sheet for work that pulls data from various other excel sheets and i wanted to create a bit of a summary sheet, i currently have quite a long list of locations and using x lookup its pulling what item code is in this location and if there’s orders for this today as below:

I’m wanting it to show me all the “Empty” locations and all the “no order for today” locations, i know i can use filter but i want to see both lists side by side and will be adding some more in future too.

I’ve tried using =filter but cant seem to get it to work.

any help will be massively appreciated

​Hi everyone I’m very much a beginner with excel and I’m in need of some help. I’m currently using an excel sheet for work that pulls data from various other excel sheets and i wanted to create a bit of a summary sheet, i currently have quite a long list of locations and using x lookup its pulling what item code is in this location and if there’s orders for this today as below:I’m wanting it to show me all the “Empty” locations and all the “no order for today” locations, i know i can use filter but i want to see both lists side by side and will be adding some more in future too. I’ve tried using =filter but cant seem to get it to work. any help will be massively appreciated    Read More

​