Hi the data I have is in columns A and B and I want the output to be in F and G.
The output is very simple... it is just the selection of A and B where the B is different from the preceding B. The first few Bs are 5 and when it changes to 6, I want that pulled to the output side. When it changes again to 8, again and then once again for 4.
I do not want to use macros if possible. I have tried index, offset and match and couldn't get it to work. Any help would be appreciated.