topic Re: How to create a formula to check if two columns are equal? in Discussions

How to create a formula to check if two columns are equal?

fully-yully — Mon, 17 Nov 2025 05:59:05 GMT

Hi everyone,

I would like to sort my data based on whether the value in one column matches the value in another column. Both columns are numeric (continuous scale).

What kind of formula should I use in a new column to check for this equality?

For context, I am trying to identify cases where "Total Number of Biopsies" (Column A) is equal to "Number of Positive Biopsies" (Column B). My goal is to find the cases where all biopsy specimens taken were positive.

Thank you in advance.

Re: How to create a formula to check if two columns are equal?

jthi — Mon, 17 Nov 2025 06:26:29 GMT

You can use direct equal comparison or calculate with Col Sum() == value

Re: How to create a formula to check if two columns are equal?

txnelson — Mon, 17 Nov 2025 10:26:33 GMT

To create a column that has a value of 1 if column A is equal to column B and has a value of 0 if this is not true do the following:

Create a new column
Right click on the column and select Formula to add a formula to the column to do the calculation
Type in the following formula
```
If( :A==:B, 1, 0 );
```