Hello,
I have a huge Crystal Report that I use to feed one of my quarterly forms. The name fields I am searching often contain middle initials, middle names, prefixes or suffixes. Our compensation roster searches each string for matches to first and last name, and then reports corresponding data offset a number of a rows and columns. (Crystal Reports don't covert well to Excel files and always injects 5-10 rows and 5-10 columns per statistic.)
For the purpose of whom I'm handing this off to, I need to find a way to generate the data without using arrays.
Assuming A:A has strings, B:B has values, can I retrieve values of B where C and D both appear within A?
index-search no array.xlsx
Bookmarks