Hey Victor,
I'd create a Helper Column with this formula and only use your states if the helper is =1.
=COUNTIFS(I$2:I3,I3,E$2:E3,E3)
See attached with the helper column.
Need Helper Column.xlsx
Hey Victor,
I'd create a Helper Column with this formula and only use your states if the helper is =1.
=COUNTIFS(I$2:I3,I3,E$2:E3,E3)
See attached with the helper column.
Need Helper Column.xlsx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks