how to calculate the average between multiple floating point entries only(f1,f2​,f3,f4,f5,​f6.,....) and delete the duplicated columns

i have multiple columns 's format: %s %f1%s%d%d %f2%s%d%d %f3%s%d%d %f4%s%d%d %f5%s%d%d %f6%s%d%d %f7%s%d%d............ results should be like this: %s %f1%s %f2 %f3 %f4 %f5 %f6 %f7.................................................

Answer 1

[KSSV]

How about

mean(unique(myarray))

[Rik]

I think it not as straightforward as this, because I think he's trying my solution from this question. Confirmation that he is using the table datastructure would be nice, however.

[KSSV]

That's why question should be clear.

[chocho]

yeah exactly !

[chocho]

Rik Wisselink you are right!