Forum Discussion
data extract
i have uploaded the file , i have a huge data of such type and this is just an example data to understand. basically i want to know a formula or function through which i can fetch my required data f...
i m unable to apply this formula , please if you can show me once. In my excel it is not showing any formula of filter rather filterxml it showing.
As variant that could be Power Query with two steps if create helper table with codes to filter
as
let
Source = Excel.CurrentWorkbook(){[Name="SourceData"]}[Content],
#"Filtered Rows" = Table.SelectRows(Source, each List.Contains( Filter[AGENT_ID], [AGENT_ID] ))
in
#"Filtered Rows"- sorry i didn't understood.
i have a huge data to sort and fetch , it is very time consuming to select filter and copy and then paste.You don't need to select something and copy/paste. The only you need is to click on Refresh All when new data appears.