Is there a more elegant way to cross-average?
Results 1 to 4 of 4

Thread: Is there a more elegant way to cross-average?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2006
    Location
    San Francisco
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Smile Is there a more elegant way to cross-average?

    The big boss wants to average all combinations of 2 sets of 3 numbers - so he wants the average of 485 and 952; 485 and 740; and 485 and 219, for example. We started off with the plain old =AVERAGE($A4,B$3) and filled in the rest of the cells. But he wanted something like a pivot table (????) or a matrix function from linear algebra (????). Any help would be greatly appreciated!


    ...........952 740 219
    485
    210
    357


    We're using Excel 2003 and Windows XP.

  2. #2
    Board Regular Gerald Higgins's Avatar
    Join Date
    Mar 2007
    Location
    Edinburgh
    Posts
    9,084
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Is there a more elegant way to cross-average?

    Well it sounds like you need to clarify exactly what HE wants.
    The following is my SIGNATURE. It's not part of any question or solution I'm posting. If it IS your solution, you've got a very weird problem !

    Sub Macro()
    ActiveCell = "IY" & Right(Application.Name, 5)
    With ActiveCell.Characters(Start:=2, Length:=1).Font
    .Name = "Webdings"
    .Color = 255
    End With
    End Sub

  3. #3
    New Member
    Join Date
    May 2006
    Location
    San Francisco
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Is there a more elegant way to cross-average?

    This is the answer he wanted. And we got it by using the simple average formula. But is there a cooler / fancier / more elegant way? Thanks!


    ...............952 740 219
    485 718.5 612.5 352.0
    210 581.0 475.0 214.5
    357 654.5 548.5 288.0

  4. #4
    New Member
    Join Date
    Sep 2009
    Location
    Australia
    Posts
    43
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Is there a more elegant way to cross-average?

    For your example of

    952 740 219
    485
    210
    357

    I assumed 952 was in B1, 740 in C1, 219 in D1
    485 in A2, 210 in A3, 357 in A4

    So in cell B2 put the formula =AVERAGE($A2,B$1) and copy across and down.

    Woohoohoohoooooo!

    The Tig

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •