Forum Discussion

syazaaoa95's avatar
syazaaoa95
Brass Contributor
May 04, 2023

Can IndexMatch works with filtering the data I wanted?

I'm curious. I wanted to know, is there a way on how to create an Index Match and as for me, I am trying to look up the stock ID in  a thousand of datas and wanted to take it out the data so that I c...
excel
Macros and VBA
JKPieterse's avatar
JKPieterse
Silver Contributor
May 04, 2023

syazaaoa95 Can you please explain a bit more about your work process? Are you saying you need to filter for the same list of stock IDs each time?

In the attached I used Data, Advanced filter to filter for the IDs you mentioned. To filter again, click Data, Advanced filter and make sure the correct cell addresses are in the box.

  • syazaaoa95's avatar
    syazaaoa95
    Brass Contributor
    May 05, 2023

    JKPieterse  I gave you the example the kind of data I wanted.

    Because I wanted to do it more faster/ efficient. 

    Right now, I'm using filter on Stock ID > choose Filter "Begin with" > then enter the Stock ID for example "BDT" > then it filter out.

    After it filter out, I copied the filter data, and I transfer it to new sheet. and categorize it in new column, every data with Stock ID begin with BDT will be Toner. 

    I repeat with next Begin with Stock ID.
    BDB - Blade
    BDCT - Toner Chip

    BDD - Drum
    BDDE - Developer
    BDUHR, BDLHR - Roller

    BDP - Spare Part

    Then I do it for the rest of the ID's.

    You understand my process. 
    I'm thinking is there any way for it to be more faster and efficient? hmm

     

      • syazaaoa95's avatar
        syazaaoa95
        Brass Contributor
        May 05, 2023

        JKPieterse What does this mean? 


        I wanted to refresh after I entered this one.

         

        The last row there. It's that where I supposed to add my data?

Resources