Hello,
I would like to know if there is any function in excel to check if a number of cells in a column are equal? For example, check if A5:A20 are equal. Note, that I do not want to check if all cells in the column are equal, rather just a range of cells.
I would like this function to accept any content in the cell, i.e. both numbers and strings. I did my own check based on standard deviation (i.e. =IF(STDEV(A5:A20)=0;1;0)) but of course this does not work for strings...
Anyone who knows how to solve this?
Thanks in advance!
Best Regards,
Samuel
Bookmarks