Hi Raj,
Can you attach a sample file?
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Raj Mahapatra
Sent: Friday, March 23, 2012 9:34 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ date should be today's date in calendar in user
form of
Hi Shrini,
See the attached file and let me know if this helps somehow :)
Regards,
DILIPandey
On 3/24/12, Shrinivas Shevde shrinivas...@gmail.com wrote:
Respected All,
Please find attached sheet I want help to make chart.
I want to make a bar chart of 2 different thing having the difference
Thanks Kris for the quick reply
A little bug in the formula
If you include the named range matchcol in the formula. The figures don't
update when you select another year.
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Kris krishnak...@gmail.com
Date:
It does. Set your calculation to automatic.
Kris
On Saturday, 24 March 2012 12:43:42 UTC+5:30, hilary lomotey wrote:
Thanks Kris for the quick reply
A little bug in the formula
If you include the named range matchcol in the formula. The figures don't
update when you select another year.
Hi Charlie, Good day -
I'm not sure what the trouble is.
Works in Excel 2010.
Just to reiterate, the macro does not make the tab key go from field to
field. It only has effect when a field (listed cell) is edited. What the
macro does: after you've edited a cell in the list, it selects
Dear Group,
I am generating the attached series by some criteria but required further
formula. Please review attached sheet.
Regards,
Aamir Shahzad
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
*Can You Please Explain More...*
Dear Group,
I am generating the attached series by some criteria but required further
formula. Please review attached sheet.
Regards,
Aamir Shahzad
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles.
How are we supposed to work out a formula if we don't know the criteria ??
On Sat, Mar 24, 2012 at 1:20 PM, Maries talk2mar...@gmail.com wrote:
*Can You Please Explain More...*
Dear Group,
I am generating the attached series by some criteria but required further
formula. Please review
In the first sheet, select the area you want to be printed (leaving the
buttons), right click and choose set print area.
On a difference note Shankar, you might want to keep in mind a simple rule
of this forum which I feel is extremely helpful in all cases. Reproduced
herebelow for ready
Hi,
Select *Cal Sheet Page1* === View Tab === Select Page Break Previow ===
Adjust One Page Break Lines By Cursor.
Thats It..!!
Regards,
MARIES.
On Sat, Mar 24, 2012 at 11:55 AM, Shankar Bheema shankar.n...@gmail.comwrote:
Dear experts
When I used to print the attached workbook. The two
Hi Kris
Kindly select start year as 2012 or 2013. You will realize that these two yrs
do not hv any data but if you select them its populates the data from 2006
onward instead of blank.
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Kris
Dear Experts
In the userform of the enclosed excel workbook, there exists two textboxes
for date format. Is it possible to get a background impression like
DD-MM- in a grayscale for the convenience of the users of the
application. That impression would disappear when user types a value for
OK
Replace the B3 formula on sheet1 with
=IF('PL (2)'!$H$4=ALL Year,2,MATCH('PL
(2)'!$H$4,INDIRECT('INDEX(ShtName,ShtSelected)'!A4:i4),0))
and in b12 and copy down across
Try Control Tip Text property for text box or a Msgbox when
form initializes.
On Sat, Mar 24, 2012 at 1:56 PM, Shankar Bheema shankar.n...@gmail.comwrote:
Dear Experts
In the userform of the enclosed excel workbook, there exists two textboxes
for date format. Is it possible to get a
Hi,
Please see the attached. Is this what you wanted?
1. I placed four pictures made them not visible upon form initialization
2. Four check boxes
3. An if condition of each check box - value = true, image visible, else
not visible
HTH
AJ
On Sat, Mar 24, 2012 at 5:56 AM, Mr excel
You always rock Noorain. This is really a great skill.
Thanks for writing poem and your great contribution to forum
-Ayush Jain
On Thursday, 22 March 2012 18:42:08 UTC, NOORAIN ANSARI wrote:
जहाँ Excel के दीवानों की, है बहूत घनी आबादी.
जहाँ Question,Answer करने की,है खूब आज़ादी.
ok I added the criteria in attached file, only need is if showing more than
1 then it should show as zero only one 1 should remain because this
customer is one.
Regards,
Aamir Shahzad
On Sat, Mar 24, 2012 at 12:58 PM, Abhishek Jain abhishek@gmail.comwrote:
How are we supposed to work out
Hi All,
Need a help in attached file. There is a column were random numbers are
generated. Need sum in a cell for all the random numbers which gets
generated. Attached herewith the file where and all the requirements are
mentioned.
Regards,
Saurabh Patel
DISCLAIMER:The information
Please explain.. how you want to sum.. do you want to generate random number
based on a DIGIT.
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Saurabh Madhusudan Patel
Sent: Mar/Sat/2012 04:11
To: excel-macros@googlegroups.com
Subject:
Understanding: Random numbers would keep generating.
Question: When will the batsman be out??
On Sat, Mar 24, 2012 at 5:42 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Please explain.. how you want to sum.. do you want to generate random
number based on a DIGIT.
** **
Rajan
Makes me wonder what this is for. Homework?
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Pascal Baro
Sent: Friday, March 23, 2012 8:19 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Cash allocation - your advice
Hi Cyberspace,
Please find a
Avinash my friend,
My pleasure.
As to the formula for C2. You should get the same result for formula #1 and
formula #3. The downside with those is that they refer to the
Responsibility column using A1 notation, which might lead to errors later.
The formula I provided uses notation only
I haven’t followed this but I think Charlie has a older version ( if that makes
a difference) ??
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Asa Rossoff
Sent: Saturday, March 24, 2012 2:27 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$
Yeah, I realize -- he's on 2000. Nothing jumped out at me in the
macro/workbook he's discussing that obviously relied on any new features. I
can't claim to be the ultimate version expert though.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of
When ever 0 comes as a random number, batsman gets out. Attached is the
revised one.
Random number gets generated when clicked on BOWL button
Please explain.. how you want to sum.. do you want to generate random
number based on a DIGIT.
Not required. It is already there in
try
=IF(COUNTIF($C$12:$C$15,F9),0,IF(AND(COUNTIF($B9:$B$9,B6)=1,COUNTIF($E$12:$E$15,F9)),1,0))
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Saturday, March 24, 2012 5:50 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
Ok
You can use SUM(Number1,Number2,Number2..)
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Abhishek Jain
Sent: Mar/Sat/2012 05:55
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Sum of all the random numbers generated
Dear Asa,
Thanks A lo it works well. Both the formula and the results
are working fine plus it is not time consuming.
thank you very much .
but i have just one question if i put additional data in to the table then
also it will work as it is or do i need to rebuilt all the
Excel keeps wanting to override me and make row 1 be column headers but in
a particular case I need it to be just data. Any way to force this?
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need
try this simpler version where I rewrote the formulas in the c:e and then
copied that block to each of the other blocks
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Lokesh Loki
Sent: Saturday, March 24, 2012 11:25 AM
To: excel-macros@googlegroups.com
Subject:
??
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: tangledweb
Sent: Saturday, March 24, 2012 11:46 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Is there a way to tell excel the first row is
definitely data and not column names?
Excel keeps
nope, professional training, I found my own answer so it's just extra
On Saturday, March 24, 2012 1:43:07 PM UTC, Don Guillett wrote:
Makes me wonder what this is for. Homework?
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
*From:* Pascal Baro
Hi Noorain,
Thanks for helping now the formula is working fine.
Thanks a lot brother.
Regards
Lokesh.M
On Sat, Mar 24, 2012 at 11:05 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Lokesh,
Please check attached sheet..
Hope is it working good, Please check and confirm.
--
I got it myself. Well thanks for your reply.
=IF(IF(COUNTIF($C$12:$C$16,F9),No,IF(COUNTIF($E$12:$E$15,F9),Yes))=No,,IF(COUNTIFS(B9:$B$9,B9)1,,1))
Regards,
Aamir Shahzad
On Sat, Mar 24, 2012 at 7:59 PM, dguillett1 dguille...@gmail.com wrote:
try
Are you saying that you start with the final amount, ie 309.84 then use the
required values @ 66 to find the amount of each various amount needed to get to
the difference to come up with (bottom row shown here)
66
20 10 5 1 50p 20p 10p 5p 2p 1p total
20.00 10.00
Avinash,
Yes, that is one the beauties of using tables -- they automatcially expand and
contract. The structured table references will always refer to the applicable
columns/parts of the table no matter how much or little data is in the table.
If you move columns around, just be sure to
36 matches
Mail list logo