List with multiple points is created if certain criteria are TRUE

[kipminorball]

I will write a simple example of what I am trying to do. Thanks in advance for any help provided.

EXAMPLE:

The following discounts were applied: (This would be the 'heading')
Discount 1 (Depending on if certain criteria are met 0 or up to 6 discounts could need listed)
Discount 3
Discount 6

(I have it working currently so that if the criteria is met the discount names are populated under the heading but it would look something like this)
The following discounts were applied:
Discount 1--- ---Discount 3
--- ---Discount 6

(Is it possible to have them listed like in the top example, so if only example 6 was TRUE then it would say Discount 6 where Discount 1 currently is, and if all the discounts were true it would put them in a list and shift any text below it down depending on how many discounts were TRUE?)

I know this isn't a very clear example but I'm just not quite sure how to explain it.

Thanks Again

[PFDave]

You can achieve this with an array formula however we're going to need to see an example file, with dummy data if required, to set this up to suit you

[kipminorball]

Thanks, I will attach one.

[JeteMc]

Paste the following formula in Discounts!A7 and copy down:

Please Login or Register  to view this content.

Test by changing any of the cells in column B of the Selection sheet to NO.
Let me know if you have any questions.

[kipminorball]

=IFERROR("-"&INDEX(Selection!A$2:A$5,AGGREGATE(15,6,(ROW(A$1:A$4))/(Selection!B$2:B$5="Yes"),ROW(A1))),"")

The bolded 'ROW' section what is this doing for the formula?

Also the AGGREGATE(15,6 Part I don't understand.

[JeteMc]

The first time that the ROW function is used it provides four numbers for the numerator, which corresponds with the four possible discounts.
The second time that the ROW function is used it is a counter for the 15 argument of AGGREGATE which is SMALL, so that in the first row it will find the smallest row, from Selection!B2:B5 that has a yes, in the second row it will find the second smallest row and so on.
The 6 argument tells the AGGREGATE function to ignore error values.
A good way to see how this works would be to change Selection!B3 to No, then select Discounts!A8, which should read - Discount 3, and from the Formula tab run the Evaluate Formula.
Let me know if you have any questions.