sorting

G

GRTNAVY

I am new to Excel, What I am trying to accomplish is that when a technician
fills in "A1" I want to have Excel summerize the job numbers later down the
page with out creating duplicates. As it stands now you have to in the job
numbers at the bottom of the page.
See below.

A
1 R482
2 R539
3 R672
4 R672
5 R482


job # hours

R482
R539
R762

I have been able to figure out how to total the hours but not to automaticly
sort the job numbers
 
J

Jacob Skaria

To filter unique records Data>Filter>Advanced Filter>Choose 'Copy to another
location' > Select the range>Leave the Criteria Range blank>Select a starting
cell for the Copy to location>Check 'Unique records only box' and click OK.

If this post helps click Yes
 
G

GRTNAVY

You were a big help but after following what you instructed me to do, below
is what I got. This is close now but I do not need the second R482 to be
listed. Do you have any other suggestions that I can try.


R482
R539
R672
R482

If the number is listed twice then the hours that a person worked on a
project will be incorrect.

Have a Good Day,
GRTNAVY
 
G

Gord Dibben

A1 with R482 is treated by Excel as a header row so does not filter.

Add a header row and you won't get two R482's


Gord Dibben MS Excel MVP
 
Top