Hi,
An example of the data I'm looking to work with is below:
4 1
4 2
5 4
5 2.5
5 2
8 4
8 2
8 1.7
8 4.5
9 6
9 6.5
Basically I'm looking for the average of the numbers in column B based on which number they correspond to in column A. Therefore from the data above I would be looking for a list with 1.5, 2.83, 3.05, 6.25.
Anyone have an idea which formula I need to use to get that result? It would eventually be used for a much larger data set. Any help would be really appreciated
Many thanks
Ben
Extract a list of unique numbers from Col A. Let's put these in Col F, starting in F2
In G2
=AVERAGEIF($A$1:$A$100,F2,$B$1:$B$100)
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks