Hello,
I Want a Help with Excel Function for Extracting a Unique Values with Multiple Criteria in attached Data File.
There are few activities have been done in certain places listed as Section and this activity will be assigned to different Work-Orders.
I have created Summary Sheet First and have added all section & all work-order list using Data Model.
What I want in Summary Tab is that "If I change section & work-order in above both tabs then Unique Value of all activity which is been done in that particular section corresponding to work-order has to lookup"
If For Example, If
Section: Brisbane
Work-Order:KE-79
then my expected result in activity tab will be all the activity that have been done by them but only Unique, then I will Use it for with Sumif formula to create a summary report.
Bookmarks