Hi Guys,
Kindly help me build a formula that can lookup and summarize.
I attached file >>>Lookup summary.xlsx
Hi Guys,
Kindly help me build a formula that can lookup and summarize.
I attached file >>>Lookup summary.xlsx
Click * below if this answer helped
Try this.......
This is an array formula so it needs to confirm with Ctrl+Shift+Enter and then drag it down for the first value in col. G. You will have to change the references in the formula for all the next values in col. G which are A,1,S,ID,V
For details, please find the attached sheet.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.
Seems like if your source data table changes and you want to just pull out the "groups"...
1) Copy column C:D as a group to a new column
2) Sort the new table by the second column
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thank you sktneer for the formula and JBeaucaire for the idea.
You are awesome.
You're welcome. Glad to help you. Thanks for the feedback.
If you think that the issue is resolved, please mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks