I have found a solution using a dynamic range where the range is determined using the parameter. For those interested in the formula;
The dynamic range:
={OFFSET(tbl_data_AR!$A$1;MATCH($B$1;tbl_AR[administration];0);0;MATCH($B$1;tbl_AR[administration];1)-MATCH($B$1;tbl_AR[administration];0);1)}
In the range name manager i used then the name "range_admin"
The formula to get the unique values out of the dynamic range becomes then:
={IFERROR(INDEX(range_admin;MATCH(0;COUNTIF($C$5:C5;range_admin);0));"")}
Thx,
Sven
Bookmarks