Unable to use If, Countif and Concantenate function together

[ygoyal578]

I was trying to find if result of concatenation is duplicate or not but the formula is not working. Below is the formula that I create. pls help in rectifying the error.

IF(COUNTIF(VALUE(CONCATENATE($E$2:$E$1048576,$M$2:$M$1048576,LEFT($AP$2:$AP$1048576,2))),VALUE(CONCATENATE($E$2:$E$1048576,$M$2:$M$1048576,LEFT($AP$2:$AP$1048576,2))))>1,"Yes","No")

 

[ygoyal578]

That was done with the formula from post 4 (the one that you said didn't work).

Thanks for the help. Actually I was using table and I was not defining range so may be that is why it was not working.

 

[jasonb75]

It should work with a table range, it would need to be written in the format of

=IF(COUNTIFS([column1],[@column1],[column2],[@column2],[column3],[@column3])>1,"yes","no")

where column1, column2 and column3 should be replaced with the names of your actual columns.

 

[ygoyal578]

It should work with a table range, it would need to be written in the format of

=IF(COUNTIFS([column1],[@column1],[column2],[@column2],[column3],[@column3])>1,"yes","no")

where column1, column2 and column3 should be replaced with the names of your actual columns.

Thanks