Good Morning
I have multiple columns of data all sorted descending.
The first occurence in column A will be "35=8". However from that point onwards the cells can contain any data. I want to use the FIND method and the NOT operator i.e FIND NOT "35=8" to determine where the next entry outside of 35=8 occurs. I will then shift all the data onwards to the right.
I have tried multiple variations but can't seem to get it work.
Can anyone help ?
Thanks
Jason
Bookmarks