Wow,
Great,
Marvellous,
I gets excited when I see the beauty of Macros...
A combination of few words can do a lot for you.
Thanks to everyone, Ansari, Asa, Tag the one whose macro i have applied
ie.. Don
Thanks
On Friday, July 6, 2012 7:06:37 PM UTC+5:30, Don Guillett wrote:
You could
I am Zero in VBA Macros but attracted toward them just because i know excel
formulas has limitations.
I want to understand the code written by Noorain Bhai..,,
Secondly, the code by Don is perfect for me but there is a problem, i.e. It
add a row in the sheet , not in the table only.
So suppose
Hi Karan,
PFA...
Use this formula for unique extraction:
=IFERROR(INDEX($A$1:$A$11,MATCH(0,COUNTIF($C$2:C2,$A$1:$A$11),0)),)
And for counting unique numbers:
=SUM(1/COUNTIF(A1:A11,A1:A11))
Thanks Regards,
*Deba Ranjan P*
On Sat, Jul 7, 2012 at 11:58 AM, Deba Ranjan
Hi Ranjan Sir
Thanks. That was really very innovative. The solution that you provide
takes one year after the another. But my requirement is to take the
complete set of values relating to different years , given at a time, in
one go and plot chart accordingly.The chart must depict all the years
Hi Group,
Would request you to please help me in upgrading the formula in the
attached excel sheet.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Hi All,
I am new to excel , I just wanted to know how excel offset function works?
__
Regards
Priti Verma
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem,
To limit the columns.
ActiveCell.Resize(, 4).Insert shift:=xlDown
activecell + 4 columns
or
Selection.Insert shift:=xlDown
select the columns of the row desired
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: B Sharma
Sent: Saturday, July 07, 2012 1:21 AM
Hi All,
Is there any way in excel, that we can make a standard spreadsheet, to
convert time from IST to BST and BST to IST for Regular and Daylight Saving
Time as well.
Waiting for experts solution.
--
*Best Regards
Pooja Sharma*
*
*
**
*Smile is a beautiful curve, which sets everything
see if it helps
http://www.tushar-mehta.com/excel/timezone.htm
On Sat, Jul 7, 2012 at 6:54 PM, Pooja Sharma vatspoojav...@gmail.comwrote:
Hi All,
Is there any way in excel, that we can make a standard spreadsheet, to
convert time from IST to BST and BST to IST for Regular and Daylight
http://www.cpearson.com/excel/Rank.aspx
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: santosh subudhi
Sent: Saturday, July 07, 2012 5:42 AM
To: excel-macros
Subject: $$Excel-Macros$$ Need to upgrade a formula
Hi Group,
Would request you to please help
Please see the attached file
Good information on this site about IST and BST:
http://wwp.greenwichmeantime.com/to/ist/to-bst/index.htm
__
Regards
Priti Verma
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Pooja Sharma
Sent: 07 July
check these out
http://sculpt.wordpress.com/2007/01/04/create-a-dynamic-named-range-using-offset/
http://www.contextures.com/xlPivot01.html
http://tipsindeed.com/excel-functions/dynamic-range-in-excel-using-offset-and-counta-functions.html
This should cover ALL contingencies as if finds the last row, finds the 1st and
last columns to evaluate and the row to insert.
Sub insertrowsifSAS()
Dim lr As Long
Dim c As Long
Dim I As Long
lr = ActiveSheet.UsedRange.SpecialCells(xlCellTypeLastCell).Row
'finds the first column to evaluate
For
When all else fails, try the f1 button
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: priti_verma
Sent: Saturday, July 07, 2012 8:04 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How Offset function Works
Hi All,
I am new to excel ,
Hi Hilary/ Ayush
There is one more contest for u which is sent out in today mails with
subject :
2012 Gooxcel Challenge
There are 8k+ users in this forum , let all of us participate and win the
prizes so that forum moderator will be very happy .
On Sat, Jul 7, 2012 at 7:44 PM, Hilary
Hi Hilary,
Just to have a look I have downloaded your file and enabled the macros in
my computer. But since then My ribbon is has dissappeared and I'm unable to
get it back. Please give me the steps to unlock and make my excel to normal
one.
Thanks,
On Sat, Jul 7, 2012 at 5:14 PM, Hilary
Hi Ahmed
Usually i want the dashboard to be viewed in full screen mode, hence the
disappearance of the ribbons, you can however navigate your way thru the
table of content by clicking on the named pages or just double click on the
to bar pane to see the ribbons or to exit full screen mode. HTH
Dear Rohan,
The code seems to be correct. You need to add some libraries it seems.
Regards,
Anand
On Friday, 6 July 2012 10:11:16 UTC+5:30, Rohan Young wrote:
Dear Ashish Ji,
thanks but i m not getting the result, can you please send me the add
in or anything else for it
regds
Hi Don Guillett
The macro is giving syntax error
Please help.
Regards
Vijay yadav
On Friday, 6 July 2012 12:29:14 UTC+5:30, vijay yadav wrote:
Hi Experts,
I need a macro which coluld do the following
1)top row contains integer 1 to 50 from B column to BZ column
2)other rows
see if it helps
Sub sample()
Dim i As Long, j As Long, s As Integer
For i = Sheets(038G-C034-E-CABLE).Range(A65356).End(xlUp).Row - 1 To 3
Step -1
For j = 8 To
Sheets(038G-C034-E-CABLE).Range(h2).End(xlToRight).Column
If Sheets(038G-C034-E-CABLE).Cells(i, j).Value 0 Then
Hi Dguillett,
The below provided link doesn't solve my problem.Please look at the
Yellow colored cells for the desired result.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
From: dguille...@gmail.com
To: excel-macros@googlegroups.com
Subject: Re:
Dear Santosh,
Please try it..
=INDEX($J$3:$J$11,SMALL(IF($O$3:$O$11=J21,ROW($J$3:$J$11),),COUNTIF($J$21:J21,J21))-2)
with ctrl+shfit+enter
see attached sheet.
On Sat, Jul 7, 2012 at 9:45 PM, santosh subudhi
santoshkumar.subu...@gmail.com wrote:
Hi Dguillett,
The below provided link
THANKS !
This is it Ashish..thank you!
You are just bang on!
Also thanks to Don Guillett for the help
Regards
Vijay yadav
On Friday, 6 July 2012 12:29:14 UTC+5:30, vijay yadav wrote:
Hi Experts,
I need a macro which coluld do the following
1)top row contains integer 1 to 50 from B
Hi All,
Is this any problem for not replying to my query or want to have some more
information?
As i earlier informed, If you have any doubts please send me mail i will
explain but till now expect rajan no buddy has replied to my mail. And i am
waiting for the rajan reply but i don't know
Hi B Sharma,
Please See the Attachment, hope this will help you.
Regards
Prince
On Friday, 6 July 2012 17:15:20 UTC+5:30, B Sharma wrote:
Dear Excel Experts,
I have a protected data sheet, where I want to insert row where the cursor
is selected.
I need a VBA code who will do the
25 matches
Mail list logo