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. |
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. |
All times are GMT +1. The time now is 05:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com