I would like to automatically copy the unique values from a range. For example, C22:C30 contain values copied from C32:C50. When a new value appears within the C32:C50 it is automatically copied over to the next available cell within the C22:C30 range.
I've attached a spreadsheet illustrating what I want to do. The values in cell have been copied over. Ideally as new values appear within the lower rows they would be copied over. So if done correctly the values in the lower green cells would be copied over to blank green cells. Ideally, I would like the system to automatically add rows as needed instead of having to maintain a range of blank cells for it to use.
I think an easier way to say this is that every time a new value appears within C32:C50 it is copied over to the next available cell within the C22:C30 range. I would also like it to automatically had new rows as new values are found.
Bookmarks