Notifications
Clear all
Excel Tables
2
Posts
2
Users
0
Reactions
91
Views
Topic starter
Hi!
I have been using an IF formula in a table to match row values from two columns =IF([@ColumnA]=[@ColumnB],"Match","")
I want to see whether any cells match in a row, for instance A1 or A2 or A3 or A4 = A1 or A2 or A3 or A4. I don't want to compare with values from any other rows. In the example below, I have only matched Systolic and Diastolic, but I want excel to retrieve the matches with Height and Leucocytes from the same row as well.
What's the best way forward?
Posted : 23/04/2022 2:56 am
Hi Justine,
Please upload your sample file. You need to click the 'Start Upload' button after selecting your file and then wait for the grey check mark beside the file size before clicking 'Submit Reply'.
Mynda
Posted : 23/04/2022 8:13 pm
