Re Sorting Averages

Question

I calculate a column of averages from a twelve row table each row holding 5 to 7 numerical data entries.

For some rows there are 5 data entries, other rows have 6 entries, others 7.

Each Average is calculated by summing the numerical row entries (cols F:L) then dividing by Count (col P).

I cannot figure out how to apply AVERAGEIF

Goal: sort the column of Averages (col M) from High to Low.

To Sort I go to Data, press the down arrow (A-Z) and select 'Continue with current selection'.

This does not consistently sort the calculated Averages from High to Low; sometimes the sort is correct, other times it is not.

How do I attach the s'sheet for Group analysis?

Thank you -

Nat Pulsifer

Answer 1

Hi Nathaniel Pulsifer,

Thanks for sharing updates with us and I really appreciate your effort and your precious time and I know it effect on your daily work and I apologize for this.

I just send you message via PM, please access PM.

I appreciate your understanding and stay safe!!

Best Regards

Waqas Muhammad

Answer 2

Hi Nathaniel Pulsifer,

Thanks for sharing updates with us and I really appreciate your effort and your precious time doing those tests. First, please accept my apologize you meet such an issue and I understand it effort on your daily work.

We appreciate your understanding that sometimes the initial suggestions may not resolve the problem very soon. However, we can work together to narrow down and resolve the situation.

In order to upload your Excel sample file, you may upload your Excel file into online cloud location(OneDrive) then share a link here.so that I can look from my side, and I will check this behavior and verify the result with you.

If it is convenient for you and If there is confidential information, then you can send it to me in Private Message

I appreciate your understanding and stay safe!!

Best Regards

Waqas Muhammad

Answer 3

Thank you -

I am not clear on how to upload my file.

I do not see Insert/File tabs on this email.

An earlier respondent described a complex process, steps of which are above my pay grade.

Suggestions?

Also what is your email address?

Thanks again!

Nat Pulsifer

Answer 4

Hi Nathaniel Pulsifer,

As per your description, please don’t worry we can work together to narrow down and resolve the situation.

You may use a PivotTable to calculate the average for example **** create Pivot Table in your Excel workbook and then **** drag **** and drop the Fields in the different areas of your Pivot Table. Then Right Click in any of the Pivot Table values and choose Summarize Values By > Average and sort your data.

Meanwhile, if you don't mind, could you please upload your file and we can look from our side, and we will help you to check this behavior and verify the result with you.

I appreciate your understanding and stay safe!!

Best Regards

Waqas Muhammad

Answer 5

Simple way, use a PivotTable to calculate the average for you, then apply a sort to that column.

.

You cannot "attach" files to this forum (too hard to program (. You have to give us a "share edit" link to the file in your onedrive:

Upload Example - Share via “Personal” OneDrive File

There is no way to upload example files directly to this forum.
.

Trouble shooting problems using this text only forum can be like a visit to the dentist without anesthetics: a long, slow painful process of us trying to “extract” the clues needed to recognize the problem in a back and forth flow of questions and answers so that we hopefully can eventually come up with a / “the” solution.
.

Often it is faster and easier for everyone if we have a “sample file” get "hands on", to look at, and to “play with”.
.

This next link provides some tips on setting up a sample file and specific instructions for uploading and "sharing" it for us to access:
https://answers.microsoft.com/en-us/windows/forum/windows_other-winapps/trouble-shooting-share-onedrive-file/a231a097-bcbf-4e34-ad6c-a33118baf471?tm=1523189328156
.

Includes a link to a macro to randomize text in Word. And another macro to randomize data in Excel
.

Note: make sure to upload to your Personal (consumer) OneDrive rather than your work OneDrive or SharePoint. Files in the Work cloud can be hard to share due to security restrictions placed by the work admins. Or use any other free storage service (anything other than business OneDrive or SharePoint).
.

Another article explaining need for sharing example files:

Why a sample file is important for troubleshooting. How to do it. https://answers.microsoft.com/en-us/msoffice/forum/all/why-a-sample-file-is-important-for-troubleshooting/9441ae3c-1e92-41c6-9a1f-5b377b08e5a5
.

2021 05 25- 15 Best Free Cloud Storage in 2021 – Up to 200 GB Free Storage
https://www.whizlabs.com/blog/best-free-cloud-storage/
.