Hi Vebhav,
Kindly check the group's page from Google Group, and look for files
uploaded.
There are around 100 files in the group. I am sure u'll find few good
books which may help you.
Bye for now,
Prashant.
On Aug 21, 1:53 pm, vebhav jain vebhav.j...@gmail.com wrote:
Hi All,
I am
Try using the formula iserror along with the If formula.
here is a sample...
=if(iserror(your formula),a,your formula)
where, a = the value you want instead of the NA.
What it will do is, check if the formula is resulting in value or
returning error, if error comes, it will give the defined out
Hi Kalyan,
Looks like you need to repeat the same formula twice in the same cell.
Once with Distributor and once with Super stockist. Ya, do not forget
to adjoin the formula's with plus in between. ;)
I don't understand one thing though, why don't you use Pivot. Its
really easy with that.
Hi All,
M new to VBA codes, but i've been using macro using the record
function.
I have created a macro as below...
auto_2 Macro
' Macro recorded 6/25/2009 by Prashant
'
Sheets(Sectoral).Select
Selection.AutoFilter Field:=3, Criteria1:=Auto
Range(A4:B17).Select