Quote:
Originally Posted by ArviLaanemets
is it possible to get all 3 columns of data returned without applying any conditions.
|
Yes, with the likes of:
=INDEX(Table13,ROW(Table13)-ROW(Table13[#Headers]),{1,3,4})
See
Sheet1 (2) of the attached.
If you want to include headers in the result:
=INDEX(Table13[#All],ROW(Table13[#All])-ROW(Table13[#Headers])+1,{1,3,4})