| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Values Without Sorting Formulas | Excel Discussion (Misc queries) | |||
| Automatic sorting (giving max and min) based on custom sorting lis | Excel Worksheet Functions | |||
| Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
| Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
| Sorting | Excel Discussion (Misc queries) | |||
Linear Mode
