+ Reply to Thread
Results 1 to 4 of 4

Extrapolating data

  1. #1
    Registered User
    Join Date
    02-03-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    32

    Extrapolating data

    Hi,

    Attached is a spreadsheet which has a list of questions which have been answered by people in different departments of an airport. I need it so that I can easily see how many people from for example Flight Crew agreed with each question, how many disagreed etc. I have put on the other tab how I need it to look. I've been going through, putting of filters doing it which is taking ages and was wondering if anybody knew a quicker way of doing it?

    Thanks in advance for any help!
    Last edited by 6StringJazzer; 10-02-2016 at 10:55 AM. Reason: Attachment with sensitive data removed at request of OP

  2. #2
    Forum Contributor
    Join Date
    11-12-2014
    Location
    Boston, MA
    MS-Off Ver
    Office 2010
    Posts
    172

    Re: Extrapolating data

    What counts as "Office?". The numbers don't seem to add up

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,055

    Re: Extrapolating data

    This just calculates the answers to question 1 (Export 1.1!column B)

    in
    Sheet1!C4
    =SUMPRODUCT(('Export 1.1'!$B$2:$B$287=$B4)*('Export 1.1'!$A$2:$A$287=C$2))
    copy C4 to C5:C8

    now copy C4:C8 to E4:E8 G4:G8 I4:I8 and K4:K8
    Make sure Sheet1 column B descriptions match EXACTLY the replies in Export 1.1! column B
    Make sure the headings in Sheet1 row 2 match EXACTLY the descriptions in Export 1.1! column A

    I haven't attempted the %s

    How are you going to put the remaining 54 questions on the Sheet1 spreadsheet?
    Last edited by Special-K; 04-21-2015 at 11:57 AM.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  4. #4
    Forum Contributor
    Join Date
    11-12-2014
    Location
    Boston, MA
    MS-Off Ver
    Office 2010
    Posts
    172

    Re: Extrapolating data

    Here you go. If any of the departments are incorrect, just change them to be correct in that list off to the right.
    Last edited by 6StringJazzer; 10-02-2016 at 10:56 AM. Reason: Attachment with sensitive data removed at request of OP

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extrapolating data over time
    By Dan Shorer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-20-2014, 04:07 PM
  2. Extrapolating data within a table
    By MacroIdiot in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-25-2011, 12:20 PM
  3. Extrapolating spreadsheet data
    By djohnalyn in forum Excel General
    Replies: 4
    Last Post: 07-06-2011, 05:58 PM
  4. Extrapolating Data from 1 Period to Another?
    By stviking in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-07-2008, 08:49 AM
  5. [SOLVED] extrapolating data from chart
    By [email protected] in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-31-2006, 06:45 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