Hello,
I am looking for a formula that will return the distinct values of a list based on a criteria.
For example...the formula would go into cell D4, and it would return the distinct "Item Names" in column B based on the "Group" in column A.
Any ideas?
Thanks!
Mike
I am looking for a formula that will return the distinct values of a list based on a criteria.

For example...the formula would go into cell D4, and it would return the distinct "Item Names" in column B based on the "Group" in column A.
Any ideas?
Thanks!
Mike