I have the following formula -
- however, this looks at the bottom of my data, and takes it from there... What I am after is for this to take it from the top (excluding headers, so row 2 downwards) -
COLUMN A is date
COLUMN B is data
COLUMN D is the number of rows of data I want returned. So if I have entered "5" in D2, at present it goes to the bottom of my data sheet, and generates the table/graph from that.... I need it to be rows 2,3,4,5 and 6 (based on 5 returns)...
Due to the data in the table I cannot simply flip the data around......
Thanks, as ever, to everyone in advance
Excel Formula:
=OFFSET(Sheet1!!$B$1,COUNTA(Sheet1!!$B:$B)-Sheet1!!$D$2,0,Sheet1!$D$2,1)
COLUMN A is date
COLUMN B is data
COLUMN D is the number of rows of data I want returned. So if I have entered "5" in D2, at present it goes to the bottom of my data sheet, and generates the table/graph from that.... I need it to be rows 2,3,4,5 and 6 (based on 5 returns)...
Due to the data in the table I cannot simply flip the data around......
Thanks, as ever, to everyone in advance