Hello!
This is my formula as of right now:
As it is, it counts the number of distinct rows (based by Number) which has Color as "Orange" and EmployeeCard as "Orange". I'd like to modify this formula to also count the rows which have "Orange" in Color OR "Orange" in EmployeeCard.HTML Code:
So while the actual count gives me 1 (one row) it should give me 2 (two rows).
Any help appreciated!
Note: Dynamic table, Excel 2010.
Bookmarks