NEWBIE question here:
I have two columns, A with an integer value as an identifier and B with a decimal value for each. My A values are not unique. For each value of A, I would like to return the mean of B values and totals of B values.
Thanks
I have attached an example worksheet
Pivot table perhaps?
Last edited by Special-K; 04-21-2014 at 10:00 AM.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Please see attached spreadsheet with formula solution. Please note that formulas in columns E and F are array formulas and require Ctrl+Shift+Enter key combination:
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks