I have a huge database and I need to pull certain data from the database. I know how to search the database for single values, but I need to make a more advance search for multiple sequence of values.Not sure if it can be done but I did search for a similar thread in this forum and didnt find any. Any help is welcome.
I made this sample to make it much moree simplier.Lets say i want to search three values. 23 26 8. These values appear in row 3 5 and 7. So i want a formula to make a search in all rows for numbers 23 26 8 and give results only when all those 3 numbers appear in a row no matter the order or if other values interfering between those three values, highight those rows and write in cells the number of the rows that exist those values or write the date or time that those values appear.
Is my question understandable? Let me know if u have any thoughts
Thanks
Spiros.xlsx
Bookmarks