Make a list from Items not checked off

**lukereed18** · 03-07-2013, 01:38 PM

I have tables for each unit in a refinery for blinds that need to be installed. I have a column for "Ready to Blind" and a column for "Blinded". I am wanting to have a sheet that list all the blinds (by Blind #, also a column) that are ready to be installed.

So if Blind #1 in the 500 Unit is "Ready to Blind" but has not been "Blinded" it will show up in the sheet named "ready to install" under 500 Unit as #1.

If you could show me how to do it for the 500 unit sheet I will be able to figure out the other sheets.

Thank you

**FDibbins** · 03-07-2013, 07:42 PM

see if the attached is heading where you want to go?

I added a helper column on your blind list sheets (some of them) in O

Also, take a look at the formulas on dashboard in column K. Using indirect allows you to use headers to reference sheets

**lukereed18** · 03-08-2013, 02:07 PM

Thank you Very much, I think that is going to work out well. I have moved some things around since i posted but was able to get everything working.

Thanks again

**FDibbins** · 03-08-2013, 02:55 PM

Happy to help. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neet and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)