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 have Microsoft 365 or Office 2021, select A2 on the Scrubbed sheet and enter the following formula:
=FILTER('source data'!A2:H11,(('source data'!A2:A11=112)+('source data'!A2:A11=512))*('source data'!C2:C11="CONNECTED"))
Thanks ! Will apply and get back to you within sometime.