I think its done with using index, match and
small/large function .if i am not wrong
please try below link
http://excel.bigresource.com/Using-INDEX-MATCH-with-MAX-and-LARGE-lymO5ySE.html#FK94kfmd
.
Enjoy
Team XLS
On Wed, Mar 20, 2013 at 10:23 AM, amar takal
Thank you anil
It is working on the first column when it drag to another column it is
shows erroor and Instead of "N/A" it should take the previous date closing
price.
Please help.
regards
GIRISH
On 20 March 2013 09:00, अनिल नारायण गवली wrote:
> Dear G.Rishi,
>
> Pl see the attached sheet.
Hi Girish,
Use this
=IF(VLOOKUP(G$4,$A$4:$B$15185,2,0)=$F5,VLOOKUP(G$4,$A$4:$C$15185,3,0),"") in
cell G5 and copy down and right.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of M S GIRISH
Sent: Tuesday, March 19, 2013 10:55 PM
To:
Hi Amar,
still not clear...
can you please give me example ?
.
Enjoy
Team XLS
On Tue, Mar 19, 2013 at 6:04 PM, amar takale wrote:
> Dear David,
> First Thanks for reply.Actually I need to Extract Bank Nifty-OPEN_INT
> (More than 5).there are 13 cell which is mor
Thanks Prakash,
I tried following steps before sharing the file. But could not recover the
file
Kantilal Badale
On Tue, Mar 19, 2013 at 2:46 PM, Prakash wrote:
>
> Hello Kantilal,
>
> Have you tried to repair the file at your end? If no then try to repair it
> first and share the result.
>
You can repair your excel file using Excel file recovery tool from
http://www.repaircorruptexcel.com
On Tuesday, March 12, 2013 1:30:35 PM UTC+5:30, kantila...@gmail.com wrote:
>
> Deal All experts,
>
>
> Please help me to repair attached file.
>
> Kantilal Badale
>
>
--
Are you =EXP(E:
Dear David,
First Thanks for reply.Actually I need to Extract Bank Nifty-OPEN_INT (More
than 5).there are 13 cell which is more than 5.
Regards
Amar
On Tue, Mar 19, 2013 at 5:31 PM, David Grugeon wrote:
> I cannot understand your question. you will have to be much more
> explicit. If y
Sorry. Dont use that use this one
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Cancel = True
Application.EnableEvents = False
Worksheets(5).PrintOut
Application.EnableEvents = True
End Sub
Regards
David Grugeon
On 19 March 2013 22:08, David Grugeon wrote:
> Put this in the ThisWorkb
Put this in the ThisWorkbook module
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Cancel = True
Application.EnableEvents = False
Worksheets(5).PrintOut
End Sub
Regards
David Grugeon
On 19 March 2013 21:50, Shrinivas Shevde wrote:
> Dear All
> I have a excel work book in which there are
You can set the Print Area to the section you wish to print.
This will then print, regardless of what cell is selected.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
I cannot understand your question. you will have to be much more explicit.
If you cannot explain in English, perhaps you know someone who can help
you.
Please put the explanation in the body of the email, not in a spreadsheet.
Regards
David Grugeon
On 19 March 2013 21:40, amar takale wrote:
Dear All,
Pls Can anybody solve my issue?
On Tue, Mar 19, 2013 at 1:27 PM, amar takale wrote:
> Dear All
> Pls see Sheet (Sample Sheet+1) I used Sumproduct formula in K 32 cell but
> I want to modified it to search only that value not sum.If experts help me
> then my issue will be solved.Pls see
Hi Rajan,
Excel crashing issue can be caused by several things like: Problem with
add-ins, outdated anti-virus software, Excel is used by another program,
and many mode.
Users can get rid from this problem by following methods:
- Start Excel in Safe
- Update anti-virus software
- Make
Hello Kantilal,
Have you tried to repair the file at your end? If no then try to repair it
first and share the result.
You can repair the file by following below steps:
1. On the *File* menu, click Open.
2. In the Open dialog box, select the file you want to open, and click
the arrow
Wow Its excellent,
It works for me
Thankyou very much Mr. Abhishek and all the group.
Thanks a lot.
On Tue, Mar 19, 2013 at 2:22 PM, Abhishek Jain wrote:
> Try this.
>
> On Tue, Mar 19, 2013 at 2:08 PM, Anjali . wrote:
>
>> Hi Every One,
>> Again i need the help of excel experts,
>> I have so ma
Try this.
On Tue, Mar 19, 2013 at 2:08 PM, Anjali . wrote:
> Hi Every One,
> Again i need the help of excel experts,
> I have so many files in a folder in different formats like .jpg, .doc,
> .xlsx etc., etc.,
> i want all the file names in a excel file.
> for example: i have a file in a folder
Hi Every One,
Again i need the help of excel experts,
I have so many files in a folder in different formats like .jpg, .doc,
.xlsx etc., etc.,
i want all the file names in a excel file.
for example: i have a file in a folder by the name STH001234.JPG,
STH001235.JPG and BOOK1.xlsx
I want that file n
17 matches
Mail list logo
