Need a Formula That Groups Number Combinations
Hello,
I need formula that groups together combinations of numbers and after they have been grouped. Then list the number of wins, break evens, losses, average max positive pips, average max negative pips, and average close pips for that number combination.
See the attached spreadsheet for a better explanation.
Thank you in advance for any and all help.
Last edited by artiststevens; 04-05-2014 at 02:36 PM. Reason: Wrong Title
See the attached sheet to see if this is what you want.
For counting try this regular formula..
And for Average try this Array Formula(for detail see the attached sheet)
Please Login or Register to view this content.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
A small addition to the file of @ sktneer
In G3 Put this ARRAY formula and drag down.It gives list of unique values from Column A.
Please Login or Register to view this content.
Thank you sktneer for the updated workbook with explanations. You're formulas did exactly what I need them to do. Also thank you kvsrinivasamurthy for the additional formula that gave me the unique values for column A I need that as well. Thank you both very much it is greatly appreciated.
Glad to help you. Thanks for the feedback and rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks