Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |