Find values in a large spreadsheet

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?

 

Thanks~

Megan

By: Megan

Leave a Reply

Your email address will not be published. Required fields are marked *