Found 2 bookmarks
Custom sorting
Excel Blog - Using multiple criteria in Excel Lookup formulas
Excel Blog - Using multiple criteria in Excel Lookup formulas
Good introduction to the different options for lookup formulas in Excel when you need more than one criteria and therefore can't use VLOOKUP. Shows SUMPRODUCT, SUMPRODUCT with INDEX and ROW, LOOKUP, and an array formula with INDEX & MATCH. SUMIFS would work in some situations shown too.
#excel#howto
·blogs.office.com·
Excel Blog - Using multiple criteria in Excel Lookup formulas
Cometdocs
Cometdocs
Online tool for converting PDF files to Word, Excel, PPT, etc. It does a good job of making text editable, but converts SmartArt as static graphics. It would work for small text edits in a presentation where you don't have the original PPT file, but if you had a lot of SmartArt to rebuild it wouldn't save much time. It might work better for Excel spreadsheets than the PPT I tested.
#tools#free#powerpoint#Word#excel
·cometdocs.com·
Cometdocs