sayth
sayth

Reputation: 7028

Sheets - Split cell into list(Array) and find average - Not across columns

If I have cell A1 with value 73562

How can I split it so that I create an array that I can then find the average of?

so for cell A1 I want the answer in B1 to be 4.6.

That is the average of

[7,3,5,6,2]

I thought array syntax on split would work, but it errors.

=AVERAGE({SPLIT(L4,'')})

Upvotes: 1

Views: 38

Answers (1)

pnuts
pnuts

Reputation: 59440

Please try:

=average(split(regexreplace(A1&",","(\d)","$1,"),","))

Upvotes: 3

Related Questions