RE: $$Excel-Macros$$ == Need help on the sheet

Thanks Noorain, For the help, will have a look at it. Regards Sreejith Date: Fri, 30 Mar 2012 20:24:33 +0530 Subject: Re: $$Excel-Macros$$ == Need help on the sheet From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com Dear Sreejit, Please use it.. =OFFSET(INDEX(Detailed!$A

Re: $$Excel-Macros$$ == Need help on the sheet

Hello Sreejith, As Seema said, not sure about how do you want to compare due to duplicate trade ID's. If you are looking to total the headings based on TradeID's use SUMIF. In C11, then copy down. Assume Trade Id always be in column A in detailed sheet * =IFERROR(SUMIF(Detailed!A:A,C$8,INDEX(

Re: $$Excel-Macros$$ == Need help on the sheet

Dear Sreejit, Please use it.. =OFFSET(INDEX(Detailed!$A$2:$K$2,MATCH($B11,Detailed!$A$2:$K$2,0)),MATCH($C$8,Detailed!$A$3:$A$13,0),0) see attached sheet. -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ == Need help on the sheet

Hi, Your trade ID is not unique. So how do you decide, which in detailed sheet row you need to compare with which row in summary sheet. Example if your trade id is TD20120325, there are multiple rows in detailed sheet with this trade id, so which row do you take as reference for comparision? Rega

$$Excel-Macros$$ == Need help on the sheet

Dear Excel Experts. I need your help on the excel sheet which i have attached. I want you to help me in building a formula based table which does the Checks. Let me know if you have any questions. Regards Sreejith -- FORUM RULES (986+ members alread