Forum Discussion
Solved
Extracting data from a list without duplicate (repeating entry)
Hi Community, I need help with my template creation with regards to extracting data from another sheet with multiple criteria. I hope somebody could provide solution to my problem. On the fil...
Hi,
In general what end user shall know about Power Query is how to use Refresh button. I guess they are not familiar with template formulas as well.
Anyway, to select unique items with additional filter could be like
=IFERROR(INDEX('Internal Calculation'!A$2:A$300,MATCH(1, INDEX(('Internal Calculation'!B$2:B$300=$C$2)*(COUNTIF(A$10:A10,'Internal Calculation'!A$2:A$300)=0),0),0)),"")Please note, that's not an array formula. It's in Activity fee (2) sheet attached.
How do I create a post on this page?
Anekapb , if that's a new topic please go to https://techcommunity.microsoft.com/t5/Excel/bd-p/ExcelGeneral and start new conversation.
If that's the same topic you already make a post here.