I'm using this formula =COUNTIFS(RevenueALL!B:B,Sheet4!C13,RevenueALL!P:P,">0")) and it does indeed do what it's being asked to do. However, what I really need are two additional things. We can tackle them one at a time, but it may be valuable to know the endgame before we start. Here is what I need:
1. The formula needs to count each unique entry one time. If "Vanilla Beans" shows up thirty seven times, it will only count as one.
2. Understand that due to inconsistent data entry, there may be several ways "Vanilla Beans" may have been entered. "VanillaBeans" and "Vanilla_Beans" are two possible examples. All forms of Vanilla Beans should count equally. There are about 75,000 lines in this report and it's likely that other unique entries such as "Vanilla Ice Cream" and all forms it could come as "Vanilla_Ice_Cream" etc., may exist and need to count separately from any form of "Vanilla Beans".
Thanks in advance.
1. The formula needs to count each unique entry one time. If "Vanilla Beans" shows up thirty seven times, it will only count as one.
2. Understand that due to inconsistent data entry, there may be several ways "Vanilla Beans" may have been entered. "VanillaBeans" and "Vanilla_Beans" are two possible examples. All forms of Vanilla Beans should count equally. There are about 75,000 lines in this report and it's likely that other unique entries such as "Vanilla Ice Cream" and all forms it could come as "Vanilla_Ice_Cream" etc., may exist and need to count separately from any form of "Vanilla Beans".
Thanks in advance.