Excel question from Bob (i'm running out of private msg)

Reply #7

Bob — Sat, 15 Feb 2020 23:51:19 GMT

Hi ED,

Thank you it is working super...It was my fault

that it wasnt working right ...OK got it going

thanks to you...

bob

Reply #6

Bob — Sat, 15 Feb 2020 23:12:47 GMT

Hi ED,

not working right...

not listing right... anyway wanted it

to work like

all 389

2398----2398

3879----3879

3890----3890

thank you ....I know it is lots of work..

butt Thank you ahead of time..

bob

Reply #5

nibor200 — Sat, 15 Feb 2020 21:51:50 GMT

Hey Bob,

I didn't know this was a rush item :)

Here is what I've come up with (pick4 makes it more involved for a formula approach)

put the 3 digit number in cell K1 and the following formula in cell B1 and copy and paste as far down in the B column as your data in the A column goes.

=IF(LEFT(TEXT(A2, 0000 ),3)=TEXT($K$1, 000 ), TRUE TEXT(A2, 0000 ),IF(LEFT(TEXT(A2, 0000 ),1) RIGHT(TEXT(A2, 0000 ),2)=TEXT($K$1, 000 ), TRUE TEXT(A2, 0000 ),IF(LEFT(TEXT(A2, 0000 ),2) RIGHT(TEXT(A2, 000... [ More ]

Reply #4

Bob — Sat, 15 Feb 2020 17:21:33 GMT

anyone know how to change the EXCEL Formula????

please do

Reply #3

Bob — Thu, 13 Feb 2020 20:50:04 GMT

Yes PICK4 ...Sometimes it is a easy one to explain

and than a hard one to explain the right way...

so yes it is a Pick 4 looking for 3 digits....

Reply #2

nibor200 — Thu, 13 Feb 2020 19:30:02 GMT

Hey Bob,

Could you reply with a specific numerical example of what you mean by find a 3 digits in a 4 number system?

Do you mean Pick4?

thanks,

Ed S.

Reply #1

Bob — Thu, 13 Feb 2020 18:33:48 GMT

Hi Ed,

Bob -- You helped me out with excel

a while back..Need help again if you have the time.

.Right now the formula is

for a 3 digit number finding 2 numbers.

Butt we tried to change the formula to find 3 digits

in a 4 number system...butt cant get it to work..

was wondering if you could look at it and give us help??

Hope we explained it right.

the single formula below is expecting your data

to be in column A and the digit

you are looking for, to be in cell K1

Excel question from Bob (i'm running out of private msg)

nibor200 — Thu, 13 Feb 2020 17:03:04 GMT

Bob,

1. We need to handle this request and any future others by open forum topics as I'm a Standard level member here so my private msg capability is limited and then I'll not be able to read any more of them.

2. Regarding your recent request ...

Could you make

a formula for the 4 digit that will

match 3 numbers?

We tried to change

the 2 digit formula that you gave us

for the 3 digit...

=IF(LEFT(TEXT(A1, 000 ),2)=TEXT($K$1, 00 ), TRUE TEXT(A1, 000 ),IF(LEFT(TEXT(A1... [ More ]