Forum Discussion
Find Trimmed Mean of all the values of an item
Update: Thank you for the correction. Thing is i'm new to VBA and have no idea even how to begin to write the code required. I will try to explain my desired goal in the details below. This is for a ...
You've had 70 views as of this writing, but no replies. I suspect that's because it's not entirely clear what you're asking help in accomplishing. When I look at your spreadsheet, it appears as if you have most of it already done. You also make a point of wanting a visual basic routine, when it's not at all clear why THAT needs to be involved. So I wonder if you could take a few minutes to spell out more fully what it is that you're seeking; the work you've already done shows a fair amount of familiarity with Excel, making me at any rate wonder what I'm missing.
[For the record, if it makes a difference, I personally prefer to avoid VBA and macros, choosing instead to figure out ways that Excel's many functions can achieve the results. There are plenty of other folks here in this forum, however, who are adept at VBA if that indeed is a "must"]
[For the record, if it makes a difference, I personally prefer to avoid VBA and macros, choosing instead to figure out ways that Excel's many functions can achieve the results. There are plenty of other folks here in this forum, however, who are adept at VBA if that indeed is a "must"]
- Sorry i took time. I updated the original post explaining in detail what i need and why i think it needs to be macro. Also the sample sheet i uploaded was done manually - no VBA code or formula (mostly). What i would like is a VBA script that does the same thing automatically
