Hi, 

I have the following formula to get a range of values (col) of which i want to check how many times the values appear in the range and then filter for more than one time (duplicates). Somehow I am not able to get the formula working pr

=LET(tbl;UNIQUE(VSTACK(HSTACK(tbl_Prognose[PRJ_NR];tbl_Prognose[DESC]);HSTACK(tbl_Orderportefeuille[Nummer];tbl_Orderportefeuille[Omschrijving])));
col;CHOOSECOLS(tbl;1);
BYROW(col;LAMBDA(r;COUNTIF(col;r))))

operly. Someone any advice on this :grinning_face_with_sweat:

Many thanks in advance

​Hi,  I have the following formula to get a range of values (col) of which i want to check how many times the values appear in the range and then filter for more than one time (duplicates). Somehow I am not able to get the formula working pr =LET(tbl;UNIQUE(VSTACK(HSTACK(tbl_Prognose[PRJ_NR];tbl_Prognose[DESC]);HSTACK(tbl_Orderportefeuille[Nummer];tbl_Orderportefeuille[Omschrijving])));
col;CHOOSECOLS(tbl;1);
BYROW(col;LAMBDA(r;COUNTIF(col;r)))) operly. Someone any advice on this :grinning_face_with_sweat:Many thanks in advance  Read More

​