I have a unique key in column A and a number value in column K.
Based on the unique key (cuz there could be duplicates), I need a formula that will state that if there are more than 1 unique key then SUM column K. If column K's sum is greater than 1 then "Recycled" if not then "New New".
Here's the formula I currently have which is returning a #VALUE!.
SUM(IF(COUNTIFS($A:$A,A2)>1,"Recycled","Net New"),$K:$K)
Please help.
Thanks,
Not sure if I understood your problem correctly... the following formula will return "recycled" if the sum of all the K values associated with the key in cell A2 is greater than 1.
The following formula returns "recycled" if the key found in A2 is found multiple times in column A.
Please Login or Register to view this content.
Hope that helps!Please Login or Register to view this content.
That is what I needed. Thank you.
Your description is not as rigorous as it could be, but here's what I think you mean.Originally Posted by mphillips
If there is more than one key, then it's not unique. Instead of "more than 1 unique key" I think you mean "the key is repeated."
You didn't say so but I am assuming that this formula is intended to be used in each row of data starting in row 2 then copied down.
If the key in that row is not unique, then check the sum in column K only for that key. You didn't say it was only for that key, but that's the only way I can make sense of this description.
Note that you didn't say what you want the result to be if the key is not repeated, so you can blank out my red text if you want a blank result.
Formula:
Please Login or Register to view this content.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
I guess I was a little late here. If ThirdFret's solution is what you needed then I applaud the effort.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks