Dear Experts,
I have scenario that I need to calculate the values of Other items which are not listed in the Master Items
Attached the file for your reference. Please guide me.
Dear Experts,
I have scenario that I need to calculate the values of Other items which are not listed in the Master Items
Attached the file for your reference. Please guide me.
Put all data on 1 sheet.
Use column B as helpcolumn and use VLookup to determine if the article is other.
After that you can use a pivot table to analyze your data.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
May be try with the below
Formula:Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
Try this......
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
thank you it works. But my only worry is that if my master items list is more than 20 which will be resulting in big formula (F4,F5,F6...F20).
Is it possible like <>F4:F25.
Thank you Experts. It does exactly what I needed. great!!!
Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks