Forum Discussion
How search one value in excel and get all results?
Yousef72_Yud , there are these 500 values kept? If you have your main list with dozen thousand of records and another one with 500 values, based on which you'd like to extract data from the first list, with Power Query you may query both lists, merge them for values only from the second list and land result back to Excel sheet.
Why don't you use 'Filter' option for searching a value?
May be 'find all' function help you.
Thanks for your answer. Becuase i have so many values to search and excel filter don't show the results more than 10000 , filtering can't help. I will try find all function . thanks
Yousef72_Yud , by the way, 10000 is the limit only for drop down list, filter itself has no limits
SergeiBaklan
Thanks
I there a way to filter almost 500 values at the same time?
can you please how can i access to that filtering system?Yousef72_Yud , there are these 500 values kept? If you have your main list with dozen thousand of records and another one with 500 values, based on which you'd like to extract data from the first list, with Power Query you may query both lists, merge them for values only from the second list and land result back to Excel sheet.