Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel changes formula after data sort/filter, please help.
Hi,
I have a simple two sheet workbook. The first tab lists employee names, and overtime worked on a daily basis. The second sheet pulls the employees names in and totals their overtime hours in the first column which is then sorted by overtime hours worked (high to low). That all works fine. I have a third column, which I want to show the hours each person is "behind" the person with the most hours. After I sort though, excel alters the formula in the last column. If anyone can help me with this I would greatly appreciate it. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel changes formula after data sort/filter, please help.
Hi,
Try this formula =B2-MAX($B$2:$B$17) It assumes you numbers are in column B, but you can adjust that. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Jesrf" wrote: Hi, I have a simple two sheet workbook. The first tab lists employee names, and overtime worked on a daily basis. The second sheet pulls the employees names in and totals their overtime hours in the first column which is then sorted by overtime hours worked (high to low). That all works fine. I have a third column, which I want to show the hours each person is "behind" the person with the most hours. After I sort though, excel alters the formula in the last column. If anyone can help me with this I would greatly appreciate it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 data corruption using sort within a filter. | Excel Discussion (Misc queries) | |||
Is it possible to sort or filter data by color of the field? | Excel Worksheet Functions | |||
data sort/filter | Excel Worksheet Functions | |||
Filter/sort data to give highest value from each day | Excel Discussion (Misc queries) | |||
TRYING TO SORT OR FILTER DUPLICATE DATA | Excel Discussion (Misc queries) |