Thread: [Solved] How do you add values in a column when determining the lowest amount within multiple groups
View Single Post
 
Old 09-06-2018, 02:13 PM
wheddingsjr wheddingsjr is offline Windows 7 64bit Office 2016
Advanced Beginner
  
Join Date: Mar 2017
Posts: 76
wheddingsjr is on a distinguished road
Default How do you add values in a column when determining the lowest amount within multiple groups
Hi all

I have a list of over 10k lines that include multiple groups. Within these groups are the columns "MEMBER", "TYPES", and "AMOUNTS". The TYPE is either a TC or 26. Regardless how many lines are within a single group, all amounts that are less than the highest amount has a discount applied to it based on the TYPE. TC types have a 50% discount applied to each amount that are less than the highest amount while type 26 has a 25% discount applied to them. Is there a formula that would allow me to do that? I am attaching a file with an example of what my intentions are.

Thanks
Attached Files
File Type: xlsx Example.xlsx (10.6 KB, 13 views)
Reply With Quote