I have this scenario..Im not use if this is possible in excel...
I have a Range of cells in 1 column..E.g. Below
A
B
B
B
A
A
B
B
A
It continues on to a few 100k. Now I have a criteria which i will use to search for my range of cells.
Criteria e.g.
A
A
B
B
So i want to search for this particular pattern in my Long list of cells and locate the exact location of the pattern i specify. How can i Do this in Excel...
Anyone care to shed some light on this.
Bookmarks