Hi,
I have come across instances where the calculation settings have got
modified from Calculation to Manual. I found this issue when my colleagues
ask me why there are not able to see results of a formula (when they drag
the formula down). My colleagues had no clue about this settings & so i am
su
Hi Friends,
Here is an Gift Download information for you from www.excelitems.com
ID: FE0001
Name: Indian Stock Markets Tracker
Description : Use this excel file to track
Hi Puneet,
I've come up with a solution. Please review and tell us if this is
you're looking for and required to you.
There is a download on this page which acts as a trac
Hi,
You can also use the below code
Sub del()
ro = 1 'Starting Row
Col = "A" 'Column in which the extra word contains
While Range(Col & ro).Value <> ""
If Range(Col & ro).Value = "Extra" Then
Range(Col & ro).EntireRow.Delete
ro = ro - 1
End If
ro = ro + 1
Wend
End Sub
Thanks
U can also use filter option
rgd
Gaurav
On Wed, Feb 25, 2009 at 11:23 AM, Lavprasad Kori wrote:
> Hi Dear,
>
> Attached herewith the file of solution of your question. In that the
> solution is in column E. You have to copy Column E & paste special it in
> Column D.
>
> Regards,
>
> Lavprasad Ko
Hi,
If you have xl2007, you can use the new built-in function: IFERR.
Dave.
> Date: Wed, 25 Feb 2009 09:16:37 -0800
> Subject: $$Excel-Macros$$ How to avoid NA# or remove NA# when there is no
> value found by vlookup.
> From: prabhat.shrivasta...@gmail.com
> To: excel-macros@googlegroups.com
Hi Prabhat,
Assumption: X denotes a Vlookup formula like this X = VLOOKUP(A1,A:B,
2,0).
Solution: Use this formula IF(ISERROR(X),"",X)
Description: Since #NA denotes the
Hi Prabhat,
Assumption: X denotes a Vlookup formula like this X = VLOOKUP(A1,A:B,
2,0).
Solution: Use this formula IF(ISERROR(X),"",X)
Description: Since #NA denotes the er
Dear All,
Pls help me out to avoid NA# error while there is no value found by
Vlookup. let suppose
if there is in a cloumn i did not found any value in define range than
result would come as NA#. Now i want get the result other than NA# or
result define by me.
Thanks and Regrds
Prabhat Shrivasta
