A challenging puzzle from FMWC – Financial Modeling World Cup. How to solve a Word Maze or a Word Search using Excel. This maze includes 20000 letters! You have 30 minutes to score 1000 points using Excel formulas or Continue reading “Solving Word Search With Excel (FMWC) – 2439”
Category: Power Pivot
Challenge How To Arrange A Seating Chart At A Networking Event – 2438
You have 100 people coming to a conference. There are 11 sessions. Tables seat 10 people each. How can you set up a seating chart for the 11 sessions so everyone has a chance to meet everyone else at least Continue reading “Challenge How To Arrange A Seating Chart At A Networking Event – 2438”
How To Unhide A Million Rows or Columns In Excel – 2437
My former co-worker thought it was a good idea to hide all of the whitespace below our Excel data and managed to hide a million rows and 16000 columns. How can I unhide something at the edge of the worksheet?
How To Delete Blank Rows At Bottom Of Excel – 2436
“My spreadsheet must be haunted” is a great opening line to an Excel question sent in just before Halloween. You have 1510 rows in Excel. You try to Delete Sheet Rows from A1511 to A1048576, but the rows keep coming Continue reading “How To Delete Blank Rows At Bottom Of Excel – 2436”
Arrays As Arguments To Application WorksheetFunction in Excel VBA – 2435
How to use XMATCH with Application . WorksheetFunction in Excel VBA? Today, a question from Hydrogen Peroxide. How can you refer to an array inside of a formula in Excel VBA.
This workbook takes a look at how to simulate Continue reading “Arrays As Arguments To Application WorksheetFunction in Excel VBA – 2435”
Excel MAX Across All Worksheets – 2434
Can you use the MAX function in Excel to find the largest value across all worksheets? You can use a 3-D Reference or a spearing formula. In this episode, I will show you an easier way to create 3D Continue reading “Excel MAX Across All Worksheets – 2434”
Excel Add A Blank Row After Each Subtotal – 2433
Your manager asks if you can add a blank row after each subtotal. Episode 2433 shows you how to do this in Excel.
The first way, is clearly cheating: Increase the height of each row.
But the second way is the Continue reading “Excel Add A Blank Row After Each Subtotal – 2433”
Excel Add Subtotals To Only One Category – 2432
Geert asks: “in my experience the datasets are non-uniform in the sense that only a subpart of the data needs subtotals. (categories of data are sequentially listed and only 1 category has a further breakdown that needs subtotals – the Continue reading “Excel Add Subtotals To Only One Category – 2432”
Excel Removing Subtotals – 2431
A co-worker sent you a file with subtotals. How do you get rid of them?
Why are there 3 numbered buttons to the left of column A in Excel?
Why are there minus buttons and vertical lines to the left of column Continue reading “Excel Removing Subtotals – 2431”
Excel Subtotals Are Awesome – 2428
Accountants love the subtotals feature in Excel. We love to see details but add a little summary information. I have a lot of friends who think Subtotals should be deprecated and that anytime you use subtotals, you should be using Continue reading “Excel Subtotals Are Awesome – 2428”
Easy Frequency Distribution For Bingo Numbers in Excel – 2430
Candace is using a third-party Bingo app to generate numbers for a bingo game. Some people are complaining that the app is not fair and that it is calling some numbers too frequently. Candace manually keyed the numbers into Excel Continue reading “Easy Frequency Distribution For Bingo Numbers in Excel – 2430”
Minute by Minute Stock Price Arrows In Excel – 2429
Broadway Gypsy asks if there is a way to create a “minute by minute changing up/down stock price arrow in Excel”?
In this video, Bill shows how to use Icon Sets and the SIGN function to add up/down arrows next to Continue reading “Minute by Minute Stock Price Arrows In Excel – 2429”