Hello Guys,
Fill Handle(the small black square on the bottom-right corner of a selected
range of cells) is one of the best option to fill dates, in fact you can
fill Days, Weekdays, Months and Years as well.
*Here is the option :- *
Instead of dragging the Fill Handle while holding down the
DEAR FRIEND,
PLEASE TYPE
1/1/11
2/1/11
THEN TAKE BOTH COLUMN IN RANGE AND DRAG
On Thu, Jan 13, 2011 at 7:34 AM, J D wrote:
> I am no whiz kid with Excel but use it all the time. I usually just
> put a date in a cell drop to the next one and add 1. A1 would be the
> date formated how I want, A2
I need to take it a few steps further.
Yes I can drag the dates down and Excel will implement next proceeding date
in line. Here's the actual scenario: TOR and NOR are from my job-- word
acronyms.
Column AColumn B
01/01/2011 TOR (has no fill)
01/01/2011 NOR (bot
Hi,
Not sure if I'm missing the point here, but what about just typing the date
into your first cell, then press enter. From there, select your first cell and
drag the copy-down handle down as far as you want. XL defaults to incrementing
the date one day at a time.
Regards - Dave.
> Date: Wed
I am no whiz kid with Excel but use it all the time. I usually just
put a date in a cell drop to the next one and add 1. A1 would be the
date formated how I want, A2 would be =A1+1. I then copy and paste
that down the column or acroos a row. I have one spreadsheet that
covers the year. I just u
Hi Dave,
If by formulas you mean "expressions you create & by function "expressions
already available in excel", Then you can submit your favorite function.
By the way, I like the way you think.
Thank you.
Best Regards,
Ayush Jain
On Thu, Jan 13, 2011 at 8:48 AM, ayush jain wrote:
> Hi Dave,
It's been a while since I played with Add-ins...
But the last time I did, I discovered that when the user opens the .xla file,
it
makes a "local" copy.
But, the trick is that... if the user has Excel open, it has
the add-in open.
If you send him an update, it does not overwrite the local file,
Hi Dave,
Yes, This question is for favorite excel formula and not function.
Thanks.
On Thu, Jan 13, 2011 at 7:40 AM, Dave Bonallack
wrote:
> Hi Ayush,
> There seems to be some confusion. I thought the question related to our
> favourite formula, not favourite function. Please clarify.
> Regard
Hi Friends,
My BEST formula Vlookup().
Reason:- i had done hell lot of things using this single formula wen i didnt
know VBA in my 1st office.
From: Dilip Pandey
To: excel-macros@googlegroups.com
Cc: jainayus...@gmail.com
Sent: Wed, 12 January, 2011 3:25:12
Hi Ayush,
My formulae: SUMIF
Most I use to different products, it helps a lot.
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Rohan Young
Sent: Wednesday, January 12, 2011 1:31 PM
To: excel-macros@googlegroups.com
Cc: jainayus...@gmail.com
Subjec
Hi Manish,
Place this code in the appropriate VBA sheet window
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 2 Then Cells(Target.Row, 3).ClearContents
End Sub
Hope this helps
Regards - Dave.
> Date: Wed, 12 Jan 2011 02:27:22 -0800
> Subject: $$Excel-M
Hi Ayush,
There seems to be some confusion. I thought the question related to our
favourite formula, not favourite function. Please clarify.
Regards - Dave.
From: rohan.j...@gmail.com
Date: Wed, 12 Jan 2011 16:01:19 +0530
Subject: Re: $$Excel-Macros$$ Formula of the week - share your best for
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 And UCase(Target.Value) = "YES" Then
Target.Offset(0, 1).Clear
End If
End Sub
if you will type yes in col b it will clear the content in col c
On Wed, Jan 12, 2011 at 3:57 PM, Manish wrote:
> Hello friends,
>
> I need a
hi,
please see the attachment if it meets with ur requirement, sorry for late
the server was down
hope it will help
Thanks & Regards
ROHAN
9818247278, 8860567680
On Wed, Jan 12, 2011 at 4:03 PM, Rohan Young wrote:
> please try =A1+1 (if A1 has the date 1/1/2011)
>
>
>
> On Wed, Jan 12, 2011
please try =A1+1 (if A1 has the date 1/1/2011)
On Wed, Jan 12, 2011 at 10:50 AM, Susan wrote:
> Hi,
>
> I’m looking for a formula that will add all dates of the month. It will
> auto-populate for me the next day in the month.
>
> Column A
>
> 01/01/2011
>
> 01/02/2011
>
> 01/03/2011
>
> Etc, e
Hi Ayush Ji,
My formulas are
*CHOOSE -* we can rank the candidates with choose & code combination
CHOOSE(CODE(B1)-64,"Excellent","Best","Poor"), if B1has the value A, B, or
C.
*CELL("FILENAME",A1) - *we can get instant result of the path of the current
file with sheet name.
*REPT - *This one g
Hello friends,
I need a small help.
I want the VBA code for following task.
If someone change the value in B2 column, macro will clear the value
of C2 column.
If someone change the value in column B3, macro will clear the value
of column C3 and so on...
Please suggest me the code.
Thanks in ad
Hi Ayush,
One of my *Best* formula is *OFFSET*.
Reason:- It can be used in getting the desired value (located) anywhere in
the spreadhseet, the desired Sum, Average etc. It is also used
for creating dynamics ranges - which further can be used in formulas /
conditional formatting.
Best Regards,
18 matches
Mail list logo
