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...
If you don't have Microsoft 365 or Office 2021, the FILTER function will not be available.
As an alternative, you can use Advanced Filter:
1) Create a Criteria range like this - I created it in I1:J3:
2) Select A1:H1 on the Scrubbed sheet., then select Data > Advanced.
Excel will display a warning, click OK.
Populate the dialog as follows:
Tick the option button ' Copy to another location'.
Click in the List range box and select the data on the source data sheet.
Click in the Criteria range box and select the criteria range on the source data sheet.
Click in the Copy to box and select the headers in A1:LH1 on the scrubbed sheet.
Click OK.
sorry i tried but failed, i m unable to understand it. and i m currently using office 2019