I've been trying to create a formula that will take data with a specific status and put those in a list on a summary worksheet.
On my data worksheet I have two columns a category/name column and a risk/status column, on my summary page I want to generate a list solely made up of names that have a specific status.
I've attached a sample.
Thanks in advance for your help.
Re: Compiling a list of specific data from a single or multiple columns
Hmm, Looking at your proposed answer layouts, I would say you would need to use VBA. I could give you a formula (based on one from Domenic) that would give you this layout:
Gadget Ver. 07
Gadget Ver. 15
Gadget Ver. 17
Gadget Ver. 18
etc.
Re: Compiling a list of specific data from a single or multiple columns
ByTheCringe2,
Thanks, I haven't done much with VBA but this will be a good opportunity to learn. Please provide the formula and I'll give it a shot, or if you could provide the formula and the sample spreadsheet with the formula as a reference. Thanks.
Re: Compiling a list of specific data from a single or multiple columns
Slick225, I have run out of time here, but you should be able to see what to do from the attached file.
Re: Compiling a list of specific data from a single or multiple columns
slick225, set up your data properly in the way that Excel CAN work with.
Don’t have an account yet? Register yourself now and be a part of our community!
