Hi,
Any update on the below email? I am awaiting for your response.
It would be great if you could share this by today.
Thanks,
Sharma
-- Forwarded message --
From: amrahs k
Date: Mon, Nov 15, 2010 at 2:54 PM
Subject: Re: $$Excel-Macros$$ Fwd: Need Change!
To: excel-macros@googl
pretty sweet link below on the Google Chart API and the Google Chart Image
tool editor http://imagecharteditor.appspot.com/!
2010/10/25
>
> Today's Topic Summary
>
> Group: http://groups.google.com/group/excel-macros/topics
>
>- Filter criteria of one row - show previous
> row...<#12be5c
Hello All
I would like to create a macro that will save the current workbook to
a subfolder on a mapped network drive (z:\master\CB), with a filename
the same as the contents of cell G7 (an autogenerated number).
I would like to automate this as much as possible, so if it can be
done automatically
I'm trying to count the number of columns between two values in a row:
the maximum number in an array (e.g., max (A1:E1) and the last cell of
the array (e.g., E1).
So if the array is A1:E1, and B1 has the largest value, I need to
return 3 because there are 3 columns from B1 to E1 (including E1).
=IF(A1 >= A2, IF(YEAR(A1)-YEAR(A2)>0,YEAR(A1)-YEAR(A2)& " Year(s), ","") &
IF(MONTH(A1) - MONTH(A2)>0,MONTH(A1) - MONTH(A2) & " Month(s) , ", "") &
DAY(A1) - DAY(A2) & " Day(s) Left", "Please check the date(s)")
On Mon, Nov 15, 2010 at 11:14 AM, Manjunath C
wrote:
> Excellent one,,,its working,,
Hi Team,
I need your help for calculating Last Working Date from attached format.
As per policy below mention attendance legends count as a working day
P Present
HD Half Day
COD Comp Off Due
PL Privilege Leave
CL Casual Leave
SL Sick Leave
LP Loss Of Pay
ML Maternity Leave
O Weekly Off
CO Comp O
Hi,
Thanks for the swift response. I came up with different scenario after
applying the new function that you shared me.
Input: DECLARATION BY LAW ENFORCEMENT FOR WALK-THROUGH ARREST WARRANT AND
ORDER
Output: Declaration by Law Enforcement for Walk-through Arrest Warrant and
Order
Input: SETTLEME
