+ Reply to Thread
Results 1 to 2 of 2

Pivot table for use with IF function

  1. #1
    Registered User
    Join Date
    04-02-2021
    Location
    Salisbury, England
    MS-Off Ver
    2019
    Posts
    4

    Pivot table for use with IF function

    Hi, I have 5 tables for parachute size that parachutists can jump, depending on their weight, total jump numbers, grading (CT-CT4) and license number (A-D); I'm not too sure on how to integrate the tables into one in order for them to work with the IF function on another worksheet, within the same spreadsheet. Can anyone help me?
    Thanks in advance.
    Scott

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

    Re: Pivot table for use with IF function

    There are instructions at the top of the page explaining how to attach your sample workbook.

    A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.
    Ali


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

    Forum Rules (updated August 2023): please read them here.

+ 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. Replace Sumifs Function with Pivot Table in Power Pivot
    By cbrown6305 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-01-2018, 02:53 PM
  2. Replies: 6
    Last Post: 01-24-2017, 06:56 PM
  3. Function to get the Pivot Table ID (name)?
    By 4am in forum Excel General
    Replies: 5
    Last Post: 09-27-2011, 02:46 PM
  4. IF function in VBA for a pivot table?
    By thedon_1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-03-2011, 01:11 PM
  5. Add a function to a pivot table
    By skysurfer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2010, 05:36 PM
  6. pivot table function?
    By hibiscus27 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-20-2007, 08:50 AM
  7. [SOLVED] Pivot Table Function
    By carl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-24-2006, 02:10 PM

Tags for this Thread

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