Condensing Worksheet scheduel

D

Derek Witcher

I have a master sheet that has all of my current jobs that are finished as
well as the ones that are not complete. I have a column that states finished
that I insert a "x" in when complete. I am looking to use something like a
vlookup or hlookup of something that will allow me to remove some of the
columns that I am not concerned with and create an easier to read schedule.
I currently have 38 columns but I only need about 10 for my schedule. Any
suggestions? Thanks for the help in advance. What I want is
if(A1..A10000)=x leave it out of my report and give me all of the other
data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top