Forum Discussion
Extracting data from a list without duplicate (repeating entry)
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.
Thanks for your reply
The problem is that users of the template are not familiar with Power Query or any advance stuff and could only do little editing i.e. filter, group, hide row/column, color format.
By the way, I thought of using codes to make it flexible but there is one problem I have
In the "Activity Fee" tab, how can I make it that, whatever the activity code I put, it will retrieve only the codes associated to that activity (with no duplicates) from the "Internal Calculation" tab.
Currently I found a formula that can retrieve only unique values but it is for the whole column, I wanted to add a criteria to it which is the activity code value above.
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.