G
greenfox88
I would appreciate it if someone could give a bit of direction.
I have a large spreadsheet - 139 cols by 170 rows - and I need to
extract data from certain columns in certain rows. I'm thinking that I
need to 'lookup' each label: about seven of them, and return for each
of those lookup data from all 139 columns.
ie: blue, red, purple, orange as row labels; getting date from jan2,
jan3, jan4, jan5 ... columns.
this date would go into a data list, under the columns: blue, red etc.
I can do lookups, have some experience with arrays, and have worked
with simple loops.
I'm just not sure where to begin, I would be happy with basic
guidlines about where to start, or just an outline of what I need to
do.
Thanks for your consideration
Andrew
I have a large spreadsheet - 139 cols by 170 rows - and I need to
extract data from certain columns in certain rows. I'm thinking that I
need to 'lookup' each label: about seven of them, and return for each
of those lookup data from all 139 columns.
ie: blue, red, purple, orange as row labels; getting date from jan2,
jan3, jan4, jan5 ... columns.
this date would go into a data list, under the columns: blue, red etc.
I can do lookups, have some experience with arrays, and have worked
with simple loops.
I'm just not sure where to begin, I would be happy with basic
guidlines about where to start, or just an outline of what I need to
do.
Thanks for your consideration
Andrew