MS Excel / VBA help thread

You are reading a single comment by @chez_jay 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.

•

chez_jay in reply to @hugo7

Seems easy enough to test both from a technical and user POV.

•

hugo7 in reply to @chez_jay

True. It's just getting 16k rows of data / being able to download a file from somewhere.

Actually I guess I could take one of the massive files I have, put it in pq and duplicate it until I hit 16k.

About

Avatar for chez_jay @chez_jay started