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 upd
2012/3/25 Raj Mahapatra
> please find the attached file and click "RUN ENTRY"
> Then Click 'Transcation Date"
>
> Thanks & Regards
>
>
> On Sat, Mar 24, 2012 at 12:30 PM, Asa Rossoff wrote:
>
>> Hi Raj,
>>
>> Can you attach a sample file?
>>
>> ** **
>>
>> *From:* excel-macros@googlegro
At first, you need to put aside 66 since you must use 2 bills (or notes) of
$20, 2 bills of $10, 1 bill of $5 and 1 for $1. All the required notes make
$66. Then you can make any adjustment with the 50c, 20c, 10c, 5c, 2c and
1c. People who like binary counting and all that stuff should be fine
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 5.00
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 wrote:
> try
>
> =IF(COUNTIF($C$12:$C$15,F9),0,IF(AND(COUNTIF($B9:$
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
wrote:
> Dear Lokesh,
>
> Please check attached sheet..
>
> Hope is it working good, Please check and confirm.
>
> --
> Thanks & regards,
> No
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
??
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 wanti
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: $
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
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 form
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
U
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$$ Formu
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
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 dguil
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$$ Turn
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 availa
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 wo
Understanding: Random numbers would keep generating.
Question: When will the batsman be out??
On Sat, Mar 24, 2012 at 5:42 PM, Rajan_Verma wrote:
> Please explain.. how you want to sum.. do you want to generate random
> number based on a DIGIT.
>
> ** **
>
> Rajan
>
> ** **
>
> *From:*
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: $$Excel-M
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 c
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 wrote:
> How are we supposed to work out a formula if we don't
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 करने की,है खूब आज़ादी.
>
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 wrote:
> hi
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 wrote:
> 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 l
OK
Replace the B3 formula on sheet1 with
=IF('P&L (2)'!$H$4="ALL Year",2,MATCH('P&L
(2)'!$H$4,INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A4:i4"),0))
and in b12 and copy down & across
=IF(ISNUMBER(MatchCol),IF(COLUMNS($A12:B12)<=$H$6+1,INDEX(INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A5:i120"),
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
t
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
Date: Sat, 24 M
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 wrote:
> Dear experts
>
> When I used to print the attached workbook. The two sheets have to b
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 referen
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 wrote:
> *Can You Please Explain More...*
>
>
>
>> Dear Group,
>>
>> I am generating the attached series by some criteria but required further
>> formula. Please review attached sh
*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 thre
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,
Urgent,
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 th
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
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
Date: Fri, 23 Mar 2012 21:50:49
Hi Shrini,
See the attached file and let me know if this helps somehow :)
Regards,
DILIPandey
On 3/24/12, Shrinivas Shevde 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 very
> vast
> for an
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 e
38 matches
Mail list logo
