1. Welcome to Tacoma World!

    You are currently viewing as a guest! To get full-access, you need to register for a FREE account.

    As a registered member, you’ll be able to:
    • Participate in all Tacoma discussion topics
    • Communicate privately with other Tacoma owners from around the world
    • Post your own photos in our Members Gallery
    • Access all special features of the site

Excel Experts out there?

Discussion in 'Technology' started by memario1214, Oct 28, 2011.

  1. Oct 28, 2011 at 1:24 PM
    #1
    memario1214

    memario1214 [OP] Hotshot Offroad Moderator Vendor

    Joined:
    Oct 1, 2009
    Member:
    #23628
    Messages:
    19,777
    Gender:
    Male
    First Name:
    Colton
    Missoula, MT
    Vehicle:
    SOLD - 05 Dub Cab TRD Sport 4x4, CURRENT - '21 Tundra MGM Limited
    I have a unique issue with Excel going on right now. I am trying to build a progress tracker (for a class of course) and need to calculate my current grade. Does anyone know how to tell Excel to only pull a value (X) if I have a value (Y) in another column? I then need to sum up X and divide by the Sum of Y to find my current grade... :goingcrazy: If it would help to send you the file so that you can see it, shoot me a PM and I will get it out to you. I appreciate any and all help.
     
  2. Oct 28, 2011 at 1:27 PM
    #2
    ImpulseRed008

    ImpulseRed008 Gone But Not Forgotten

    Joined:
    Sep 9, 2008
    Member:
    #9104
    Messages:
    46,584
    Gender:
    Female
    First Name:
    Susan
    SC
    Vehicle:
    08 PreRunner SR5 V6 w/tow pkg
    OEM SS tube steps, Access LE tonneau cover, pop n'lock, AVS in-channel vent visors, stubby antenna, Wet Okole seat covers, bed mat, rear diff breather mod, 4 extra d rings in bed, K&N air filter.
    Send me exactly what you want and I'll work on it when I get home... time to leave now....
     
  3. Oct 28, 2011 at 1:28 PM
    #3
    theduck911

    theduck911 Max's Canadian Twin

    Joined:
    Oct 28, 2010
    Member:
    #45374
    Messages:
    3,938
    Gender:
    Male
    First Name:
    Max
    Northwestern Ontario, Canada
    Vehicle:
    Locked and Geared!
    I might be able to help, which excel are you running?!
     
  4. Oct 28, 2011 at 1:28 PM
    #4
    Brunes

    Brunes abides.

    Joined:
    May 31, 2008
    Member:
    #7011
    Messages:
    17,562
    Gender:
    Male
    First Name:
    Rotorhead
    Around
    Vehicle:
    08 Red/Graphite and Satin Black
    Inside: Tint, Wet Okole 1/2 Piped Red/Black Covers, Black Weathertech Digital Fit Mats, URD Short Throw w/ TWM Weighted Knob, USA Spec iPod adapter. Outside: 4300K Retro w/ Angel Eyes and Red Shrouds, 5000K Blazer Fog Light Retrofit, Debadge, Bed Locking Handle, Satin Black Rims Performance: TRD/Steigmeier Blower w/ 2.7 Pulley. 668 Injectors and 320 LPH AEM Fuel pump. URD UCON and 7th Injector. DTLT Headers, URD Y-Pipe, Wicked Flow Muffler. Suspension: Both: OME Shocks Front: 886X's and TC UCAs Rear: Dakars Armor: Relentless Front Bumper Relentless High Clearance Rear w/ Tire/Rotopax Swing Out Relentless Front, Mid, and TCase skids BAMF Diff Skid Recovery and Spares: Fullsize Spare Tire 2x2 gal Rotopax 1x1 gal Rotopax 1x1 gal Water Rotopax Warn 9.5XP-S Winch Hi-Lift Extreme 60" Ironman Off-Road Recovery Kit
    I'll take a look- sounds like an easy IF function if I'm reading it right..but you have PM with my e-mail.
     
  5. Oct 28, 2011 at 1:31 PM
    #5
    dpak

    dpak Well-Known Member

    Joined:
    Jul 8, 2010
    Member:
    #39947
    Messages:
    358
    Gender:
    Male
    Richmond, VA
    Vehicle:
    09 4x4 TRD Offroad DCSB
    Toytec/Eibach coils w/ 5100's set at 0, Toytec 2.0 Aluma Rear Shocks, Toytec Boss Leaf Springs, TRD Catback Exhaust, SCS F-5 Matte Gray Wheels, Elusive Elements Mesh Grill
    You could probably do a vlookup.
     
  6. Oct 28, 2011 at 1:32 PM
    #6
    dpak

    dpak Well-Known Member

    Joined:
    Jul 8, 2010
    Member:
    #39947
    Messages:
    358
    Gender:
    Male
    Richmond, VA
    Vehicle:
    09 4x4 TRD Offroad DCSB
    Toytec/Eibach coils w/ 5100's set at 0, Toytec 2.0 Aluma Rear Shocks, Toytec Boss Leaf Springs, TRD Catback Exhaust, SCS F-5 Matte Gray Wheels, Elusive Elements Mesh Grill
    Feel free to pm me if you need help.
     
  7. Oct 28, 2011 at 1:33 PM
    #7
    memario1214

    memario1214 [OP] Hotshot Offroad Moderator Vendor

    Joined:
    Oct 1, 2009
    Member:
    #23628
    Messages:
    19,777
    Gender:
    Male
    First Name:
    Colton
    Missoula, MT
    Vehicle:
    SOLD - 05 Dub Cab TRD Sport 4x4, CURRENT - '21 Tundra MGM Limited
    I could send you my assignment Susan :p, but I would need an email address lol

    Excel 2010

    Haha I have to do one of those bad boys later in the assignment... Maybe I could just printscreen what I have up here eh?
     
  8. Oct 28, 2011 at 1:36 PM
    #8
    memario1214

    memario1214 [OP] Hotshot Offroad Moderator Vendor

    Joined:
    Oct 1, 2009
    Member:
    #23628
    Messages:
    19,777
    Gender:
    Male
    First Name:
    Colton
    Missoula, MT
    Vehicle:
    SOLD - 05 Dub Cab TRD Sport 4x4, CURRENT - '21 Tundra MGM Limited
    Excel_197abb28215658f848e9375b1ab37e030ed3bf57.jpg

    And all of the structure is my own, so if you see something messed up, let me know. Later on I have to give an estimated grade for each assignment based on my current overall percentage. Then I'll have to do a lookup to return a letter grade based on my overall points received.
     
  9. Oct 28, 2011 at 1:37 PM
    #9
    MTgirl

    MTgirl too many frogs, not enough princes... Moderator

    Joined:
    Sep 29, 2009
    Member:
    #23531
    Messages:
    68,987
    Gender:
    Female
    First Name:
    Weesa
    Bob's secret mod lair
    Vehicle:
    Then: 12 T4R SR5 Now: 99 - 3.4L SR5 4WD
    Wheeler's/Alcan 5-pack leaf springs, OME 881's, de-badged, Jungle Fender Flares, Herculined bed, HomerTaco grille, Anzo headlights, clear corners,
    You want me to bring my Excel 'bible' from work? Its got every Excel command in there....
     
  10. Oct 28, 2011 at 1:38 PM
    #10
    memario1214

    memario1214 [OP] Hotshot Offroad Moderator Vendor

    Joined:
    Oct 1, 2009
    Member:
    #23628
    Messages:
    19,777
    Gender:
    Male
    First Name:
    Colton
    Missoula, MT
    Vehicle:
    SOLD - 05 Dub Cab TRD Sport 4x4, CURRENT - '21 Tundra MGM Limited
    I don't think that will help me. It's not the commands I am unfamiliar with... In this case, it is their application.
     
  11. Oct 28, 2011 at 1:39 PM
    #11
    Brunes

    Brunes abides.

    Joined:
    May 31, 2008
    Member:
    #7011
    Messages:
    17,562
    Gender:
    Male
    First Name:
    Rotorhead
    Around
    Vehicle:
    08 Red/Graphite and Satin Black
    Inside: Tint, Wet Okole 1/2 Piped Red/Black Covers, Black Weathertech Digital Fit Mats, URD Short Throw w/ TWM Weighted Knob, USA Spec iPod adapter. Outside: 4300K Retro w/ Angel Eyes and Red Shrouds, 5000K Blazer Fog Light Retrofit, Debadge, Bed Locking Handle, Satin Black Rims Performance: TRD/Steigmeier Blower w/ 2.7 Pulley. 668 Injectors and 320 LPH AEM Fuel pump. URD UCON and 7th Injector. DTLT Headers, URD Y-Pipe, Wicked Flow Muffler. Suspension: Both: OME Shocks Front: 886X's and TC UCAs Rear: Dakars Armor: Relentless Front Bumper Relentless High Clearance Rear w/ Tire/Rotopax Swing Out Relentless Front, Mid, and TCase skids BAMF Diff Skid Recovery and Spares: Fullsize Spare Tire 2x2 gal Rotopax 1x1 gal Rotopax 1x1 gal Water Rotopax Warn 9.5XP-S Winch Hi-Lift Extreme 60" Ironman Off-Road Recovery Kit
    Which column is X and which is Y??
     
  12. Oct 28, 2011 at 1:41 PM
    #12
    memario1214

    memario1214 [OP] Hotshot Offroad Moderator Vendor

    Joined:
    Oct 1, 2009
    Member:
    #23628
    Messages:
    19,777
    Gender:
    Male
    First Name:
    Colton
    Missoula, MT
    Vehicle:
    SOLD - 05 Dub Cab TRD Sport 4x4, CURRENT - '21 Tundra MGM Limited
    Well see that 33.2% number hanging out there? That is not my grade overall. I am trying to find out my percentage based upon the grades I have already received. It would also need to update as I put in new grades.
     
  13. Oct 28, 2011 at 1:46 PM
    #13
    MTgirl

    MTgirl too many frogs, not enough princes... Moderator

    Joined:
    Sep 29, 2009
    Member:
    #23531
    Messages:
    68,987
    Gender:
    Female
    First Name:
    Weesa
    Bob's secret mod lair
    Vehicle:
    Then: 12 T4R SR5 Now: 99 - 3.4L SR5 4WD
    Wheeler's/Alcan 5-pack leaf springs, OME 881's, de-badged, Jungle Fender Flares, Herculined bed, HomerTaco grille, Anzo headlights, clear corners,
    Is it a VLOOKUP function that you need?
     
  14. Oct 28, 2011 at 1:52 PM
    #14
    MTgirl

    MTgirl too many frogs, not enough princes... Moderator

    Joined:
    Sep 29, 2009
    Member:
    #23531
    Messages:
    68,987
    Gender:
    Female
    First Name:
    Weesa
    Bob's secret mod lair
    Vehicle:
    Then: 12 T4R SR5 Now: 99 - 3.4L SR5 4WD
    Wheeler's/Alcan 5-pack leaf springs, OME 881's, de-badged, Jungle Fender Flares, Herculined bed, HomerTaco grille, Anzo headlights, clear corners,
    is it registering a low % because you have so many blanks in there? what happens if you delete out the blanks rows? is the % closer to your current grade?
     
  15. Oct 28, 2011 at 1:56 PM
    #15
    MTgirl

    MTgirl too many frogs, not enough princes... Moderator

    Joined:
    Sep 29, 2009
    Member:
    #23531
    Messages:
    68,987
    Gender:
    Female
    First Name:
    Weesa
    Bob's secret mod lair
    Vehicle:
    Then: 12 T4R SR5 Now: 99 - 3.4L SR5 4WD
    Wheeler's/Alcan 5-pack leaf springs, OME 881's, de-badged, Jungle Fender Flares, Herculined bed, HomerTaco grille, Anzo headlights, clear corners,
    Or go to the DATA tab, then DATA VALIDATION, then the SETTINGS tab....uncheck the IGNORE BLANK
     
  16. Oct 28, 2011 at 1:58 PM
    #16
    memario1214

    memario1214 [OP] Hotshot Offroad Moderator Vendor

    Joined:
    Oct 1, 2009
    Member:
    #23628
    Messages:
    19,777
    Gender:
    Male
    First Name:
    Colton
    Missoula, MT
    Vehicle:
    SOLD - 05 Dub Cab TRD Sport 4x4, CURRENT - '21 Tundra MGM Limited
    I could ignore all of those blank values, but the program still won't know how many points to calculate my total out of... I need to know what my current % is based off of the assignments I currently have grades for. Right now its calculating my total from what points are possible at the end of the class.
     
  17. Oct 28, 2011 at 2:04 PM
    #17
    Brunes

    Brunes abides.

    Joined:
    May 31, 2008
    Member:
    #7011
    Messages:
    17,562
    Gender:
    Male
    First Name:
    Rotorhead
    Around
    Vehicle:
    08 Red/Graphite and Satin Black
    Inside: Tint, Wet Okole 1/2 Piped Red/Black Covers, Black Weathertech Digital Fit Mats, URD Short Throw w/ TWM Weighted Knob, USA Spec iPod adapter. Outside: 4300K Retro w/ Angel Eyes and Red Shrouds, 5000K Blazer Fog Light Retrofit, Debadge, Bed Locking Handle, Satin Black Rims Performance: TRD/Steigmeier Blower w/ 2.7 Pulley. 668 Injectors and 320 LPH AEM Fuel pump. URD UCON and 7th Injector. DTLT Headers, URD Y-Pipe, Wicked Flow Muffler. Suspension: Both: OME Shocks Front: 886X's and TC UCAs Rear: Dakars Armor: Relentless Front Bumper Relentless High Clearance Rear w/ Tire/Rotopax Swing Out Relentless Front, Mid, and TCase skids BAMF Diff Skid Recovery and Spares: Fullsize Spare Tire 2x2 gal Rotopax 1x1 gal Rotopax 1x1 gal Water Rotopax Warn 9.5XP-S Winch Hi-Lift Extreme 60" Ironman Off-Road Recovery Kit
    You got mail man...I'm not sure it's the best answer or even right...but I think it's what you were asking for...
     
  18. Oct 28, 2011 at 2:07 PM
    #18
    memario1214

    memario1214 [OP] Hotshot Offroad Moderator Vendor

    Joined:
    Oct 1, 2009
    Member:
    #23628
    Messages:
    19,777
    Gender:
    Male
    First Name:
    Colton
    Missoula, MT
    Vehicle:
    SOLD - 05 Dub Cab TRD Sport 4x4, CURRENT - '21 Tundra MGM Limited
    Thanks brunes! Im in class but ill look at it later. I appreciate the help
     
  19. Oct 28, 2011 at 2:07 PM
    #19
    MTgirl

    MTgirl too many frogs, not enough princes... Moderator

    Joined:
    Sep 29, 2009
    Member:
    #23531
    Messages:
    68,987
    Gender:
    Female
    First Name:
    Weesa
    Bob's secret mod lair
    Vehicle:
    Then: 12 T4R SR5 Now: 99 - 3.4L SR5 4WD
    Wheeler's/Alcan 5-pack leaf springs, OME 881's, de-badged, Jungle Fender Flares, Herculined bed, HomerTaco grille, Anzo headlights, clear corners,
    You want conditional fomatting then - basically telling excel to ignore the POINTS AVAILABLE column unless there is a value in same row for the YOUR GRADE column
     
  20. Oct 28, 2011 at 2:19 PM
    #20
    Brunes

    Brunes abides.

    Joined:
    May 31, 2008
    Member:
    #7011
    Messages:
    17,562
    Gender:
    Male
    First Name:
    Rotorhead
    Around
    Vehicle:
    08 Red/Graphite and Satin Black
    Inside: Tint, Wet Okole 1/2 Piped Red/Black Covers, Black Weathertech Digital Fit Mats, URD Short Throw w/ TWM Weighted Knob, USA Spec iPod adapter. Outside: 4300K Retro w/ Angel Eyes and Red Shrouds, 5000K Blazer Fog Light Retrofit, Debadge, Bed Locking Handle, Satin Black Rims Performance: TRD/Steigmeier Blower w/ 2.7 Pulley. 668 Injectors and 320 LPH AEM Fuel pump. URD UCON and 7th Injector. DTLT Headers, URD Y-Pipe, Wicked Flow Muffler. Suspension: Both: OME Shocks Front: 886X's and TC UCAs Rear: Dakars Armor: Relentless Front Bumper Relentless High Clearance Rear w/ Tire/Rotopax Swing Out Relentless Front, Mid, and TCase skids BAMF Diff Skid Recovery and Spares: Fullsize Spare Tire 2x2 gal Rotopax 1x1 gal Rotopax 1x1 gal Water Rotopax Warn 9.5XP-S Winch Hi-Lift Extreme 60" Ironman Off-Road Recovery Kit
    Conditional formatting will only change the look of the cells IIRC. IF will allow him to find non-bank cells and compute a % score for that assignment. A SUMIF will allow him to total those percentages. The COUNTIF/COUNTA/COUNTBLANK will give him an index for how many assignments are complete.

    I think the answer I sent him will require some work because of the grade weighting...but I'm not sure.
     

Products Discussed in

To Top