Does anyone know how to concatenate pieces of a function so that it will actually solve?
e.g.
I want to solve
=average(A3,A4) by piecing together data in this column of cells:
A1 3
A2 4
A3 100
A4 100
I've tried the following:
=average(a&index(a1,1,1),a&index(a2,1,1))
or
= concatenate("=average(A",A1,",A",A2,")")
any suggestions? been stuck on this for a few hours now. Thanks!!
Last edited by umbata; 07-12-2013 at 01:48 PM.
Probably with an pivot table.
But without an excel file'(with the desired result), it's hard to show you.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
How about:
Please Login or Register to view this content.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
In what way do you want to solve AVERAGE(A3, A4)?
If posting code please use code tags, see here.
=AVERAGE(INDEX(A:A,A1,1),INDEX(A:A,A2,1)) this works amazingly! ... thanks ConnecXion Lost
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks