Bringing data to a Dashboard

%3CLINGO-SUB%20id%3D%22lingo-sub-2024690%22%20slang%3D%22en-US%22%3EBringing%20data%20to%20a%20Dashboard%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2024690%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20list%20of%2050%20projects%20in%20excel%20along%20with%2030%2B%20columns%20of%20data%20for%20each%20project.%20Including%20how%20much%20money%20each%20project%20has%20left%20in%20budget.%20I%20am%20attempting%20to%20list%2C%20on%20my%20dashboard%2C%20which%20projects%20have%20less%20than%20%2425k%20left%20in%20budget.%20and%2C%20am%20lost%20on%20how%20to%20do%20so.%20any%20info%20on%20how%20or%20where%20to%20find%20direction%20would%20be%20greatly%20appreciated.%26nbsp%3B%20the%20fact%20that%20I%20am%20trying%20to%20gather%20and%20present%20info%20from%20non-contiguous%20columns%20is%20a%20real%20headache.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20any%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2024690%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2024737%22%20slang%3D%22en-US%22%3ERe%3A%20Bringing%20data%20to%20a%20Dashboard%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2024737%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F915060%22%20target%3D%22_blank%22%3E%40ebruzgulis-work%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20have%20the%20latest%20version%20of%20Excel%2C%20you%20can%20use%20the%20FILTER%20function%20to%20accomplish%20what%20you%20describe.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20a%20link%20to%20an%20instructional%20video%20on%20the%20subject.%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9I9DtFOVPIg%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9I9DtFOVPIg%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20need%20more%20help%2C%20please%20pst%20either%20a%20copy%20of%20your%20actual%20spreadsheet%2C%20or%20a%20reasonable%20replica%20without%20confidential%20information%20on%20it%20but%20laid%20out%20in%20a%20manner%20resembling%20your%20actual.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a list of 50 projects in excel along with 30+ columns of data for each project. Including how much money each project has left in budget. I am attempting to list, on my dashboard, which projects have less than $25k left in budget. and, am lost on how to do so. any info on how or where to find direction would be greatly appreciated.  the fact that I am trying to gather and present info from non-contiguous columns is a real headache.

 

Thank you for any help.

1 Reply

@ebruzgulis-work 

 

If you have the latest version of Excel, you can use the FILTER function to accomplish what you describe.

 

Here's a link to an instructional video on the subject. https://www.youtube.com/watch?v=9I9DtFOVPIg

 

If you need more help, please pst either a copy of your actual spreadsheet, or a reasonable replica without confidential information on it but laid out in a manner resembling your actual.

Learn everything about our brand-new Dynamic Arrays and how you can use them to build advanced spreadsheets. Arrays (CSE) have long been present in Excel, bu...