Hi this is my first post on a Forum and I'm new to Array Formulas so I hope I have done this correctly.
My problem:
I have a list of items (Plant Name) in a table column and I'm consolidating the list on a separate Worksheet to remove duplicates.
The following code works fine for this step and I get a consolidated list with no duplications...
{= INDEX(Bedding_Table[Plant Name], MATCH(, COUNTIF($A$2:$A2, Bedding_Table[Plant Name]), 0))&""}
I then have a formula that adds up the Area and Total Plants from this list, which also works fine.
BUT I need to exclude the "-" item from the list. I currently filter the column results manually at the end to exclude the unwanted "-", but I'm sure this can be done within the formula.
I guess I need an IF() statement in there somewhere but I'm stuck finding a solution. Any ideas please?
Bookmarks