Re:THANK YOU $$Excel-Macros$$ Lookup Multiple values and display horizontally

Hi Ashish, Bruno & Maries Thanks a lot I appreciate your help. All the three solutions work. Thank you :) Shine On 25 August 2010 05:06, Bruno Bruno wrote: > See if this helps. > > Regards, > Bruno > > 2010/8/24 ҉Shine > >> Thank you Ashish. I appreciate you

Re: $$Excel-Macros$$ Lookup Multiple values and display horizontally

Thank you Ashish. I appreciate your effort and time you spent for it. But I am looking for a combination function that can do the job. VBA cannot be used Thank you Best Regards Shine On 23 August 2010 20:52, ashish koul wrote: > hi sort your data on item basis first > > try this

$$Excel-Macros$$ Re: Calculate Sum of Product of every adjecent pair of Cells in a row

t have time to teach him scripts. LOL. Thanks a lot again. Shine 2009/4/30 Satti Charvak > I'll give a good clerical answer- we'll if it's not required everyday. > > Procedure: > 1. in cell a2 write =A1*B1 and in cell c2 write =1*D1 > 2. select cells a2 till d2 >

$$Excel-Macros$$ Calculate Sum of Product of every adjecent pair of Cells in a row

trying with "Sumproduct" function with "mod" to identify adjacent cells. But so far could not figure it out. Does any one have a solution which is not a macro? Tha