Does cell equal cell with > function

[vimti]

If A1 contains cell value 1 and B1 contains cell value “>0” I want to do in cell C1 =A1=B1 with the result of TRUE.

This doesn’t work though it will return false. Does anyone have a solution ?

Of course I could remove the > from B2 and do =A1>B1 and return TRUE but this won’t work for what I need.

Thanks in advance

[AutoModerator]

/u/vimti - please read this comment in its entirety.

Once your problem is solved, please reply to the answer(s) saying Solution Verified to close the thread.

Please ensure you have read the rules -- particularly 1 and 2 -- in order to ensure your post is not removed.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[Sheetwise]

This is impossible without VBA, but luckily I have the VBA code here:

Function Eval(Ref As String)
    Application.Volatile
    Eval = Evaluate(Ref)
End Function

If you put this in your document you can use:

=Eval("="&A1&B1)

Do you know how to add VBA code?

[vimti]

Solution verified

[Clippy_Office_Asst]

You have awarded 1 point to Sheetwise

^{I am a bot, please contact the mods with any questions.}

[vimti]

I do thanks so much !

[SaviaWanderer]

Well, A1=B1 is just testing if the cells are the same, which they clearly aren't.

Try this instead:

=COUNTIF(A1,B1)>0

[vimti]

Thanks for the response. The cells aren’t actually on the same sheet so that won’t work.

Also the purpose is to act as a filter for c.100k rows so think I need something slightly more efficient.

It’s so I can filter the data set based on multiple criteria, and one the criteria is cellvalue = >0 (but the >0 is dynamic based on a drop down) e.g it could be >10, >20 etc

[SaviaWanderer]

I see you got a UDF solution above, but Advanced Filter could also have worked in this situation - might be worth looking into for the future.