Google Spreadsheet Post #2181
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jun-11-2017
question by Aleksandar Arsovski:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/BeOsYmx8l9k;context-place=forum/docs
Array formula Check Duplicate, First instance of duplicate to be Ok
Array formula Check Duplicate, First instance of duplicate to be Ok
Hi I need help with to modify arrayformula for Duplicate check up.
https://docs.google.com/
in B1 is my arrayformula which not functioning good, since I want first instance of the duplicate value to have Ok not Duplicate.
In C2 to C21 is how I want the result to look, and the formulas there are working as I want but I doesn't know how to make it work in Array Formula.
Any help appreciated.
Regards,
Aleks
https://docs.google.com/
in B1 is my arrayformula which not functioning good, since I want first instance of the duplicate value to have Ok not Duplicate.
In C2 to C21 is how I want the result to look, and the formulas there are working as I want but I doesn't know how to make it work in Array Formula.
Any help appreciated.
Regards,
Aleks
No comments:
Post a Comment