Hello,
To remove starting letters from the cell the following nested function can be
used:
=RIGHT(00RIGHT(A1,LEN(A1)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},A10123456789))+1),6)
Where A1 = ABC Company 435
Assuming only 6 digit number is expected.
Regards.
Hi Harris,
You would need to nest the ISERROR function in your formula.
For example:
=IF(ISERROR(your formula)=TRUE,,your formula)
Regards.
Date: Wed, 5 Aug 2009 23:31:30 -0700
Subject: $$Excel-Macros$$ how to hide #N/A
From: harris...@gmail.com
To:
Hello,
You can use the following formual to achieve the required:
=-MID(B26,1,FIND(-,B26)-1)
The formula will add a - sign infront of the number extracted from original
value cell with suffixed - omitted.
Kind regards.
Serghei.
Date: Tue, 4 Aug 2009 14:38:34
Hello,
This is the formula you would use in your results cell:
=COUNTIFS(A1:A6,$B$8,A1:A6,$C$8)
Where A1:A6 is you range of 24,35,36,38,37,48,42 and $B$8 $C$8 are your
criteria parameters. You can have a number if nested criterias in the COUNTIFS
function.
Regards.
Hi,
Try the following instead of your line:
c = CLng(4) * CLng(1)
You need to convert both or at least one of the integers into longs as VBA
treats them as integers by default.
Regards.
Serghei
Date: Wed, 29 Jul 2009 19:50:06 -0700
Subject: $$Excel-Macros$$
, that cell (i.e.
M5) should get fill with red colour which will indicate that user cannot
insert supplier name if consumption or import is 0.
I hope you got my point. Actually it is little difficult to explained.
Thanks and best regards,
Swapnil.
On Thu, Jul 30, 2009 at 7:28 PM, Serghei
point. Actually it is little difficult to explained.
Thanks and best regards,
Swapnil.
On Thu, Jul 30, 2009 at 7:28 PM, Serghei Ovanesov oserg...@hotmail.com wrote:
Hi Swapnil,
I am not sure if this is what you wanted, but here it goes. Unfortunately I was
not able to replicate the same
Hello Harris,
Please find attached a solution for your problem. Do confirm if this is what
you wanted.
Kind regards.
Serghei
Date: Wed, 29 Jul 2009 15:19:12 +0530
Subject: $$Excel-Macros$$ Help with formula
From: harris...@gmail.com
To: excel-macros@googlegroups.com