Recent content by beadedbytes

Thank you for the solution, Skip!

Thanks, Skip, for feedback. With some modification, I was hoping to be able to have values in currently in columns E thru I in separate columns after the post-normalization in order to pivot off of them.

I've used a lot the Excel feature that allows conversion of a summary table to data table using the Pivot Wizard. Often times, the newly-created data table is subsequently used in a pivot table. This method has worked well when the 'values' created are the same format (i.e. number OR percent...

I'm hoping there's an easy option for using a map graph in Excel that would allow me to plot volume by state (or country). Currently, I see 'Bing Map' already built in, but it's not giving me the desired results. It's plotting which states have volume; however, I've been trying to figure out...

Hello. On a regular basis (i.e. bi-monthly), I need to send a meeting invite to 5+ partner companies to set up time to review activities that occurred the prior 2 weeks. Since we all are separate businesses coming to the same meeting, I want to be able to send the same meeting invite to each...

Hello. Please see attached document (a picture is worth a thousand words). I've inherited a dashboard that contains a multitude of charts with data labels. The charts are primarily, not exclusively, stacked or single bar. The labels have been added manually and I'm looking for a much more...

Skip, I was hoping there was a way to consolidate *first* and then normalize. Thanks for feedback.

Yep, I did, Skip. My bad. Doc re-posted here.http://files.engineering.com/getfile.aspx?folder=78a134f6-b35c-4d87-ad7a-3a5c4a0ba16b&file=FilesToCombine_v1.xlsx

Hi, Skip, Appreciate your help - always. A sample file is attached. Reach out if you have additional questions for me.http://files.engineering.com/getfile.aspx?folder=e57ccc51-62ae-4593-a2bc-4d289e9450a0&file=SheetsToCombine.xlsx

Hello, Is there an automated solution (without macros/VBA) for merging multiple Excel worksheets containing different number of columns and rows into one master? The worksheets are all located into one workbook. Thank you in advance for feedback.

When sending out a meeting invitation, there's 3 options for accepting: 1. Edit response before sending 2. Send response now 3. Do not send a response I've learned that when the recipient uses option #3 to respond, they are listed under the Outlook's Tracking section as 'Response' = 'None'. In...

Skip, See attached file. Mailings occur monthly and date range of returns for each mailing can 'overlap'. Let me know if you have other questions. http://files.engineering.com/getfile.aspx?folder=71b68d08-845a-49b0-a34c-55542c4e7535&file=Sample.xlsx

Skip, An addendum. The raw data actually contains the 'Week' field (added below). After I export the data, I then manually enter information into the 'Week#' field. Is there a formula that would automatically populate 'Week#' field? Mailing# Week Week# Mailing...

Hi, Skip, Thank you for reminding me the value of using a structured table. FYI ... Initially, I was not able to get the formulas to work. However, I removed one of the double brackets and ... VOILA! Expected results appeared. [thumbsup] Given this solution, I now need to go and read up...

Please example below taken from part of a pivot table (exception: not included in pivot is column labeled as ‘Returns4’). Mailing# Week# Ct Mailed Returns1 Returns2 Returns3 Returns4 Mailing1 Wk01 500,569 41 41 2.43% 0.01% Wk02 0 335 376 22.31% 0.08% Wk03 0...