I have enclosed an example sheet of what I am looking for.
The first problem i have is I need to concat the description of two different columns, in various combinations.
I then need to sum the quantity with these combinations too.
I have explained and shown the results I m aiming for in the sheet.
any help much appreciated.
I can not follow either your explanation or the sample sheet. Please SHOW us exactly what you want... where you want to see it.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
You're not alone, Glenn - I have been scratching my head for some time (thought I was missing the obvious).
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Ok thanks.
I have uploaded a Rev A, which I hope makes more sense?
Sorry, I just don't get this at all. I fall at the first fence. There are two "tables" in data. I don't really understand which one I'm supposed to be looking at. I don't understand the relationship between them. You're familair with your data, I'm not... if I can't quickly see where you want stuff to come from and go to... I give up,
So... sorry, but over to others.
Is this any different to the first workbook?
Yes I have put more description in the cells.
Doesn't matter I will have a think how to move forward.
Thanks both for looking.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks