Hi Dhaval,
Copy below formula at cell address C11 and confirm it with CSE
*=MAX(($B$2:$B$68=$S$10)*($A$2:$A$68 = FUTSTK)*$I$2:$I$68)*
*
*
Select cell R14:R19, press F2 and paste below formuls and confirm it with
CSE
*=IFERROR(INDEX($B$1:$N$68,IFERROR(SMALL(IFERROR(INT(SUBSTITUTE(($D$1:$D$68
Lalit Sir
didt work can u send me the sample file
Thanks
Dhaval Shah
079 - 40055253
On Wed, Apr 3, 2013 at 12:25 PM, Lalit Mohan Pandey
mohan.pande...@gmail.com wrote:
Hi Dhaval,
Copy below formula at cell address C11 and confirm it with CSE
*=MAX(($B$2:$B$68=$S$10)*($A$2:$A$68 =
They all are array forumlas did you applied with Control + Shift + Enter.
Please check. I applied all these formulas in your attached workbook and
its working.
On Wednesday, 3 April 2013 12:39:39 UTC+5:30, Dhaval Shah wrote:
Lalit Sir
didt work can u send me the sample file
Thanks
yes sir me applied with CSE but ... if u have sheet pls mail me
On Wed, Apr 3, 2013 at 12:42 PM, Lalit Mohan Pandey
mohan.pande...@gmail.com wrote:
They all are array forumlas did you applied with Control + Shift + Enter.
Please check. I applied all these formulas in your attached
Copy this code and run it and get the output. After getting expected result
please check what you were doing manually which is not giving you correct
output. and sorry for not sharing file with you. Hope you understand:
*Sub ApplyFormula()*
*
*
*With ThisWorkbook.Worksheets(1)*
*
Dear Thanks for u r prompt reply but out put is not as per my requirement
pls check the reference sheet
On Tue, Apr 2, 2013 at 10:49 AM, xlstime xlst...@gmail.com wrote:
Hi Dhaval,
dhaval shah
(1).xlsxhttps://docs.google.com/file/d/0B4LBSzxr1QTiVjZoYkRneFFUY1k/edit?usp=drive_web
PFA...
what is CMP ?...
you can use sumifs or sumproduct
.
Enjoy
Team XLS
On Tue, Apr 2, 2013 at 9:56 AM, Dhaval Shah todhavals...@gmail.com wrote:
Hello all experts
any solution for my query
On Mon, Apr 1, 2013 at 4:37 PM, Dhaval Shah todhavals...@gmail.comwrote:
cmp is current market price ( CLOSE PRICE )
On Tue, Apr 2, 2013 at 10:18 AM, xlstime xlst...@gmail.com wrote:
what is CMP ?...
you can use sumifs or sumproduct
.
Enjoy
Team XLS
On Tue, Apr 2, 2013 at 9:56 AM, Dhaval Shah todhavals...@gmail.comwrote:
Hello
Hi Dhaval,
dhaval shah
(1).xlsxhttps://docs.google.com/file/d/0B4LBSzxr1QTiVjZoYkRneFFUY1k/edit?usp=drive_web
PFA...
.
Enjoy
Team XLS
On Tue, Apr 2, 2013 at 10:39 AM, Dhaval Shah todhavals...@gmail.com wrote:
cmp is current market price ( CLOSE PRICE )
On