How do you add values in a column when determining the lowest amount within multiple groups

wheddingsjr · #1 09-06-2018, 02:13 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
append multiple time values to date in one column	sarahafeez	Excel	1	09-25-2017 11:01 PM
2-Column layout breakes with images/groups	ben-in-m	Word	0	06-02-2017 01:26 PM
Multiple found values from five sheets, multiple returned values in sheet six?	irisha	Excel Programming	26	09-30-2016 01:20 AM
What formula can I use to find the lowest cell in a column that has a value in it?	EddyWD	Excel	3	04-20-2016 09:29 PM
Insert values from multiple rows based on value in one column	pachmarhi	Excel	3	07-18-2014 09:57 PM