Re: $$Excel-Macros$$ Help to get the Formula

2012-10-02 Thread ankur kochar
> From: excel-macros@googlegroups.com >> [mailto:excel-macros@googlegroups.com] >> On Behalf Of ankur kochar >> Sent: 02 October 2012 12:19 >> To: excel-macros@googlegroups.com >> Subject: $$Excel-Macros$$ Help to get the Formula >> >> Hi All, >>

RE: $$Excel-Macros$$ Help to get the Formula

2012-10-01 Thread Rajan_Verma
legroups.com] On Behalf Of ankur kochar Sent: 02 October 2012 12:19 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help to get the Formula Hi All, I seek some help in to get the desired result via formula. My requirement is - I need result in column G in the yellow highlighted cell as

$$Excel-Macros$$ Help to get the Formula

2012-10-01 Thread ankur kochar
Hi Vab, Thanks for your valuable input. But currently it works for the specific range of data selected. But i need to get the formula for 'n" number of lines and the range is not fixed for column "B" and column "C". I need the formula in column G in all the cell and the result should be true in th

$$Excel-Macros$$ Help to get the Formula

2012-10-01 Thread ankur kochar
Hi All, I seek some help in to get the desired result via formula. My requirement is - I need result in column G in the yellow highlighted cell as Yes or No. If the sum of F2:F4 (lines can be more) match with the value in cell F1 total and that should be only in the case when the numbers in B1 to