Log In
Register
Home
September 26, 2023
Offline
I have a multi-variable data set I need to separate out into bins. I can't use Excel's histogram function as it won't meet my requirements. This is a problem I can easily solve using SUMIFS formulas, but I want to know if this can be done using a pivot table. But I don't know how to approach it that way.
I've attached a spreadsheet with a sample data set and the results I'm looking for using SUMIFS formulas. I'd appreciate any help in doing the same thing with a pivot table.
Thanks!
Quercus47
Moderators
January 31, 2022
Offline
Perhaps the attached workbook contains an acceptable solution for you. I added a helper column with a lookup function to determine which bin each row falls in. Note that I had to transform the factor column to numbers as the lookup function wouldn't work otherwise.
September 26, 2023
Offline
Thank you. That should work. I hadn't considered the lookup column and was figuring this solution would require some complicated calculated fields or something. Your solution is much simpler.
Thanks,
Quercus.
1 Guest(s)
