+ Reply to Thread
Results 1 to 3 of 3

Building a lookup table based on sheet file or Pivot table

  1. 12-18-2021, 12:25 PM #1
    spenctr01 is offline
    Registered User
    Join Date
    03-07-2021
    Location
    Bristol
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    73

    Building a lookup table based on sheet file or Pivot table

    Hi can anyone help me with this ssheet please . I want to Build a spreadsheet based on the number in the final column 1&2

    I Would like to see how many 0.03 I have in the column Number of qualifiers
    0.00 70
    0.01 90
    0.02 80

    Extra
    I have tried to pivot the table but It wont allow me to group the numbers that would be easier way to do this? Can anyone help please .
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-19-2021, 11:09 PM #2
    Gregb11 is offline
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    3,183

    Re: Building a lookup table based on sheet file or Pivot table

    Sorry, I don't have a clue what you're asking.
    Reply With QuoteRegister To Reply
  3. 12-20-2021, 08:23 AM #3
    spenctr01 is offline
    Registered User
    Join Date
    03-07-2021
    Location
    Bristol
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    73

    Re: Building a lookup table based on sheet file or Pivot table

    I will redo the questions with an example
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. New to Excel !! Need help on building a simple Pivot table
    By evsramesh in forum Excel General
    Replies: 1
    Last Post: 06-09-2021, 09:02 AM
  2. [SOLVED] building a table based on an other table
    By qjawaid in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-20-2019, 03:17 AM
  3. [SOLVED] Building simple pivot table
    By jaryszek in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 02-05-2019, 08:18 AM
  4. building a stats. from pivot table
    By ciapul12 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-10-2014, 08:11 AM
  5. Help with building a pivot table
    By AllanNWSPP in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-15-2013, 02:29 PM
  6. Building a table automatically based on data from another sheet (vlookup?)
    By HyperG in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-20-2012, 11:34 PM
  7. Building a lookup table with 3 variables/3 answers
    By Dannypak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-26-2009, 12:12 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1