Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    INVERT RANGE OF CELLS (2000 sr 1)

    this sheet contain many data in the cells C3 : C71 i would want to invert this range in the range F3 : F71...

    I have make a little example in the cells F3 F4 F5...

    In effect the cell C3 go in the cell F71, C4 in the cell F70 ecc...

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: INVERT RANGE OF CELLS (2000 sr 1)

    I assume that you mean G3:G71 instead of F3:F71.

    Enter the formula =INDIRECT("C"&74-ROW()) in G3:G71 (the Italian name of the function is probably INDIRETTO). See attached version.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    The Hague, Netherlands
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: INVERT RANGE OF CELLS (2000 sr 1)

    A less volatile option...

    =INDEX($C$3:$C$71,ROWS($C$3:$C$71)-(ROW()-ROW(G$3)))

    which is entered in G3 and copied down.
    Microsoft MVP - Excel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •