Results 1 to 10 of 10

Average duplicates

Threaded View

  1. #1
    Registered User
    Join Date
    10-29-2013
    Location
    Albuquerque
    MS-Off Ver
    Excel 2010
    Posts
    24

    Average duplicates

    I have a list of 7 cars, a drop down list where I can pick the color and an additional column where I can input the top speed.

    On the bottom I have a grid made for average. What I want those green cells to do is to automatically show the name of the color and average they're speed.

    Any advice?

    Happy holidays!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Macro to Calculate Average excluding Duplicates
    By dani_n88 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-04-2012, 07:55 PM
  2. [SOLVED] Average only the 1st item when there are duplicates in a list
    By JungleJme in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-08-2012, 06:18 AM
  3. Weighted rank- if duplicates rank the average
    By vlady in forum Excel General
    Replies: 3
    Last Post: 02-28-2012, 09:17 PM
  4. Replies: 3
    Last Post: 03-09-2011, 07:00 PM
  5. [SOLVED] Need Assistance: Average/Remove Duplicates
    By DigitalGM in forum Excel General
    Replies: 3
    Last Post: 06-22-2005, 08:05 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