Hi, I need help with a spreadsheet. The spreadsheet is created using a
program I have no control over. I have a column that can contain weeks
that a course is run. It seems to come out in the following formats:
Weeks
10 - 12
8
6, 11 - 12
4 - 6, 8 - 10
3 - 7, 11
I want to split each and have a co
Dear All
I Wish you a very Happy Diwali and pray for you that you have a
prosperous new year ahead.
Diwali is celebrate all over India.
May God Bless U & Fulfill all your Dreams.
Take care of yourself and play safe.
Thanks & Regards
AYUSH JAIN
Group Owner
--~--~-~--~~---
Blank Attachment
Regards
Harish Upadhyay
On 10/25/08, swamy nadan <[EMAIL PROTECTED]> wrote:
>
> Hi to all
>
>
> I had attached a xl sheet. In sheet 1 the parts are given and also qty. In
> sheet 2 i required the total qty of the parts which in sheet1. Pls give me
> any formula to findout.
>
>
>
David try this
Public Function ufnWorkDays(StartDate As Date, intDays As Integer) As
Date
Dim iDays As Integer'Day counter
Dim datTemp As Date 'Date variable
datTemp = DateAdd("d", intDays, StartDate)
'Add 1 if it is a Sunday
If Weekday(datTemp) = 1 Then
datTemp = DateAdd("d",
heloo
there is no parts or quantity here.
Pls re check this..
Regards
Naveen Kumar M N
Transport Supervisor(HP)
91-08-99728 10886
Email :[EMAIL PROTECTED]
Best Wishes-Karunaada Kuvara
--- On Sun, 10/26/08, swamy nadan <[EMAIL PROTECTED]> wrote:
From: swamy nadan <[EMAI
Dear nidheshd , Please have solution file .Please give your feedback on the
solution . Allah Hafiz ,Kamran Haider .
Date: Thu, 23 Oct 2008 11:56:13 +From: [EMAIL PROTECTED]: [EMAIL
PROTECTED]: $$Excel-Macros$$ Lookup for repetitive itemsHi all,I need to apply
lookup for repetitive items,
Hi,
Use the below formula.
=A1&B1&TEXT(C1,("dd-mm-yy"))
On 10/26/08, karthik balasubramanian <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> Use this formulae:
>
> =CONCATENATE(E17,F17,TEXT(G17,"[$-409]d-mmm-;@"))
>
> COL: E F G ROW ms excel 24-oct-2008
>
> E17 is m
Whoops, youn eed to check for Weekday = 7 for Saturday
Public Function ufnWorkDays(StartDate As Date, intDays As Integer) As
Date
Dim iDays As Integer'Day counter
Dim datTemp As Date 'Date variable
datTemp = DateAdd("d", intDays, StartDate)
'Add 1 if it is a Sunday
If Weekday(datTemp
Dear All , I made efforts to resolve below issue by trick .I attached the
solution sheet .I just create another field that count all the repetative
values so by combining thiere count with actual field i get primary key that i
can use for lookup .Please have the attached solution sheet . I m gr
