Hi Bill,

Yes, this formula did work, but trying to combine the formula to remove the
blanks is not working.....argh!

Thank you
Cathy

"Bill Pfister" wrote:

Cathy, using the "=IF(COUNTIF($A$3:A3,A3)=1,A3,"")" formula will also return
duplicate and non-duplicate items. Did the formula not work for you when you
tried it?

Bill



"Cathy Landry" wrote:

Hi Bill,

That will work for the duplicates, but what if there are cost centers that
do not duplicate............I need to see all the cost center in col D, but
only once if they are duplicated...........I hope that makes sense.

A B C D E
10 miles 09/01 611 611 40 miles
20 miles 09/02 612 612 60 miles
30 miles 09/03 611 984 50 miles
40 miles 09/04 612
50 miles 09/05 984

Thank you
Cathy





"Bill Pfister" wrote:

Cathy, see two of Chip Pearson's pages to help out. First, you want to
create a unique list of your items in column c (Extracting Unique Entries,
(http://www.cpearson.com/excel/duplicat.htm), then you want to remove the
blanks from the list (Eliminating Blank Cells From Lists,
http://www.cpearson.com/excel/noblanks.htm). This should provide the unique
list of cost centers, then you can use SumIf to total.

Regards,
Bill



"Cathy Landry" wrote:

Hello,

I have a mileage form that in col C list multiple cost centers and in col D
the user has to enter their cost center again so the calculations will work.
I'd like a formula that will pull the cost center in C only once so there is
a total of mlg being claimed per cost center.

Example:

A B C D E
10 miles 09/01 611 611 40 miles
20 miles 09/02 612 612 60 miles
30 miles 09/03 611
40 miles 09/04 612


Thank you for any/all assistance
Cathy