|
sorting
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 |
sorting
To filter unique records DataFilterAdvanced FilterChoose 'Copy to another
location' Select the rangeLeave the Criteria Range blankSelect a starting cell for the Copy to locationCheck 'Unique records only box' and click OK. If this post helps click Yes --------------- Jacob Skaria "GRTNAVY" wrote: 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 |
sorting
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 "Jacob Skaria" wrote: To filter unique records DataFilterAdvanced FilterChoose 'Copy to another location' Select the rangeLeave the Criteria Range blankSelect a starting cell for the Copy to locationCheck 'Unique records only box' and click OK. If this post helps click Yes --------------- Jacob Skaria "GRTNAVY" wrote: 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 |
sorting
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 On Sun, 14 Jun 2009 05:35:01 -0700, GRTNAVY wrote: 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 "Jacob Skaria" wrote: To filter unique records DataFilterAdvanced FilterChoose 'Copy to another location' Select the rangeLeave the Criteria Range blankSelect a starting cell for the Copy to locationCheck 'Unique records only box' and click OK. If this post helps click Yes --------------- Jacob Skaria "GRTNAVY" wrote: 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 |
| All times are GMT +1. The time now is 08:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com