Hi all,
I am trying to have column H total the points to date only if the name in Column A matches the row above it. I had created a macro to automatically sort Column A. But currently Column H is adding the row above even though the names do not match. Column H currently has this formula: =IF(G2<=$M$1,"0",SUM(E2,H1)) but I only want that to happen if the names match in A. I hope that makes sense. It's currently showing 2.5 points to date but it should only show 1 for Employee 1. I have over 200 names so writing each individual name would be tedious and time consuming as each formula. Any suggestions are appreciated!
<tbody>
</tbody>
I am trying to have column H total the points to date only if the name in Column A matches the row above it. I had created a macro to automatically sort Column A. But currently Column H is adding the row above even though the names do not match. Column H currently has this formula: =IF(G2<=$M$1,"0",SUM(E2,H1)) but I only want that to happen if the names match in A. I hope that makes sense. It's currently showing 2.5 points to date but it should only show 1 for Employee 1. I have over 200 names so writing each individual name would be tedious and time consuming as each formula. Any suggestions are appreciated!
Column A | Column B | Column C | Column D | Column E | Column F | Column G | Column H | Column M |
Name | Date | Mins | Type | Points | reset date | Points to Date | =Now() | |
Employee 1 | 5/20/19 | 6 | Late 2 | .5 | y | 11/20/19 | .5 | |
Employee 2 | 4/15/19 | 20 | Late 3 | 1.5 | y | 10/15/19 | 1.5 | |
Employee 1 | 5/21/19 | 10 | Late 2 | .5 | y | 11/21/19 | 2.5 |
<tbody>
</tbody>