Thanks David and it's clear now.
Chris
On Fri, May 17, 2013 at 11:54 AM, David Grugeon wrote:
> Depends on the version. If you have 2010 or later you can use:
>
> Iferror(the formula,"")
>
> For earlier versions you use
>
> If(iserror(the formula),"",the formula)
>
> But both of these only work
Depends on the version. If you have 2010 or later you can use:
Iferror(the formula,"")
For earlier versions you use
If(iserror(the formula),"",the formula)
But both of these only work on the vl;ookup formulas. They will not work
in columns B, and H-L. For these you will need on row 7
If(A7=
David, thank you it worked perfectly, however, when I use the fill handle
to drag and fill down I ended up with 0, #NA and 0/01/1900 on the filled
row. How do I use IF(ISERROR ( function to get rid of 0, #NA and 0/01/1900??
Once again thanks for any help.
Chris
On Thu, May 16, 2013 at 4:26 PM,
David, thank you very much for the help and I will go through the file
and update...
Thanks
Chris
On 5/16/13, David Grugeon wrote:
> Sorry - Attachment here
>
> Regards
> David Grugeon
>
>
>
> On 16 May 2013 13:12, David Grugeon wrote:
>
>> Easier with formulas - see attached. I had to change
Sorry - Attachment here
Regards
David Grugeon
On 16 May 2013 13:12, David Grugeon wrote:
> Easier with formulas - see attached. I had to change the ID for ABC from
> FR002 to FR001 to match the details. Also I did not get the swapped items
> in the last 2 rows shown in your combined.
>
> Re
Easier with formulas - see attached. I had to change the ID for ABC from
FR002 to FR001 to match the details. Also I did not get the swapped items
in the last 2 rows shown in your combined.
Regards
David Grugeon
On 16 May 2013 12:38, Christopher Kevin wrote:
> Dear Experts,
>
> Can Anyone
Dear Experts,
Can Anyone help me on the following.
I want to combine all columns from MasterRaw and DetailsRaw into as
shown in CombinedRaw Sheet. Is it possible to use Excel VBA or
Formula??? However would prefer VBA. Please see attached sheet.
Please help me on this. I desperately need he
