No Macros/vba: Offset Manipulation for data retrieval, 2 columns
Posted on 2010-01-09
I have two columns:
about 3000 rows
I'd like to add a third column that looks like this:
shirt red | shirts, pants
pants red | shirts, pants
goes on and on.
The first option to get the first red item is easy:
Assuming red is in G13 and the list starts in G12: =OFFSET(G14,MATCH(G14,$G$12:$G$2706,0),-1)
Finding populating the next items has proven more difficult.
I cannot use a macro for this, please take this into consideration. Also, arrays prove to be unwieldy for the reporting tool during presentation.
Please advise & Happy New Year!