Closed Thread
Results 1 to 2 of 2

Badly Constructed WookBook

  1. #1
    Registered User
    Join Date
    07-24-2017
    Location
    Vancouver, BC
    MS-Off Ver
    2016 (365)
    Posts
    62

    Exclamation Badly Constructed WookBook

    I'm hoping I can get some help please.

    My manager has asked me to take the attached data and pull trends and make charts, etc.
    However, when I look at this data, all I see is "Why did you put it together like this?". I'm not sure what the person was thinking when they built this workbook. It seems very counterintuitive to what we want out of the data, but alas, it is what I have to work with, so...

    HOW? Is there a simple way to pull this data and build the charts and trends? Am I just not seeing it?

    Examples of what my Manager will want from this data:
    How many Pipefitter Journeymen on Day Shift answered Question 1 "Sometimes"?
    How many Welder/Burner's that have been here over 5 years answered Question 5 "Almost Always"?
    Etc. Etc. Etc.

    I expect slicers may come into play at some point, but first we have to pull the data correctly so it can be manipulated, no?

    I've attached the files. Feel free to play! And I really appreciate any help I get from this group, you people really are amazing!
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2211 (Windows 11 22H2 64-bit)
    Posts
    65,348

    Re: Badly Constructed WookBook

    Administrative Note:

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here. I am, therefore, closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...-wookbook.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Badly Constructed WookBook
    By Canadian911Guy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-31-2019, 01:03 PM
  2. Badly Constructed WookBook
    By Canadian911Guy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2019, 01:02 PM
  3. How to create constructed variables in Excel
    By ezkii in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-22-2018, 12:12 AM
  4. A constructed hyperlink not working - sheet default ?
    By millerjj22 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-29-2017, 11:37 AM
  5. [SOLVED] Constructed string and pas it as an argument
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-24-2015, 05:56 AM
  6. Replies: 3
    Last Post: 07-15-2015, 03:50 AM
  7. Code That Checks a Cell in a Row and then Countifs for Specific Variable in row, 60 times
    By Deathwreaker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2014, 05:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1