Dear Sudhir,
Just would like to mention that the cells should be in date format, only
then this function will work.
Regards,
Anubhav
On Wed, Jan 19, 2011 at 2:59 PM, Manoj kumar wrote:
> use either of them :-
>
> =(B1-A1)+1
> =DATEDIF(A1,B1,"d")+1
>
>
> Regards,
> Manoj Kumar
>
>
> On Wed, J
Dear All,
I have data for two years arranged in 2 columns respectively.
Example.
*Yr1*
*Yr 2*
A
A
B
B
C
C
D
D
F
H
I
Now i want is to make a combined list (lets say in column 3) but there
should be no repetitions in this list (as in the above example, after
combining, i should o
Hi All,
I have a query.
I maintain a sheet of Project PO's (purchase orders) and PO numbers go in
1000's... These entries are done manually and there can be manual error by
which the same number gets repeated. (the entries are not done in serial,
i.e., after PO no. 1, the next can be 12.. followe
hi sheetal!
why dont u copy the entire sheet.. and paste it on another (unprotected
sheet)..
a bit silly suggestion.. just chk if it works for u..
u wont atleast loose the working..
Regards,
Anubhav
On Sat, Nov 21, 2009 at 7:15 AM, sheetal lakhotia wrote:
> Hi Friends,
>
> Is there anyway to
Hi Himadri,
I m not sure if i hv understood the query correctly, pls clarify...
U are unable to give the effect of customer reduction once a client leaves.
I assume that wn a client leaves, all customers linked to that client also
go off?? right??
If i m right, do you have any data (or summary) of
Dear Members,
I am not used to working on macros. though i have prepared simple macros but
i wish to learn more.
I seek guidance and suggestion from all.
Regards,
Anubhav
--~--~-~--~~~---~--~~
--
Dear Members,
I am not used to working on macros. though i have prepared simple macros but
i wish to learn more.
I seek guidance and suggestion from all.
Regards,
Anubhav
--~--~-~--~~~---~--~~
--