Excel Visual Basic Help

[Dannyboy11]

Hi

I have an IF formula that will calculate if two cells equal each other, then to display the value that they show and if they don't, then to display "No Root Found".

Is it possible that I can create a table and if the cell does not equal "No Root Found", then it will copy the content of the cell and add it to a table, but there can be no duplicates.

Is anyone able to help?

 

[noboffinme]

Hi

Do you want to use VBA or Excel formulas?

Maybe, several Excel formulas or nested Excel formulas would work but otherwise VBA would be able to do this for you.

Can you give some dummy sample data to get an idea of what you're trying to do?