Forum Discussion
Excel problem-POJ
I have an excel spreadsheet that consists of 7,500 rows sorted by station and year with associated values. I have sorted the same station and the same year to stand together (see example below). I wa...
Use the following formula to calculate and display the SUM once for each unique combination:
=IF(AND(A2<>A1, B2<>B1), SUMIFS(C:C, A:A, A2, B:B, B2), "")
Drag down the formula in Column D to fill the rest of the rows.
This approach ensures that the sum appears only once for each station-year combination, specifically at the last occurrence of that combination.
Another efficient way to handle this is by using a Pivot Table, please let me know if need for that.
Thank you very much for the Excel information
POJ
