2021-09-27_17-45-14.jpg
I attached the file for less confusion.
The goal is to evaluate columns B, D, F, and so forth and then output the values in B9, B10, B11 without reproducing duplicates or empty cell values.
In short, I want to find the colors or items needed (columns) and output them horizontally (rows), if possible. It was possible in Google sheets but I cannot get it to work in Excel.
I have been unsuccessful with TRANSPOSE and UNIQUE thus far.
Try this:Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Are you still using XL2003. If you have upgraded, then please update your profile to reflect the version you are using as this will dictate the solution options available. Also, there is no file attached as you have indicated.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Maybe this will work better:Formula:Please Login or Register to view this content.
Another optionFormula:Please Login or Register to view this content.
Thank you for the replies. I’m going to try these this morning.
Please update your forum profile, as requested earlier in the thread. Thanks.
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I plan on updating that also.Originally Posted by AliGW
Do it NOW, please. Thanks.
My profile has been updated to M365, it is has been some time since I have been on Office, my apologies.Another optionFormula:Please Login or Register to view this content.
Fluff13, your example is working flawlessly on a local copy on my hard drive, but once I transfer it to the web version via Sharepoint I am getting a #VALUE error.
FILTERXML does not work in the Web app. Sharepoint will not be the issue, rather WHERE the workbook is being opened (e.g. in a browser or mobile app).
I figured that was the case. Is there a potential workaround just using the web app.
How aboutFormula:Please Login or Register to view this content.
Fluff13,
That did it. Thanks so much for your help.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
Glad to help & thanks for the feedback.
You're welcome. Thanks for the rep.
@Fluff: makes my effort look over engineered … but, still, we learn
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks