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?

6
  • Are all the rows the same length?
    – LDC3
    May 30, 2014 at 4:56
  • yes. we can assume so
    – Jayan
    May 30, 2014 at 7:19
  • I'm very lost as to what the problem is... What cells do you want to exclude? Why doesn't MAX(D2:AAA2) work?
    – Dave
    May 30, 2014 at 9:23
  • How do I refer the last column in the row? Tomorrow if there is data beyond AAA2 say at BBB2?) it will not come in query.
    – Jayan
    May 30, 2014 at 9:35
  • Oh, I'm sorry. So, is your question how to reference columns past AAA ?
    – Dave
    May 30, 2014 at 9:36

1 Answer 1

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)

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .