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

[Abdul-Rahman]

Dear All;

Hope my message finds all of you well.

here is a sales sheet :

Pharmacy code	Name	Address	product	sales quantity
765071	faid el kareem	elbitash	Zisrocin	35
765018	Fadda	Agamy	Heli-Cure	55
765030	Inas hammad	Daraysa	Modazar	10

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]

@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.

[#3]

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