Searching a cell value for a Character

[dsexpress]

Hi all,
Thanks for all the help so far. I have a final challenge for my program.

I want to test a cell for the type of value as 678/256 or 345/872/098/987 etc. The common character in each would be the "/". First, I need to check the cell for this, then take the first number and compare it to an integer(if it is <> , or = to). I hope I am clear with my situation. All help is welcomed

[NBVC]

You mean something like:

Please Login or Register  to view this content.

where A1 contains original code and B1 contains number to compare to.

[dsexpress]

Thanks,
I can play with those statments. what I am looking for is something like:

If cells(i,"G").value contain "/" then flag=1
If flag=1 then retrieve "first number" of value as integer

[NBVC]

If you were looking for a VBA solution, you should've posted in the Programming forum...

We'll see if someone with VBA skills will join and add a suggestion.

[dominicb]

Good afternoon dsexpress

For clarification - are you wanting to extract each number from the string in a cell?
What are you hoping to compare them to?

DominicB

[dsexpress]

I just want to get the first number: eg

289/345/896 result would be integer 289
23/45 " " integer 23
684/234/123/456 ' '' integer 684


I am then comparing this value to a sum of numbers in a collection of cells

Thanks

[dominicb]

Hi dsexpress

This code will do what you want, but in the absence of guidance from yourself, it will take its value from A1, and subtract from that the sum of values in range B1:B10, and then display the result in a MsgBox :

Please Login or Register  to view this content.

HTH

DominicB

[dsexpress]

Yes, thanks
That helps with the extraction. I just need to test the cell for contents of "/". I am going to assume the find function?

[dominicb]

Hi dsexpress

I just need to test the cell for contents of "/". I am going to assume the find function?

I'm not sure what you mean. Do you want to test first whether the cell contains a "/"? If so what do you want to do if a "/" isn't found?

If I've got it totally wrong and am barking up the wrong tree, explain to me exactly what you mean.

DominicB

[dsexpress]

I appreciate your patience. Ill try by example:

For i = 1 to 17
If cells(i,"G").value = ( 234/45/67 (value with "/") ) then flag=1
a= a+cells(i,"K").value
next i

Case flag=1
if a<>234 then color cells(i,"G").value (First Number only) red

I hope thats better

[dominicb]

Hi dsexpress

I appreciate your patience. Ill try by example

OK, I think I see where you're trying to go now. See if this meets your needs :

Please Login or Register  to view this content.

HTH

DominicB

[dsexpress]

wouldn't Ex be a string? If so, do I need to convert it?

[shg]

This seems to follow the logic of your pseudo-code:

Please Login or Register  to view this content.

[dsexpress]

Thanks all,
Feels great to have this done after ####### hrs.....

[dsexpress]

How do I lable this thread closed?

[shg]

No need .