This (Excel: How do I reference an entire row except for a couple of cells?) question has title of what I want. However text and answers are about finding range in a column..
Detailed question.
I have series of numbers in columns D,E,F,G,H,..... to last column.(say CCC). How to find max and fill in column C for corresponding row.
Current work around is to assume column to be AAA (or such last )and use formula as it is
=MAX(D2:AAA2)
How do I refer the really last column in the row?
MAX(D2:AAA2)
work?AAA
?