Hi all,
I've got two columns (A & G) that contain product codes.
I need a formula that if any of the cells on column G match A2, then it copies the cells next the match cell in column G.
So if G22 matches A2, then I would need to see, H22, I22, right through to AG22.
Not sure if that makes much sense....
I would use a pivot table for that.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Anything other than a pivot table? It's not really ideal for my needs.
I mean, yeah you can build a slick combination of formulas that are much more complex than a simple pivot table, sure.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks