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] Vivid Illumination Vendor

    Joined:
    Oct 1, 2009
    Member:
    #23628
    Messages:
    13,773
    Gender:
    Male
    First Name:
    Colton
    Gillette, WY
    Vehicle:
    05 Dub Cab TRD Sport 4x4
    Yeah, I gots boost
    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:
    42,617
    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:
    4,041
    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,641
    Gender:
    Male
    First Name:
    Rotorhead
    DC or New Jersey - Depends on the day....
    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:
    328
    Gender:
    Male
    Richmond, VA
    Vehicle:
    09 4x4 TRD Offroad DCSB
    Eibachs w/ 5100's set at 0, Rear TSB, TRD Catback Exhaust, SCS F-5 Matte Gray Wheels, 265/75/16 Hankook Dynapro ATM Tires, 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:
    328
    Gender:
    Male
    Richmond, VA
    Vehicle:
    09 4x4 TRD Offroad DCSB
    Eibachs w/ 5100's set at 0, Rear TSB, TRD Catback Exhaust, SCS F-5 Matte Gray Wheels, 265/75/16 Hankook Dynapro ATM Tires, 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] Vivid Illumination Vendor

    Joined:
    Oct 1, 2009
    Member:
    #23628
    Messages:
    13,773
    Gender:
    Male
    First Name:
    Colton
    Gillette, WY
    Vehicle:
    05 Dub Cab TRD Sport 4x4
    Yeah, I gots boost
    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] Vivid Illumination Vendor

    Joined:
    Oct 1, 2009
    Member:
    #23628
    Messages:
    13,773
    Gender:
    Male
    First Name:
    Colton
    Gillette, WY
    Vehicle:
    05 Dub Cab TRD Sport 4x4
    Yeah, I gots boost
    [​IMG]

    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:
    58,274
    Gender:
    Female
    First Name:
    Weesa
    in the forest
    Vehicle:
    Now: 12 T4R SR5 Then: 99 - 3.4L SR5 4WD
    Wheeler's/Alcan 5-pack leaf springs, Bilstein 5100's front and rear, OME 881's, de-badged, Jungle Fender Flares, Herculined bed, HomerTaco grille, Anzo headlights, clear corners, CVT Mt. Bachelor RTT, custom bed rack & CBI sliders
    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] Vivid Illumination Vendor

    Joined:
    Oct 1, 2009
    Member:
    #23628
    Messages:
    13,773
    Gender:
    Male
    First Name:
    Colton
    Gillette, WY
    Vehicle:
    05 Dub Cab TRD Sport 4x4
    Yeah, I gots boost
    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,641
    Gender:
    Male
    First Name:
    Rotorhead
    DC or New Jersey - Depends on the day....
    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] Vivid Illumination Vendor

    Joined:
    Oct 1, 2009
    Member:
    #23628
    Messages:
    13,773
    Gender:
    Male
    First Name:
    Colton
    Gillette, WY
    Vehicle:
    05 Dub Cab TRD Sport 4x4
    Yeah, I gots boost
    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:
    58,274
    Gender:
    Female
    First Name:
    Weesa
    in the forest
    Vehicle:
    Now: 12 T4R SR5 Then: 99 - 3.4L SR5 4WD
    Wheeler's/Alcan 5-pack leaf springs, Bilstein 5100's front and rear, OME 881's, de-badged, Jungle Fender Flares, Herculined bed, HomerTaco grille, Anzo headlights, clear corners, CVT Mt. Bachelor RTT, custom bed rack & CBI sliders
    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:
    58,274
    Gender:
    Female
    First Name:
    Weesa
    in the forest
    Vehicle:
    Now: 12 T4R SR5 Then: 99 - 3.4L SR5 4WD
    Wheeler's/Alcan 5-pack leaf springs, Bilstein 5100's front and rear, OME 881's, de-badged, Jungle Fender Flares, Herculined bed, HomerTaco grille, Anzo headlights, clear corners, CVT Mt. Bachelor RTT, custom bed rack & CBI sliders
    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:
    58,274
    Gender:
    Female
    First Name:
    Weesa
    in the forest
    Vehicle:
    Now: 12 T4R SR5 Then: 99 - 3.4L SR5 4WD
    Wheeler's/Alcan 5-pack leaf springs, Bilstein 5100's front and rear, OME 881's, de-badged, Jungle Fender Flares, Herculined bed, HomerTaco grille, Anzo headlights, clear corners, CVT Mt. Bachelor RTT, custom bed rack & CBI sliders
    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] Vivid Illumination Vendor

    Joined:
    Oct 1, 2009
    Member:
    #23628
    Messages:
    13,773
    Gender:
    Male
    First Name:
    Colton
    Gillette, WY
    Vehicle:
    05 Dub Cab TRD Sport 4x4
    Yeah, I gots boost
    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,641
    Gender:
    Male
    First Name:
    Rotorhead
    DC or New Jersey - Depends on the day....
    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] Vivid Illumination Vendor

    Joined:
    Oct 1, 2009
    Member:
    #23628
    Messages:
    13,773
    Gender:
    Male
    First Name:
    Colton
    Gillette, WY
    Vehicle:
    05 Dub Cab TRD Sport 4x4
    Yeah, I gots boost
    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:
    58,274
    Gender:
    Female
    First Name:
    Weesa
    in the forest
    Vehicle:
    Now: 12 T4R SR5 Then: 99 - 3.4L SR5 4WD
    Wheeler's/Alcan 5-pack leaf springs, Bilstein 5100's front and rear, OME 881's, de-badged, Jungle Fender Flares, Herculined bed, HomerTaco grille, Anzo headlights, clear corners, CVT Mt. Bachelor RTT, custom bed rack & CBI sliders
    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,641
    Gender:
    Male
    First Name:
    Rotorhead
    DC or New Jersey - Depends on the day....
    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.
     
To Top