i have to filter 100 different rows using 100 different sku is down there help me guys

Copper Contributor

2466_Free_Flow_1500Ml_Box
2456_3Pc_Steel_Lid_Jar
2477_BW_Wall_Container_1100Ml
2453_HDL_Container_1100ml
0618_3_Sec_Cereal_Dispenser
2070_5Pc_Storage_Containers
0788_1600Ml_Transparent_4Sec_Disp
2141_4In1_Pickle_Container
0078_mt_4pc_dininig_set
2454_6Pc_HDL_Container_1100ml
0150_easy_flow_1700ml_1pc
0149_easy_flow_1100ml_1pc
2531_Spice_Jar_6Pcs_Set
2274_12Pc_Apple_Jar
0096_j_easy_flow_750_ml
2333_Premium_Container_1000Ml
2446_5Pc_Floral_Container
2259_Wall_Container_1100Ml
2332_Premium_Container_500Ml
0852_400Ml_Fiip_Container
2174_Rajwadi_Pickle_Set
0851_250Ml_Fiip_Container
0853_500Ml_Fiip_Container
2147_2Sec_Container_2Ltr
2149_Royal_Easy_Flow_3Pc
2325_Wall_Container_1500Ml
2286_Airtight_Matka_Bowl_6Pc
2334_Premium_Container_1500Ml
2298_Handle_Squ_Bowl_6Pc
0102_wooden_block_scissor_5pc
0679_SD_Yellow_Rubber_Gloves
0714_scrubber_gloves
0654_cut_gloves_orange
0673_Heavy_Gloves_Black
4661_Scrubber_Gloves_180G
0711_q1_microfiber_gloves
0666_flock_gloves_blue
2100_Peeling_Knife
2094_Brown_Cutlery_24Pcs_Set
2140_SS_Apple_Cutter
2103_Cut_N_Wash_Regular
2030_4In1_Lighter_Pack
2430_2_Stage_Knife_Sharpner
0092_knife_with_cover
2309_Rice_Washing_Spoon
0056_bird_fork
0087_apple_cutter
0082_electric_bbq_set
0126_barbecue_grill
2523_Cn_SS_Icecream_Scoop
0625_icecream_scoop
7030_Loose_SS_Garlic_Press
2281_Round_Garlic_Press
2108_Garlic_Cutter
2475_Wooden_chopping_Board
2572_5Pc_Chop_Board_Knife_Set
2417_Gray_Spatula_Stand
4693_LED_Wearable_Sport_Fan
2433_Vegetable_Drill_Cutter
4690_4Pc_Big_Sili_Hot_Mate
2565_Cn_Kitchen_Bowl_Holder
0155_M_Atta_Maker
0174_tooth_dispenser
0416_drill_bit_5pc
0422_toolkit_46pc_red
0421_toolkit_40pc
0428_holesaw11pc
0226_Snail_Soap_Dispenser
2582_3Pc_Steel_Cap_Bottle
2186_Simple_Water_Bottle
2505_Premium_Plain_Bottle
0364_notebook_bottle
1483_Toilet_Seat_Ladder

 

 

 

2207_Steel_Baking_Tray_Blk
2573_6_Cavity_Brownie_Pan
2211_Knife_Set_6Pcs
2148_Button_Coaster_5Pc
2164_Mini_Knife_Sharpner
2026_7Pcs_Spice_Box
0609_dining_jar_3pc
0095_12pc_spicerack
0100_6pc_spicerack
0097_8pc_spicerack
2198_Squre_Spice_Box
2242_4Pc_Stylish_Rack
2444_Crystal_Seasoning_Box
0122_g_jar_set_6pc
0163_spice_pickle_set
0608_dining_jar_2pc
0061_spicebotle_6pc
0069_spice_rack_16_piece
2251_Heart_Shape_Spicebox
2392_Round_Spice_Box
1711_Printed_Sharp_F_Cutter
1630_Round_Spray_Gun
1719_Prune_Saw_270Mm
1692_G_Spray_Bottle_400ml
1720_17X14inch_Flower_Pot
0840_Hanging_Flower_Pot
3850_Hanging_Flower_Pots
4614_Chex_Flower_Pot
3858_Wall_Pots
3854_Drip_Irrigation
1629_Solid_Spray_Gun
1635_Ez_Jet_Water_Cannon
0502_squirt_gun_50ft
1505_Premium_Grip_GTool_3Pc
0554_Garden_Leaf_Rake
0873_50m_twist_tie
0480_tools_straight
0839_6Inch_Planter_Pot
1677_3In1_Garden_Sprinklers
0582_steel_flower_cutter
0466_pruner_8in
0718_garden_gloves
0475_weeding_fork
0473_soil_meter
0790_SS_Sink_Strainer_Large
0791_SS_Sink_Strainer_Med
0792_SS_Sink_Strainer_Small
1637_USB_Bike_Light
0260_otg_1
7215_Optical_Computer_Mouse
0315_usblight_1pc
1302_Silicone_Body_Scrubber
2346_Oil_Dispenser_1Ltr
0458_glass_cutter_gold
1501_6In1_Torch_Screwdriver
0430_screwdriver_32in1
0573_hammer_nail_remov
2067_Kitchen_Pot_Holder_1pc
0146_gas_trolly
0754_dumbbells_bottle

2 Replies

@muba0713 

1-Copy all SKUs you want to filter in tab SKUs for instance

;JulianoPetrukio_1-1634392022920.png

Then:

2-Import the csv file

JulianoPetrukio_0-1634391814958.png

Then:

3-Advanced filter

JulianoPetrukio_2-1634392212019.png

Then remember to put as Criteria Range, all the SKUs you want to filter. On my example they are on tab sheet SKUs!$A$1:$A$74