MS Excel / VBA help thread

You are reading a single comment by @aggi and its replies. Click here to read the full conversation.

•

hugo7
Does anyone have a sense of how hard(?) this will be for Excel:
- I have a list of 2-200 rows with Ids (list A) that will vary from time to time, and a list of 16k rows (list B) that will be static (or sometimes updated)
- I want to lookup ids in list A to check if they appear in list B.
Will looking up against a sheet with 16k rows be fine or will it constantly fuck up?

Cheers.

•

aggi in reply to @hugo7

Easy and quick. That's pretty small datasets, it took a fraction of a second to calculate on my 6 year old laptop.

Just use an xmatch or whatever you want to get a clean result.

About

@aggi started