Finding Val. in One Col. Conditional on Other
Closed
Mary
-
Feb 25, 2010 at 10:31 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 25, 2010 at 06:30 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 25, 2010 at 06:30 PM
Hello,
I have a massive spreadsheet with 16,000 lines and I need to find the average of values in column D as long as the value in column C is the same. I am looking for a macro that averages values in column D until the value of column C changes and then loops to repeat averaging for the next set of values in D that have the same associated value in column C.
If anyone has a macro that performs this function that would be great. I can't possibly do it by hand and it doesn't seem that complicated, but I know nothing about macros.
Thank you.
I have a massive spreadsheet with 16,000 lines and I need to find the average of values in column D as long as the value in column C is the same. I am looking for a macro that averages values in column D until the value of column C changes and then loops to repeat averaging for the next set of values in D that have the same associated value in column C.
If anyone has a macro that performs this function that would be great. I can't possibly do it by hand and it doesn't seem that complicated, but I know nothing about macros.
Thank you.
Related:
- Finding Val. in One Col. Conditional on Other
- Ps3 not finding update on usb - Guide
- Finding @ on keyboard - Guide
- Val tracker - Download - Gaming tools
- Finding friends on facebook - Guide
- Ranked resurgence not finding match ✓ - Video Games Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 25, 2010 at 06:30 PM
Feb 25, 2010 at 06:30 PM
Just being lazy here, so could you put a sample file at some share location like https://authentification.site