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...
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.
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.