slamanager
Board Regular
- Joined
- Apr 20, 2007
- Messages
- 129
Hi,
Ive looked for several days now to get this formula working. I have a list in col D (text), in col A i look for a unique item in col D in col B i look for another unique value in col D these items dont match on the same row.
And here's the "but" when i do find my items in col B how do I combine them with my col A item then i can pivot the items to total them.
Normally i get one item in col A to multiple items in col B they are randomly spaced apart in the list, then i get a new item in col A so on and so on. I should have 11 items in A but may have less or repeats.
Ive looked at the formulas that "find value above cell" etc - my list starts at row 11 and only goes to row 5000
i used =LOOKUP(2,1/(A$1:A1<>""),A:A) from thread in MRExcel Re: Get first non-blank cell above a certain cell? posted by Rick Rothstein
Ive looked for several days now to get this formula working. I have a list in col D (text), in col A i look for a unique item in col D in col B i look for another unique value in col D these items dont match on the same row.
And here's the "but" when i do find my items in col B how do I combine them with my col A item then i can pivot the items to total them.
Normally i get one item in col A to multiple items in col B they are randomly spaced apart in the list, then i get a new item in col A so on and so on. I should have 11 items in A but may have less or repeats.
Ive looked at the formulas that "find value above cell" etc - my list starts at row 11 and only goes to row 5000
i used =LOOKUP(2,1/(A$1:A1<>""),A:A) from thread in MRExcel Re: Get first non-blank cell above a certain cell? posted by Rick Rothstein