Never saw the file, but would a pivot table work?
It can organize your categories and doing a count
is the same as using a point system.
>Ok, so I've got this (write protected, so a linked
workbook would be
>better) excel workbook from work of car dealerships we
>lists the following information:
>Who did the call (Myself, Nancy, Karissa, or Marie,
>Contact phone number
>I want the gist of the formula to read:
>For every make/model:
>If there is a dealership name present (That does not
>Participating Dlr","N/D" or a blank (null) then count
that row as a "1"
>to be totaled with all other make/model combos later,
displayed by who
>Example (row 1)
>I called Brown Honda (col 1) for an s2000 (col 2), josh
is the contact
>(col 3), 555-555-5555 (col 4), and the $200 over invoice
they quoted me
>on the car. If I have all of this information (most
>dealer and price) then I want that to count as a point.
This way we can
>track how many points each employee has gathered,
>inconsistency in the order the employees shop the cars.
Sort of like a
>score card that updates as new data is being entered.
Rows 2-13 will
>have more dealerships shopped by the same person, same
>model. If the Dealership is not present, or says "N/D"
>Participating Dlr" then it would be a 0. I'd like an
>that, when opened, automatically links to the
spreadsheet in question,
>refresh the information, and then display a tally by
name of who got
>the most calls that month or that city.
>Does this make sense? Please don't spam, this is my work
>Jbrashars @ costcoNOSPAMauto.com
>Message posted from http://www.ExcelForum.com/