View Single Post
  #1   Report Post  
Melonhead
 
Posts: n/a
Default Getting a cell reference to move laterally instead of vertically?

I have data that is sorted in columns, but the data I want to graph is a
cross section of this data and therefore it comes from one row across several
columns. I'm trying sort my graph/equation data in a column, however. Is
there a way to get the equation cell references to move across a row even
while the cell is descending a column?