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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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