I have a spread sheet which currently has 600 rows and 225 colomns…
I have 10 main columns for detail sorting and then 215 for different Job codes I have posted AP to. I would like to create a column that returns the header that was selceted for each row. For most rows the indec find max function works fine.
What I am strugling with is a formulat that will return more than one value. I have some circomstances in which I have spilt where I coded them and I want to see all columns with information in the. Is this possible?