Hello, I am trying to figure out an automatic formula in excel to replace a pivot table. I have a table/array of data that includes multitude of information. From that raw data, I have a dro...
Not sure why I didn't think about this easier option first. A simple SUMIFS does it instead of the MAKEARRAY option I posted yesterday. With the same setup
