Excel Tips
May 23, 2018
Today's question from Flo in Nashville: I need to do a VLOOKUP for a series of item numbers. Each item number is either going to be found in Catalog A or in Catalog B. Can I write a formula that first searches Catalog A. If the item is not found, then move on to Catalog B?
May 22, 2018
A question from my Atlanta live Power Excel seminar: Is there a way to type 12345 and have Excel enter 123.45? I call this Adding Machine mode, because it feels like the 1970's era adding machine with the switch to automatically add two decimal places.
May 18, 2018
Frank from New Jersey downloads data every day where the blank cells actually contain one or more spaces. This is frustrating because =ISBLANK() won't recognize these cells as empty.
May 17, 2018
Today's question from Quentin who was at my Atlanta Power Excel seminar. Quentin has to generate the same 7 survey questions for each of 1000+ customers in Excel.
May 16, 2018
Kaley from Nashville is working on a ticketing spreadsheet. For each event, she chooses a ticketing plan. That ticketing plan could indicate anywhere from 4 to 16 ticket types for the event. Kaley wants a formula that will go to the lookup table and return *all* matches, inserting new rows as appropriate.
May 15, 2018
Ian in Nashville gets data every day from a system download. The date column contains Date+Time. This makes the pivot table have multiple rows per day instead of a summary of one cell per day.
May 14, 2018
Joy attended my Houston Power Excel seminar and asked if there was a way to show the items selected in a slicer in a cell above the pivot table.
May 10, 2018
I download data from the system and some of my numbers have a trailing minus sign. How do I convert only the ones with a trailing minus sign?
Filter by Quarter in Pivot Table with Daily Dates »
May 9, 2018
How can you filter a pivot table by quarter when your pivot table data only has daily dates? It is fairly easy to do using these steps.