With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Friday, January 27, 2017
yogi_Look At Entry In Each Row Of Column D If The Entry Has Not Occured In Rows Above Mark 1 Otherwise Leave Blank
I need an array formula that will auto expand into new rows. The formula needs to search all previous rows only for a value from the new row. If it's present, insert a 1 into the cell, and if not, do nothing. Basically, I'm just checking if this is the first time the value appears in the sheet and if so, mark it with a 1. Future occurrences of the same value would be ignored.
Here's an example of the formula that works, if I manually copy it into each row:
I've tried every way I could think of to convert this to a working Array formula that would auto expand into all future rows but I cannot seem to find the right way to do it.
Any suggestions on how to make this happen, either with Array Formula or other ideas would be greatly appreciated!