View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MGarrison MGarrison is offline
external usenet poster
 
Posts: 3
Default Cell offset issue

HI,

I am trying to have a row that references cells that are moving 1 down and 1
over. I want to caputure the last number in each column.

Example


A1 4 B1 C1
A2 7 B2 8 C2
A3 9 B3 4 C3 15
A4 B4 6 C4 10
C5 12

I am trying to create a row that will read
A6 9 B6 6 C6 12

NOT

A6 9 B6 4 C6 15

Thanks