Hi Friends
I have written following Macro to Add worksheet if it is not Exists in the
work book , but it is not working as it is not recognized Sheet is exits and
it always add one more work sheet.
Please help
Regards
krupesh
Option Explicit
Private Function SheetExist(Sname As String, Optiona
Hi
You can use following formula in Excel 2007
SUMIFS(Dump!$C$2:$C$23,Dump!$A$2:$A$23,Analysis!A2,Dump!$B$2:$B$23,Analysis!B2)
Regards
Krupesh
On Mon, Jul 20, 2009 at 8:20 AM, Steven Dsouza wrote:
> Hi,
>
> Iam a regular user of this group, and some of the tips have helped me a lot
> in my
Hi
U can use below mentioned formula
TEXT(A1, "DD/mm/ H:MM:SS AM/PM ")& B1
Regards
Krupesh
On Tue, May 12, 2009 at 1:27 PM, wrote:
>
> Hello,
>
> I have a problem in displaying AM or PM, when i try to concatenate to
> cells. Below is the reference -
>
> Column A Column B
Hi
You can try this Formula
=SUMIF(B2:B13, "<>", D2:D13)
Regards
Krupesh
On 12/5/08, lohith <[EMAIL PROTECTED]> wrote:
>
>
> Hi,
>
> Try these Array Formulas for Text, Numeric and AlphaNumeric
>
> For Text & Alphanumeric
>
> 1) =SUM(IF(ISTEXT(A2:A13)=TRUE,D2:D13,0))
>
> For Numeric Column
>
>
