Guerilla Data Analysis - Matching Two Data Sets

NeoVader

New Member
Joined
Apr 20, 2009
Messages
7
Hi Bill

I have gotten a lot of useful things out of your book "Guerilla Data Analysis". For example, thank you for the tip re removing #N/A without using two vlookups twice! :)

My question today is regarding the example on page 31. I have worked through the example and have noticed two typos:

  1. Forecast data total is less than $21.5M
  2. The number of records shown on forecast data should be down to row 25 (as per page 32, step 3, this indicates that the original forecast data extends down to row 25)
Is it possible if you can email me the spreadsheet with the correct number of records.

Thank you again for your attention and look forward to hearing from you soon!

Kind Regards

NeoVader
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
The data set is gone. This was my first book and I was not smart enough to save the workbooks used for that book.

Bill
 

Forum statistics

Threads
1,222,725
Messages
6,167,859
Members
452,150
Latest member
jenningstrades

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top