Good Day All!
While i've made some progress on this it is not 100% at this time. The following formula reviews cells (16) in a row and returns the column header. Unfortunately, if there are two cells in the same row that have the same max amounts the formula will only return the first column header (reading left to right). How would I achieve the result to list the column headers with the same max amounts, assuming that in some cases there may be more then one?
=INDEX($C$2:$R$2,1,MATCH(S294,C294:R294,0))
any assistance with this is greatly appreciated.
mrio
Bookmarks