You can use sumproduct also
=sumproduct(--(and((a:a)>=c1,(a:a)<=c2),b:b)
Assuming dates are in a row , amount are in b row. C1=smaller cutoff date and
c2=latest date .
Hope it works for you! :)
Sandeep
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Ali Abbas
Sender:
Thanks Noorain Bhai and Kuldeep Bhai for the explanation.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN ANSARI
Sender: excel-macros@googlegroups.com
Date: Tue, 16 Jul 2013 20:08:00
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googleg
Dear All,
My question is also the same why we are using choose funtion here! If any one
please explain the same then will be very thankful.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Kanwaljit Singh Dhunna
Sender: excel-macros@googlegroups.com
Date:
Dear Noorain,
Can you please elaborate the funtion!
Thanks in advance.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN ANSARI
Sender: excel-macros@googlegroups.com
Date: Tue, 16 Jul 2013 17:37:03
To: excel-macros@googlegroups.com
Reply-To: excel
Okay! I am not very proficient with VBA. If you pls help me out in this regard!
Thanks Sandeep
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Vabs VBA
Sender: excel-macros@googlegroups.com
Date: Mon, 1 Jul 2013 21:12:36
To: excel-macros@googlegroups.com
Reply-To: excel-m
Thanks is there any other way out! Table not worked in lower version 97-2003.
Sandeep
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Vabs VBA
Sender: excel-macros@googlegroups.com
Date: Mon, 1 Jul 2013 19:26:21
To: excel-macros@googlegroups.com
Reply-To: excel-macros@goog
Any Help in this regard! Any suggestion will be welcomed!
Sandeep.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: chhajersand...@gmail.com
Date: Mon, 1 Jul 2013 10:39:12
To: excel-macros
Reply-To: chhajersand...@gmail.com
Subject: Re: $$Excel-Macros$$ Dependent Data valid
Hi, Vabs,
Actually I have created name range Assets with formula like =(Input!$B$2:$B:$6
) and another name range i.e. Assets1 with formula
=offset(input!$B$2,0,0,counta($B:$B)-1,1)
So in second case I.e in Dataval dynamic sheet I have tried to use 'Assets1'
as name range instead of 'Assets' a
Pls ignore the previous mail and find the attached file here!
Sandeep.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Vabs VBA
Sender: excel-macros@googlegroups.com
Date: Mon, 1 Jul 2013 12:52:50
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Su
Thanks Vabs. pls find the excel file!
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Vabs VBA
Sender: excel-macros@googlegroups.com
Date: Mon, 1 Jul 2013 12:52:50
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Exc
Please if any one know the reason and solution for this revert back!!
Sandeep
Sent on my BlackBerry® from Vodafone
-Original Message-
From: chhajersand...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Mon, 1 Jul 2013 04:37:25
To: excel-macros
Reply-To: excel-macros@googlegroups.
Dear Excel expert!
I am stuck at a point! I have kept five dynamic name range using offset funtion
viz Grouping which has a component like liabilities, asset, income and
expenses. And also have created dynamic name range for all of the components!
My name range are working perfectly when I am u
Hey instead of printing individual sheet at a time, you can use print workbook
(hide those sheets which is not required) and set the print into duplex mode! I
think it may help you.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Chris
Sender: excel-macro
Dear Noorain,
Thanks for the reply but can we do it by using function.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN ANSARI
Sender: excel-macros@googlegroups.com
Date: Tue, 4 Jun 2013 12:26:53
To: excel-macros@googlegroups.com
Reply-To: excel-m
Dear expert,
Many time I have to add every third or every forth or every second row or
column etc...can you suggest a function which will ease my problem! Till now
I am adding required cell one by one!
Kindly help!
Sandeep
Sent on my BlackBerry® from Vodafone
--
Are you =EXP(E:RT) or =NO
How many alphabets are there? are there always 4 alphabets grouped together?
And are always the alphabets in capital letter?
Sandeep
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "Vikas Bhosale"
Sender: excel-macros@googlegroups.com
Date: Mon, 3 Jun 2013 05:32:34
To:
Thank you very much Paul, Kanwaljit and Sam for your quick response. :)
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Sam Mathai Chacko
Sender: excel-macros@googlegroups.com
Date: Thu, 18 Apr 2013 00:13:35
To: MS EXCEL AND VBA MACROS
Reply-To: excel-mac
Dear Expert,
I want a formula where decimal will rounded off in multiple of 0.25 paise.
Like if amount is between 100.00 to 100.24 it will show 100.00.
if amount is between 100.25 to 100.49 it will show 100.25.
if amount is between 100.50 to 100.74 it will show 100.50.
if amount is between 100.75
Hey Paul, David thanks for your clarification. :)
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Paul Schreiner
Sender: excel-macros@googlegroups.com
Date: Fri, 22 Feb 2013 04:59:54
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros
Thanks David its working correctly. Can you please explain ! :)
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: David Grugeon
Sender: excel-macros@googlegroups.com
Date: Fri, 22 Feb 2013 21:30:49
To: excel-macros@googlegroups.com
Reply-To: excel-macros@goo
Thanks for quick suggestion but it is not full proof where there is only 8 is
written it is not working. Again for strange reason where 2.30 was written
after converting it become 2:03. Don't know why! Pls suggest!
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
Dear excel guru,
I have a problem...I want my hour to be written as 4:45. But I entered 2
data as 4.45. Now if I am changing it to [h]:mm format through custom format I
am getting 10:48 AM please help how can I convert it to 4.45 to 4:45.
Thanking you.
Sandeep Chhajer.
Sent on my BlackBerry®
Dear excel guru,
I want to copy only the 2nd sheet of the all workbooks from a particular
folder. Please accordingly rectify the below mentioned code which I also got
this forum.
Option Explicit
'32-bit API declarations
DeclareFunction SHGetPathFromIDList Lib "shell32.dll" _Alias
"SHGe
Wish you all Merry Christmas!!
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: ashish koul
Sender: excel-macros@googlegroups.com
Date: Tue, 25 Dec 2012 11:45:53
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Merry Christmas
Dear all,
Since the day I have been to this group I am amazed with one thing what you
guys are made of !!!
Any time, from any where, we are sending you our daily problems; sometimes its
out of real issues; some times it is out of our fantasy, but you people are
always on your feet to help us!!
Sent on my BlackBerry® from Vodafone
-Original Message-
From: chhajersand...@gmail.com
Date: Sat, 15 Dec 2012 07:12:15
To:
Reply-To: chhajersand...@gmail.com
Subject: Re: Fwd: $$Excel-Macros$$ Capture both the action "check" and "uncheck"
Dear Praveen,
Thanks for the reply.
Actually f
Dear Praveen,
Thanks for the reply.
Actually frankly speaking I don't have any file right now with me. But I can
discuss the problem.
I want to hide two rows with a click in check box. So by recording macro I am
able to do that!!
But now I want to unhide this two row when it uncheck the "Check b
Dear Excel guru,
I want to capture check box uncheck procedure! I have assigned a macro to
check box! So when I click it, it works perfectly but now I want that when I
untick it, it works differently from that!
Please help!
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
--
Join offi
Dear excel guru is there any way to make data validation effective in case the
source data is copied from other source! (As I have observed that data
validation would not work in case some data is copied from other source!!!
Please help!
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
Dear Excel guru,
I have tried this data validation to stop duplicate entry as well as :
=and(countif($e$3:$e$500,e3)=1,len(e3)=15)
Though when some is making manual entry its working fine but it stops working
if someone copy from above or somewhere else.
Can I do something to stop this!!
Pleas
I am also agree with paul. But for the 3rd question I want to add one sentence
that you can select all the sheet using ctrl key that you want to hide and
then use hide key to hide all the selected sheet together.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
Dear Rakesh,
Do you want a text to be divided into different column based on some operators?
Then you can use "Text to column" to split a cell (read a cell containing text)
to many cells (i.e. Columns).
If this help is not sufficient then please share workbook with us as Anil bhai
has suggested
Thank you sir.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN ANSARI
Sender: excel-macros@googlegroups.com
Date: Thu, 8 Nov 2012 11:27:38
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Required tutorials to learn Basics
Dear Excel Gurus,
Recently I have came to know about excel dashboard and its potential while
presenting reports. Can any one send me some tutorials for the beginners like
me.
Thanking you in advance.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
--
Join official facebook page of this f
Dear All,
Suppose I have column of data which is linked with column d of another sheet.
Like
'Sheet1!D5
'Sheet1!D6
'Sheet1!D7
'Sheet1!D8
'Sheet1!D9so on.
Now I want the destination column of entire linked column to be changed to e
like
'Sheet1!e5
'Sheet1!e6
'Sheet1!e7
'Sheet1!e8
'Sheet1!e9...
Swapnil I am getting a problem when ever I am trying to change any of the sheet
it is saying run time error 9 code out of range. Can it be fixed?
Thanks in advance.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: chhajersand...@gmail.com
Date: Sun, 7 Oct 20
Thanks Swapnil. Its working fine. It will be beneficial to us if you may try to
explain the code. :)
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Swapnil Palande
Sender: excel-macros@googlegroups.com
Date: Sun, 7 Oct 2012 13:25:41
To:
Reply-To: exc
Sent on my BlackBerry® from Vodafone
-Original Message-
From: ashish koul
Sender: excel-macros@googlegroups.com
Date: Sun, 7 Oct 2012 11:23:29
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro for Insert and delete worksheets according
the list in sheet1
Dear all,
Good Morning.
I want a macro which can create/ insert/ or delete worksheet according to the
list prepared in sheet1.
Like if I delete a name from the list the corresponding sheet will be deleted
or if I insert a name in the list it will create a sheet with the same name. It
will be b
My self Sandeep Chhajer from Mumbai. I am a Chartered Accountant by profession.
This group has changed my perception of workingwith excel.
I am really thankful to this group and its wonderful members.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From:
Sorry to all, wrongly pressed send button.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "Rajan_Verma"
Sender: excel-macros@googlegroups.com
Date: Sun, 30 Sep 2012 08:50:52
To:
Reply-To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$
Any
Good morning to all,
Do any one have macros or aad-in on Benford's law.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurat
Sent on my BlackBerry® from Vodafone
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem,
Thanks Prince. I have made it public. Though I don't know the basic difference
between the scope to be private or pubic.
So will send you the work sheet.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Prince Dubey
Sender: excel-macros@googlegroups.com
Da
Dear all,
I have made a UDF (formula) in personal.xls file. Though it is working when I
am working @ personal file but when ever I am trying to use it in my other
worksheet the formula is not working. Please help.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
--
Join official facebook
Dear Ruchir,
If you share your work with us it would be an immense help for us also.
Thanks,
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Sam Mathai Chacko
Sender: excel-macros@googlegroups.com
Date: Tue, 4 Sep 2012 22:32:36
To:
Reply-To: excel-macro
Pankaj then check your filter settings of mails.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: pankaj gmail account
Sender: excel-macros@googlegroups.com
Date: Thu, 5 Jul 2012 13:19:17
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ MVP Award..
Congratulation Ashish and Dilip.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Sam Mathai Chacko
Sender: excel-macros@googlegroups.com
Date: Mon, 2 Jul 2012 21:01:24
To:
Reply-To: excel-macros@googlegroups.com
Cc: Dilip Pandey
Subject: Re: $$Excel-Macr
Please send me also @ chhajersand...@gmail.com
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Rakesh Kumar Sharma
Sender: excel-macros@googlegroups.com
Date: Tue, 12 Jun 2012 19:03:51
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macr
Dear all,
Please try to find out any solution!
Sandeep Chhajer
Sent on my BlackBerry® from Vodafone
-Original Message-
From: chhajersand...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Mon, 11 Jun 2012 10:59:23
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macro
Dear Mentors,
I want to create tables in Excel 2010 as following
My data in excel is
Column 1.Column 2
Reserve_surplus Other_exp
Capital Reserve. Salary
Securities Premium. Printing
Revaluation reserve. Insurance
General Reserve.
Hi all,
I am Sandeep Chhajer, a Chartered Accountants by profession from Mumbai.
I am also an excel enthusiastic like you all. Apart from that I also like to
watch all sorts of out door sports.
I am really thankful to the group which makes me amazed every time with its
innovative formulas,UDF,
Hi Ayush, Noorain and all mentor,
You all are the best mind in the field of Information Technology. So please do
needful to stop this type of cross advertising and abuses.(Happened on today
morning by Viktorija Zukauskiene ). We have an esteemed group so I am urging
every true member of this gr
Dear all,
I also want the e-book on excel 2007.
Given that the demand and hectic schedule of Mr. Noorain, I urge those members
(who already have received the book from Noorain) to send to us.
My mail I'd is chhajersand...@gmail.com
Thanks
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafon
Thanks to all of you. Its working fine.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "dguillett1"
Sender: excel-macros@googlegroups.com
Date: Mon, 28 May 2012 10:52:43
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Data valid
Dear excel guru,
Is there any way I can keep source data list in another sheet (other than where
I want to put the data validation) for data validation "list" command.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
--
FORUM RULES (986+ members already BANNED for violation)
1) Use conci
Thanks Rajan I will try it!
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "Rajan_Verma"
Sender: excel-macros@googlegroups.com
Date: Mon, 28 May 2012 19:17:12
To:
Reply-To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ macro to make unlocke
Thanks to all! I will try and revert back to you!
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: chhajersand...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 17 May 2012 04:21:51
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Ma
Dear all,
I want to create a list in data validation which take a dynamic range in
alphabetic order. Can it be possible I have tried to find it google but could
not solve this though have got solutions!
Please help like you help us with indirect function module!
Sandeep Chhajer.
Sent on my B
Dear sir,
I want dynamic data validation(list) where
my name range to be dynamic.
Example: Group containing cell are in G2:dynamic range.
For every group I have sub group. The range of subgroup is also should be
dynamic.
I can use fixed range with indirect function and name range but not dynamic
Any one giving classes @ Borivali Mumbai?
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: LAKSHMAN PRASAD
Sender: excel-macros@googlegroups.com
Date: Thu, 5 Apr 2012 02:38:25
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subjec
Thanks Maries and Sam. Both the formula are working fine!!
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Sam Mathai Chacko
Sender: excel-macros@googlegroups.com
Date: Sat, 31 Mar 2012 13:24:18
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$E
Thanks maries! I will check and send you the feed back.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Maries
Sender: excel-macros@googlegroups.com
Date: Sat, 31 Mar 2012 10:51:58
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
Dear excel guru,
I want a macro to insert 100 sheets (all are same/smilar copy of sheet 1) o
sheet will be named 2...3..4...and so on!
Please help.
Thanks Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurat
Dear All,
I really want to share my experience...I still cherish the day when out of
curiosity I joined the group 3 yrs back as a novice.and now a I can't say I
am an expert but a full blown excel lover...can't stop a day also without
seeing our posts and answers by our experts and also can'
After reading the translation I just want to say...
3 cheers for Excel macros group, Noorain for his original master piece and
avishek for ur spellbound translation!!
Hip Hip Hurrah!!
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Abhishek Jain
Sender: e
Thanks Damimkader. I will try and let you know.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "Damimkader S. Meeran"
Date: Thu, 22 Mar 2012 05:20:05
To:
Cc:
Subject: Re: $$Excel-Macros$$ Re: Macro for Insert a line for missing serial
numbers.
Hi,
I
Dear Damimkader S. Meeran,
Thanks for your reply.
With ref to your question:
I use office 2010 version.
And I want to insert 3 column in between (I.e 4,5,6).
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "Damimkader S. Meeran"
Sender: excel-macros@g
Dear all,
Please find my attachment ( I know asking question in this way is a violation
of our forum rule but sorry I don't have data card to copy the queries from
excel)
Thanking you in advance.
Sandeep Chhajer.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, ac
Dear Excel gurus,
I want to link my excel table which is in MS WORD as table with other MS EXCEL
file.
Can it be possible with any macros.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. P
Dear all,
Wish you Happy holi.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
--
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, Code Problem, and Need Advice will
Thanks Asa I have a column without heading.
I will check and get back to you soon!
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "Asa Rossoff"
Sender: excel-macros@googlegroups.com
Date: Tue, 6 Mar 2012 12:19:29
To:
Reply-To: excel-macros@googlegroups.c
No Joseph I have not applied freeze pane.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: joseph.cam...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Tue, 6 Mar 2012 16:41:15
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$
Dear Rajan,
I don't have any unhidden comment there because only 3 of my row is now visible
out of 5175 rows but my numbers are in the next column is in text so the usual
excel notification is there (upper left side with green mark).
Don't know what to do.
For data privacy also can't send the
Dear Excel gurus,
I am facing a unique problem.
I have a file which has been filtered.
Now when I am trying see all data..it is giving me a message saying.."fixed
objects will move".
I am clicking okay...but getting no result as it is appearing again and again.
I have closed the file forceful
Dear Shaik,
Thanks for the reply.
I want to learn it.
Actually I want to make a format for indian number format.
1,11,11,111 for +ve
(1,11,11,111) -ve
- for zero.
Pls help.
Sandeep.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Shaik Waheed
Sender: excel-macros@googl
Dear excel guru,
Please tell me how to use custom format in excel.
What does different symbol like #,;/ etc suggest.
Thanking you in advance.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles
Dear Amit,
Its mean that when ever you send your mail next time set your email priority to
normal rather than urgent.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "Amit Desai (MERU)"
Sender: excel-macros@googlegroups.com
Date: Thu, 23 Feb 2012 07:01:40
Thanks Sam and Don both are working good.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "dguillett1"
Sender: excel-macros@googlegroups.com
Date: Thu, 16 Feb 2012 08:42:20
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Round o
Dear Excel gurus,
I have a sheet with figures and formulas.
I want a macro which can convert all the numbers in to round off up to two
decimal but not the formulas.
Like if in any cell value is 22.455
Macro should do +round(22.455,2) automatically.
But if it is sum(a2:a9). It should remain same
Thanks sam for so quick solution. I will use it and get back to you.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Sam Mathai Chacko
Sender: excel-macros@googlegroups.com
Date: Wed, 15 Feb 2012 23:53:53
To:
Reply-To: excel-macros@googlegroups.com
Subjec
Dear Excel Expert,
I have a worksheet which is linked with a base file.
Now I want a macro to automatically round up to 2 decimal all the formulas of
worksheets.
That is if a link is now showing +'sheet1!$C$9 or +sum(a1:b2)the macro will
automatically convert it
+round('sheet1!$C$9,2) or +
Thanks Be Tran Van. Its really nice of you.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Bé Trần Văn
Sender: excel-macros@googlegroups.com
Date: Sat, 11 Feb 2012 21:20:17
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Add in f
Dear Excel Expert,
I am a ardent follower of this group and I have seen that some one has posted
in this forum a Add in to compare two worksheet.
May I request the expert to repost the add in again.
Thanking You,
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
--
FORUM RULES (986+ membe
Congratulation Noorain.
Hope you will keep helping us always in this fashion.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Vijayendra Rao
Sender: excel-macros@googlegroups.com
Date: Thu, 2 Feb 2012 09:48:00
To:
Reply-To: excel-macros@googlegroups.com
S
Thanks Noorain its working great!
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN ANSARI
Sender: excel-macros@googlegroups.com
Date: Tue, 31 Jan 2012 10:56:00
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Formula for m
Dear Excel guru,
I have a data like below
Admin. 5
Household.7
Production.2
Stores. 3
Admin. 2
Household.3
Production.1
Stores. 5
Admin. 6
Household.1
Production.3
Stores. 2
Now I want here the minimum no of respect
Dear excel advisor,
I want a macro which create a sheet automatically if I add a new product name
in a particular sheet with the name of the new product.
And also want a condition validation which restrict user from inserting
duplicate name where I insert the new product name.
Thanking you in
I think Mr Aysush should ban him for this violation!!
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: garwads...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 1 Dec 2011 16:51:50
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel
Dear Excel gurus,
I have noticed that many time you all use -- in a formula. Why is it been used
and when it should be used?
Sandeep Kumar Chhajer.
Sent on my BlackBerry® from Vodafone
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thre
Thanks Noorain.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN ANSARI
Sender: excel-macros@googlegroups.com
Date: Wed, 16 Nov 2011 11:58:18
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Pivot report with button
Dear
Dear all,
I have to make many pivot report from same data...like one is LR wise...
Other is Destination wise...Truck wise etc.
What I want to assign a button for every report. Like if I click on button1 it
will give me LR wise report if I click button 2 it will show me as Destination
wise and s
Thanks for quick reply.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN ANSARI
Sender: excel-macros@googlegroups.com
Date: Tue, 15 Nov 2011 15:36:41
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Convert Date to month
D
Dear all,
I have a date written as 01/04/2011, 03/05/2011; I want a function in next
column to show only April and May respectively.
Thanking you in advance.
Sandeep Chhajer.
Sent on my BlackBerryŽ from Vodafone
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accur
Please after copy, paste special it in un filtered data...(Use shortcut alt d f
s and then alt e s v tick @ skip blank)
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: vijayajith VA
Sender: excel-macros@googlegroups.com
Date: Thu, 10 Nov 2011 19:41:37
T
Sorry Kiran it sud be upper(text)
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: .•:*¨¨*:•. .•:V.Kiran Kumar :•. .•:*
¨¨*:•. vadnalaki...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 10 Nov 2011 17:30:20
To:
Reply-To: excel-macr
Use funtion Lower(text)
Or
Proper (text)
Sandeep Chhajer
Sent on my BlackBerry® from Vodafone
-Original Message-
From: .•:*¨¨*:•. .•:V.Kiran Kumar :•. .•:*
¨¨*:•. vadnalaki...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 10 Nov 2011 17:30:20
To:
Reply-To: exc
Please Copy in a filter mode the desired data. Then select all (alt d f s) and
in desired column use paste special (alt e s v ) and select skip blank option
there.
Hope fully it will solve ur queries.
Sandeep Chhajer.
Sent on my BlackBerryŽ from Vodafone
-Original Message-
From: vijayaj
Copy in a filter mode the desired data then use paste special (alt e s v ) and
select skip blank option.
Hope fully it will solve ur queries.
Sandeep Chhajer.
Sent on my BlackBerryŽ from Vodafone
-Original Message-
From: "dguillett1"
Sender: excel-macros@googlegroups.com
Date: Thu, 10 N
Select the column...go to find and replace...(CTRL+F) type the technology
company in space for find and keep blank in the space provided for
replace...then replace all.
Sandeep Chhajer.
Sent on my BlackBerryŽ from Vodafone
-Original Message-
From: "smitha.kumari"
Sender: excel-macros@
1 - 100 of 121 matches
Mail list logo
