Excel Function Needed

Reply #3

phileight — Wed, 02 Oct 2019 19:44:03 GMT

The files are not protected. It is a vba program. To access the vba code press alt f8. File name Cheech. The only file unles you have some. I Putin lots of comments (anything after a ), to help you follow the code.

questions ask here or pm

if your data is in same location you can just copy and paste the code to your file

Reply #2

cheech — Wed, 02 Oct 2019 14:00:17 GMT

Wow, that is exactly what I'm looking for. Hats off to ya !!

I tried, and tried on and on to get excel to do this task, but it was not 100% accurate especially when it came to a set/s having double or triple digits.

Lost some hair trying to do this task.

However this is what is really IMPORTANT to me.

How do I un-protect your work sheet in order to view all the subs.

Is their a password or way to un-hide the viewing of the sub statements.

I need to be able to view all the sub s... [ More ]

Reply #1

phileight — Wed, 02 Oct 2019 10:41:01 GMT

see if this is what you want. sub not function.

https://www.dropbox.com/s/6ubb0qmkg3eruzd/cheech.xlsm?dl=0

Excel Function Needed

cheech — Tue, 01 Oct 2019 14:33:04 GMT

Appreciate if a excel knowlegable member would post the correct excel function statement. 2010 0r office 365

I LIKE TO HAVE EXCEL CHECK A COLUMN OF 100 CELLS , EACH CELL CONTAINING 3 DIGIT SETS C1 (123) C2 (456)

EXAMPLE

COLUMN C DOWN

123

456

789

012

HAVING A INPUT CELL D10 TO ENTER A SINGLE 3 DIGIT SET #654 TO AUTOMATICALLY CHECK ALL THE SETS IN COLUMN C1:C100

IF COLUMN D CELL 10 INPUT CELL, FINDS 1 OR MORE MATCHING SETS #654 ANYWHERE IN COLUMN C1:C100 BOTH IN A EXACT