davidhall80
Well-known Member
- Joined
- Jul 8, 2006
- Messages
- 663
Hello All
I am trying to come up with a formula for Unique Values in a certain column with a filter in a different Column.
For Example: A Unique Count of items in Column A if Column B = 1....So the result should be 3. Thank You Very Much
ColumnA............ColumnB
1............................0
1............................0
2............................0
2............................0
2............................0
5............................1
5............................0
10..........................1
15..........................1
15..........................0
I am trying to come up with a formula for Unique Values in a certain column with a filter in a different Column.
For Example: A Unique Count of items in Column A if Column B = 1....So the result should be 3. Thank You Very Much
ColumnA............ColumnB
1............................0
1............................0
2............................0
2............................0
2............................0
5............................1
5............................0
10..........................1
15..........................1
15..........................0