Forum Discussion

Deepika_Nanda's avatar
Deepika_Nanda
Copper Contributor
Oct 20, 2021
Solved

Extract information

Hi,    I am looking to extract all values in a column that match a criteria. I have been using the FILTER function to do this easily in a system with Office 365 access but I am trying to do a simil...
Formulas and Functions
Macros and VBA
Deepika_Nanda's avatar
Deepika_Nanda
Copper Contributor
Oct 21, 2021

HansVogelaar Amazing, this works. Thank you. 

 

I also tried using the aggregate function to receive something similar. They both work. My only concern is, is there a way I can extend this formula to the end of the sheet so it applies to all cells in column (till the last row 1048576). I'm asking because  the data I have exceeds 50,000 rows in a lot of cases so I'd like to make sure the manual click and drag to as many as possible can be simplified. 

 

Thanks for your guidance, it is much appreciated!

mtarler's avatar
mtarler
Silver Contributor
Oct 21, 2021
I'm sorry but why don't you make it a table and use the filters or create a pivot table and/or use a slicer?
  • Deepika_Nanda's avatar
    Deepika_Nanda
    Copper Contributor
    Oct 21, 2021

    My file is extremely huge ( sometimes takes the whole 100,000 + rows) and the pivot table does not seem to help me when my data is dynamic and I could have search criteria that is not on the data itself. I'm going to give it another shot though.

Resources