Excel Trick 50 - Master Dynamic Range Grouping in Excel #exceltricks #shortsviral #excelsolutions

here we have got a sales data with customer name in column A and total sales amount in column B and over in column C basically we need to create uh the group based on the group by range that is provided in C2 so in case if you are going to do it manually it would be a time taking basically and that would not be dynamic it means every time user will change the group by value we'll have to come back and make this adjustment okay so to make it Dynamic we can utilize the flow function so let's start with that so first floor function and the first function the first part of the function we will use to create the lower bound of Bin basically so let's put this number as a reference that is B5 significance that would be C2 a close bracket then Ampersand and then hyphen here and ampersion okay the next function next part of this function would be uh to calculate the upper bound of this bin so again this number would be uh this one comma significance that will be this again plus then this one C2 now we are done

Channel: TheDataLabs

Views: 1,243

Keywords: Master Dynamic Range Grouping in Excel, How to Create Dynamic Range Grouping in Excel, Floor Function in MS Excel

Id: mtenM5NK8f4

Length: 1min 0sec (60 seconds)

Published: Mon Oct 02 2023