Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Get sum of values in a cell based on unique values in another cell
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Bruno Campanini, post: 7407667"] Shorabh formulated on Monday : _R = Range("A2:A63") in your Sheet. In E2 down: {=IF(ROW(A1)<=SUM(IF(LEN(_R)>0,1/COUNTIF(_R,_R))),INDEX(_R,MATCH(SMALL(IF(COUNTIF(OFFSET(_R,,,ROW(_R)-CELL("row",_R)+1),_R)=1,COUNTIF(_R,"<"&_R)),ROW(INDIRECT(ROW(A1)&":"&ROWS(_R)))),COUNTIF(_R,"<"&_R),0)),"")} FormulaArray In E2 down: =SUMPRODUCT((_R=E2)*OFFSET(_R,,1)) Bruno [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Get sum of values in a cell based on unique values in another cell
Top
