HI
=offset(beregning!$C$1,1,match(beregning!$C$1,beregning!$C$1,0)-1,count(offset(beregning!$C$1,1,match(beregning!$C$1,beregning!$C$1,0)-1,10,1)),1)
This line works fine with datavalidation list, but i have multiple duplicates in the sheet and i dont wont them in the list.
=unique(offset(beregning!$C$1,1,match(beregning!$C$1,beregning!$C$1,0)-1,count(offset(beregning!$C$1,1,match(beregning!$C$1,beregning!$C$1,0)-1,10,1)),1))
this line works in a cell, but when trying to put it in datavalidation list, it returns an error and does not function at all.
::::
I have replaced ; with , and renamed to formulas to english version, so it might be a little of here, i dont know.
Thank you
/kim
=offset(beregning!$C$1,1,match(beregning!$C$1,beregning!$C$1,0)-1,count(offset(beregning!$C$1,1,match(beregning!$C$1,beregning!$C$1,0)-1,10,1)),1)
This line works fine with datavalidation list, but i have multiple duplicates in the sheet and i dont wont them in the list.
=unique(offset(beregning!$C$1,1,match(beregning!$C$1,beregning!$C$1,0)-1,count(offset(beregning!$C$1,1,match(beregning!$C$1,beregning!$C$1,0)-1,10,1)),1))
this line works in a cell, but when trying to put it in datavalidation list, it returns an error and does not function at all.
::::
I have replaced ; with , and renamed to formulas to english version, so it might be a little of here, i dont know.
Thank you
/kim