Excel help, please...
I have a range of 1,000 number ids and I want to identify those numbers that also appear in another smaller list of numbers on another worksheet, and mark or identify them somehow, so I can then filter them out
I'm sure it's easy, but I'm tearing my hair out here...
Posted By: Yellalee, Jul 29, 16:03:08
Follow Ups
- 1You can also use the count function...
Posted By: wobbly, Jul 29, 17:39:56 - ULookup....
Posted By: Pixelman, Jul 29, 17:26:05 - did you try ....errrr...smelling up....the.....USB
Posted By: usacanary, Jul 29, 17:02:33 - 2v look up. easy
Posted By: robotbear, Jul 29, 16:42:37 - 2I'd use different coloured text highlighters
Posted By: CB41, Jul 29, 16:32:54 - 2Ooh ooh, me sir!
Posted By: trafford_canary, Jul 29, 16:15:00 - Can do it with a VLOOKUP surely?
Posted By: JD3, Jul 29, 16:07:15 - 16I say, numbers, I mean alphanumeric ids
Posted By: Yellalee, Jul 29, 16:04:46
Reply to Message
Written & Designed By Ben Graves 1999-2025