Likes Likes:  0
Thanks Thanks:  0
HaHa HaHa:  0
Results 1 to 3 of 3

Thread: Any Excel experts here?

  1. 03-23-2010, 09:30 AM #1
    Ranger690
    Ranger690 is offline Crappie.com Legend and 2021 Crappie.com Man of the Year
    Join Date
    Jan 2005
    Location
    Chesterfield, VA
    Posts
    8,204
    Post Thanks / Like

    Default Any Excel experts here?


    Can you put 2 numbers in one cell, similar to coordinates, and have them averaged and show Avg X / Avg Y in another cell. Or will each X need to be in a unique cell and each Y?

    Does that make sense?

    thanks,

    Dayton
    Reply With Quote Reply With Quote
  2. 03-23-2010, 10:35 AM #2
    fishinRod's Avatar
    fishinRod
    fishinRod is offline Crappie.com 1K Star General
    Join Date
    Dec 2005
    Location
    gastonia, nc
    Posts
    1,513
    Post Thanks / Like

    Default

    im pretty sure they have to be in seperate cells
    I can only wish to be as good as my dog thinks I am
    Reply With Quote Reply With Quote
  3. 03-23-2010, 11:03 AM #3
    Fishing Magician
    Fishing Magician is offline Keeper
    Join Date
    Feb 2010
    Location
    State of Flux
    Posts
    40
    Post Thanks / Like

    Default

    Dayton

    X coords in A COLUMN Row 2 to Row 21 (20 cells)
    in cell 22 put =SUM(A2:A21)/20
    this gives you an average for the 20 cell column

    Y coord in COLUMN B
    do the same EXCEPT in cell 22 put =SUM(B2:B21)/20

    this takes the 20 X and Y numbers and averages them seperatly

    Last edited by Fishing Magician; 03-23-2010 at 11:24 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

BACK TO TOP