Excel changes formula after data sort/filter, please help.

[Jesrf]

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.

 

[Shane Devenshire]

Hi,

Try this formula

=B2-MAX($B$2:$B$17)

It assumes you numbers are in column B, but you can adjust that.