Formula:
Please Login or Register to view this content.
Using this formula I would like to have the name of a drink be moved to the column where this formula is when the restock column says YES (column D). I'm fairly confident the solution is to add another part of the formula to say dont bring duplicates but this is beyond my expertise.
Hi
Try these formulas for name and quantity In G2 and H2
Formula:Please Login or Register to view this content.
Try this formula
Formula:Please Login or Register to view this content.
and this one for the quantities
Formula:Please Login or Register to view this content.
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Try this in G2:
Enter with Ctrl+Shift+Enter to create an array formula. Then put this in H2:
Please Login or Register to view this content.
Now copy G2:H2 down to G65:H65. Change the 65 in all formulas if you add new stock items.Please Login or Register to view this content.
WBD
Office 365 on Windows 11, looking for ✶ rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks