Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Conditional String Search with Excel?
#5
lionking Wrote:Where is your value locate at? I mean in what cell?
Could you give an example that you have the value that match "apple" and "X" so that I could have a clear picture of what are you talking about?

I'm sorry, not know English.

For example :
Quote: ExcelSheet KeyFind.Init("")
KeyFind.Activate
ARRAY(Excel.Range) KF
if(!KeyFind.Find("apple" KF)) out "not found."
out KF[0].Value; out KF[0].Column; out KF[0].Row
KeyFind.ws.Application.Goto(KF[0])
wait 1
KeyFind.GetRangeInfo("<sel>" 0 row)
KeyFind.SelectCell(2 row)
out KeyFind
↑Source Code↑"apple" text find
[Image: file.php?mode=view&id=687&sid=38642310ff...73bfaeb5a7]

But, I want Values ​​that match two conditions

For example :
"apple" and "O" = Do not search
"Pineapple" and "O" = Do not search
"apple" and "X" = True(search and A1224 Cell move)


I'm sorry. I don't speak English well.


Attached Files Image(s)
   


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)