inharmony222
New Member
- Joined
- Sep 19, 2019
- Messages
- 4
Hello,
I am just starting to learn formulas in Excel. I have created a "count if" formula looking at multiple columns but I need to exclude duplicate rows based on a value (being a number) listed in column A.
My current formula looks like this: =COUNTIFS(E2:E1000,"NO",H2:H1000,"NOTIFICATION")
How can I add in a way to make it only count one of any # in column A that have a duplicate #.
Oh, I have also added conditional formatting already to column A so it formats color fill to any duplicates after the first, if that helps with a formula.
Thanks!
I am just starting to learn formulas in Excel. I have created a "count if" formula looking at multiple columns but I need to exclude duplicate rows based on a value (being a number) listed in column A.
My current formula looks like this: =COUNTIFS(E2:E1000,"NO",H2:H1000,"NOTIFICATION")
How can I add in a way to make it only count one of any # in column A that have a duplicate #.
Oh, I have also added conditional formatting already to column A so it formats color fill to any duplicates after the first, if that helps with a formula.
Thanks!