2

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.

enter image description here

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?

Community
  • 1
Jayan
  • 371

1 Answers1

3

I'm not sure why you're trying to reference ZZZ, as far as I know, Excel 2010 only goes up to XFD as the furthest (maximum) column

I can use the MAX as you described

=MAX(D2:XFD2)
Dave
  • 25,513