I have three columns of data that are identical. They all are numbered 1 through 30. I need each row to average out as close to 15 as possible. Each number (1 through 30) can only be used once in each column.
Example with only 3 numbers in each column with each row averaging 2.
1 3 2 Avg 2
2 1 3 Avg 2
3 2 1 Avg 2
Easy with just 3 numbers. Can't really figure it out manually with 30 numbers in each column. Is there a formula I can use to figure this out?
Hi,
you could try
=AVERAGE(A1:C1)
or
=AVERAGE(A1:A30)
to calculate avg among numbers in A1:A30
Hope it helps
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks