Forum Discussion
DomeP
Apr 16, 2022Copper Contributor
Excel Help
Hi All Taking on board a suggestion, let's try again with some pic: Let's say i have 1 sheet whit the below: - ingredients codes are selected from a drop down list and ingredien...
mathetes
Apr 16, 2022Gold Contributor
You concluded with:
Hope the above is clear enough to get a solution
The fact that you've had nearly 60 views and no replies may tell you that your hope has not been realized. It wasn't clear enough. At the very least, post some images of the two sheets (just making sure that no names of real customers are revealed)...to help us visualize the level of detail and its organization.
If it's possible, again without revealing identities of customers, it would be even more helpful to put a link to the file if you have it on OneDrive or in Google Drive.
- mathetesApr 18, 2022Gold Contributor
Looks more like Power Query would be the necessary tool now, and on my Mac I don't have that. So here's calling some of those who know that tool. SergeiBaklan @Riny_van_Eekelen @Hans Vogelaar
- DomePApr 21, 2022Copper Contributor