how to extract number of cells from great numbers of data sheet.

%3CLINGO-SUB%20id%3D%22lingo-sub-2421578%22%20slang%3D%22en-US%22%3Ehow%20to%20extract%20number%20of%20cells%20from%20great%20numbers%20of%20data%20sheet.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2421578%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20All%3B%3C%2FP%3E%3CP%3EHope%20my%20message%20finds%20all%20of%20you%20well.%3C%2FP%3E%3CP%3Ehere%20is%20a%20sales%20sheet%20%3A%3C%2FP%3E%3CTABLE%20border%3D%221%22%20width%3D%22100%25%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2220%25%22%20height%3D%2230px%22%3E%3CSTRONG%3EPharmacy%20code%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%20height%3D%2230px%22%3E%3CSTRONG%3EName%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%20height%3D%2230px%22%3E%3CSTRONG%3EAddress%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%20height%3D%2230px%22%3E%3CSTRONG%3Eproduct%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%20height%3D%2230px%22%3E%3CSTRONG%3Esales%20quantity%3C%2FSTRONG%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2220%25%22%20height%3D%2230px%22%3E765071%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%20height%3D%2230px%22%3Efaid%20el%20kareem%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%20height%3D%2230px%22%3Eelbitash%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%20height%3D%2230px%22%3EZisrocin%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%20height%3D%2230px%22%3E35%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2220%25%22%20height%3D%2230px%22%3E765018%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%20height%3D%2230px%22%3EFadda%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%20height%3D%2230px%22%3EAgamy%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%20height%3D%2230px%22%3EHeli-Cure%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%20height%3D%2230px%22%3E55%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2220%25%22%20height%3D%2230px%22%3E765030%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%20height%3D%2230px%22%3EInas%20hammad%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%20height%3D%2230px%22%3EDaraysa%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%20height%3D%2230px%22%3EModazar%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%20height%3D%2230px%22%3E10%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EThis%20sheet%20containing%20more%20than%20166%2C000%20rows%20(duplication%20occurs%20only%20in%20the%20first%203%20columns)%3C%2FP%3E%3CP%3E%3CSTRONG%3Emy%20goal%20is%20to%20extract%20my%20customer%20codes%20from%20this%20sheet.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Ei.e%20%3CSTRONG%3EI%20have%20to%20find%20my%20customers%20(%20about%2010.000%20pharmacy)%20by%20using%20their%20known%20codes%3C%2FSTRONG%3E%2C%20within%20the%20sheet%20which%20containing%20about%20166%2C000%26nbsp%3B%20pharmacy%20codes.%3C%2FP%3E%3CP%3EThanks%20and%20Warm%20Regards.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2421578%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2422748%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20extract%20number%20of%20cells%20from%20great%20numbers%20of%20data%20sheet.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2422748%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1072676%22%20target%3D%22_blank%22%3E%40Abdul-Rahman%3C%2FA%3E%26nbsp%3BYou%20don't%20really%20give%20away%20much%2C%20but%20I%20suspect%20that%20Power%20Query%20could%20be%20of%20help%20in%20this%20case.%20A%20great%20tool%20that%20can%20handle%20large%20data%20sets%2C%20provided%20you're%20not%20on%20a%20Mac.%20And%20166K%20rows%20of%20data%20isn't%20all%20that%20spectacular.%3C%2FP%3E%3CP%3EProvide%20more%20information%20(perhaps%20upload%20a%20file%20with%20a%20few%20hundred%20rows%20of%20data)%20and%20explain%20what%20you%20would%20like%20to%20see%20a%20result%20from%20those.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Dear All;

Hope my message finds all of you well.

here is a sales sheet :

Pharmacy codeNameAddressproductsales quantity
765071faid el kareemelbitashZisrocin35
765018FaddaAgamyHeli-Cure55
765030Inas hammadDaraysaModazar10

This sheet containing more than 166,000 rows (duplication occurs only in the first 3 columns)

my goal is to extract my customer codes from this sheet.

i.e I have to find my customers ( about 10.000 pharmacy) by using their known codes, within the sheet which containing about 166,000  pharmacy codes.

Thanks and Warm Regards.

2 Replies

@Abdul-Rahman You don't really give away much, but I suspect that Power Query could be of help in this case. A great tool that can handle large data sets, provided you're not on a Mac. And 166K rows of data isn't all that spectacular.

Provide more information (perhaps upload a file with a few hundred rows of data) and explain what you would like to see a result from those.

 

@ Riny_van_Eekelen
Thanks a lot I will give it a try.