I need to automatically select and perform operations on columns where the first record contains certain values. For example, if you refer to the picture below, I need to automatically select the columns where the first record contains the "/". Here, that's F2, F3, and F4. Other times, it could be different. How would I go about doing this?
Solved! Go to Solution.
isn't there any easier way to do this?
I can't think of an easier way off the top of my head, however this could probably be turned into a macro in order to simplify it for different usuages, (e.g. just provide the Formula and let the macro handle everything else).
@kpmg_lc_analyst Assuming the field names can change (or you would have to add another dynamic rename at the end with the field names you want), a dynamic select and dynamic rename may be a solution for you.