I can't seem to figure this out or find an already posted solution - any help would be amazing!
My dilemma - if the names below were in a column (approx 1,500 rows) I need a column beside them showing a 1 or a 0 ONLY once to note if the value is unique.
Is there a formula I can use for this?
The farthest I have gotten is using this formula but it only checks the rows below the lookup value and doesn't check the rows above it.
=IFERROR(IF(K3=VLOOKUP(K3,K4:K$2264,1,FALSE),0),1)
Example columns with last value showing the 1 and 0s that I need:
Region - Partner Name - Sales - Unique Identifier
Canada - James - $10 - 1
Canada - Rob - $5 - 1
Canada - James - $5 - 0
Canada - James - $25- 0
Canada - Stephanie - $10 - 1
Canada - Rob - $10 - 0
Canada - Rob - $5 - 0
Canada - Stephanie - $10 - 0
The reason this is needed is that I need to create a pivot table showing a count of number of unique names without actually showing the names in the pivot table.
Example of the pivot values that are needed from the example values above:
Region - # of Unique Partners - Sales
Canada - 3 - $80
Let me know if this makes sense and I am open to any other suggestions to achieve what is needed.
THANK YOU!
My dilemma - if the names below were in a column (approx 1,500 rows) I need a column beside them showing a 1 or a 0 ONLY once to note if the value is unique.
Is there a formula I can use for this?
The farthest I have gotten is using this formula but it only checks the rows below the lookup value and doesn't check the rows above it.
=IFERROR(IF(K3=VLOOKUP(K3,K4:K$2264,1,FALSE),0),1)
Example columns with last value showing the 1 and 0s that I need:
Region - Partner Name - Sales - Unique Identifier
Canada - James - $10 - 1
Canada - Rob - $5 - 1
Canada - James - $5 - 0
Canada - James - $25- 0
Canada - Stephanie - $10 - 1
Canada - Rob - $10 - 0
Canada - Rob - $5 - 0
Canada - Stephanie - $10 - 0
The reason this is needed is that I need to create a pivot table showing a count of number of unique names without actually showing the names in the pivot table.
Example of the pivot values that are needed from the example values above:
Region - # of Unique Partners - Sales
Canada - 3 - $80
Let me know if this makes sense and I am open to any other suggestions to achieve what is needed.
THANK YOU!