In this case, in cell C5 you could use a calculation like:=(Q35 -1) * 10
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you ca
Hi,
Can any one please help me to arrange a formula, so that if the number in a
selected cell increases, the corresponding answer in another cell will
increase accordingly.
How do i arrange the formula in Excel, so that if Q35(cell number)=1, the
answer (in cell C5) is 0;
please elaborate
.
Enjoy
Team XLS
On Tue, Dec 17, 2013 at 3:23 PM, sridher sharma wrote:
> how do I save a table? I have taken my data, created a table and then
> tried to 'save as' but when I reopen it, it is back in the original
> worksheet format. What am I missing?
how do I save a table? I have taken my data, created a table and then tried
to 'save as' but when I reopen it, it is back in the original worksheet
format. What am I missing?
Thanks in Advances
Sridher Sharma
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2
3 13:45
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ How do I decrease the size of this file.
>
>
>
> Hi All,
>
>
>
> Kindly assist me how do I decrease the size of the attached file.
>
>
>
> Please let me know the procedure as well
ot;&Print"
>> next
>> end sub
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>> -Original Message- From: ameya
>> Sent: Tuesday, November 15, 2011 10:57 AM
>> To: MS EXCEL AND VBA MACROS
>> Subject: $$Excel-Mac
r each shItem in shItems
> shItem.invokeverb "&Print"
> next
> end sub
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
> -Original Message- From: ameya
> Sent: Tuesday, November 15, 2011 10:57 AM
> To: MS EXCEL AND VBA MACROS
> Subj
s
shItem.invokeverb "&Print"
next
end sub
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: ameya
Sent: Tuesday, November 15, 2011 10:57 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ How do i print all files [any file type
(.pdf,.doc,.t
Hello,
Could you please guide me on how do i print all files [any file type
(.pdf,.doc,.tiff)] in a folder using vba macros.
The folder path is pre-defined.
Thanks
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How do I transfer subtotal account Nr. along
with its balance?
Please attach a Sample File..
On Fri, Apr 29, 2011 at 2:56 PM, wrote:
> Hello Guys,
>
> Please, I have generated a subtotal spreadsheet with over 150 accounting
Please attach a Sample File..
On Fri, Apr 29, 2011 at 2:56 PM, wrote:
> Hello Guys,
>
> Please, I have generated a subtotal spreadsheet with over 150 accounting
> numbers with their balances that need to be transfered to another sheet to
> generate Trial Balance figures and Balance Sheet. Kindly
Hello Guys,
Please, I have generated a subtotal spreadsheet with over 150 accounting
numbers with their balances that need to be transfered to another sheet to
generate Trial Balance figures and Balance Sheet. Kindly tell me on how to do
it.
Thank you and Best Regards.
Reginald Ok
Sent from my
Hi All,
Have a look in the attached excel and you can find the solution.
The formula is given below for your reference. Adapt the Cell Range A3:A8
to your desired Range.
=IF(COUNTIF(A3:A8,LARGE(A3:A8,1))=COUNTIF(A3:A8,MODE(A3:A8)),LARGE(A3:A8,1),MODE(A3:A8))
*Suggestions For All*
*
*
1) Always
(KeyVals(R)) = MaxCnt Then
> If KeyVals(R) > MaxVal Then
> MaxVal = KeyVals(R)
> MaxCnt = Dict_Vals.Item(KeyVals(R))
> End If
> End If
> Next R
> MsgBox "VAL: " & MaxVal & Chr(13) & &
thanks Ashish, really appreciated.
>
>From: ashish koul
>To: excel-macros@googlegroups.com
>Sent: Thu, 6 January, 2011 11:50:17 AM
>Subject: Re: $$Excel-Macros$$ How do I find the highest of the most repeating
>values in a list of numbers ie. the max of the modes
>
>
End If
End If
Next R
MsgBox "VAL: " & MaxVal & Chr(13) & "Cnt: " & MaxCnt
End Sub
Paul
________
From: Kim
To: MS EXCEL AND VBA MACROS
Sent: Thu, January 6, 2011 1:16:15 AM
Subject: Re: $$Excel-Macros$$ How do I find the highest of the most repeati
Hi Kim,
If you Excel 2010, then the job would be much easier.
=Max(Mode.Mult(A1:A10))
This function is not available in Excel 2003.
Cheers
Valli
On Jan 6, 11:16 am, Kim wrote:
> Thanks so much Ashish but the problem is in the temporary column. I
> really need to do it in one cell only withou
Thanks so much Ashish but the problem is in the temporary column. I
really need to do it in one cell only without introducing any new
data.
Any idea on how I can achieve that?
Again, thanks for your help.
Kim
On Jan 6, 4:07 pm, ashish koul wrote:
> check the attachment see if it helps
>
>
>
-
> *From:* ashish koul
> *To:* excel-macros@googlegroups.com
> *Sent:* Thu, 6 January, 2011 10:37:35 AM
> *Subject:* Re: $$Excel-Macros$$ How do I find the highest of the most
> repeating values in a list of numbers ie. the max of the modes
>
> check the att
cel-macros@googlegroups.com
Sent: Thu, 6 January, 2011 10:37:35 AM
Subject: Re: $$Excel-Macros$$ How do I find the highest of the most repeating
values in a list of numbers ie. the max of the modes
check the attachment see if it helps
On Thu, Jan 6, 2011 at 6:17 AM, Kim wrote:
Hi,
>I h
check the attachment see if it helps
On Thu, Jan 6, 2011 at 6:17 AM, Kim wrote:
> Hi,
> I have a list of numbers and I need to find the highest of the most
> frequent occurrances.
>
> For example:
>
> List 1
> 1
> 3
> 3
> 4
> 4
>
> Should return the value 4 because its the highest of the most
>
Hi,
I have a list of numbers and I need to find the highest of the most
frequent occurrances.
For example:
List 1
1
3
3
4
4
Should return the value 4 because its the highest of the most
frequent
occurrances of any number.
List 2
1
3
3
3
4
4
Should return 3 because it's the most frequent occurr
How do I copy some cells(including formatting) and save as image file
using VBA?
Ultimately, I want to do that via COM or ActiveX server. Yet I think
VBA is the starting point.
So lets start from VBA.
How to do that in VBA?
I know how to open and close the Excel sheet.
But what's the command i
Hi Paddy,
Try this:
Sub MyFormula()
ActiveCell = "=Your Formula goes here"
End Sub
Regards - Dave
> Date: Thu, 21 Jan 2010 01:27:19 -0800
> Subject: $$Excel-Macros$$ How do i
> From: ryan0...@gmail.com
> To: excel-macros@googlegroups.com
>
> create a m
create a macro that means i can select any cell and when i execute the
macro the formula will appear in the cell selected rather than the
cell where it was created.
Thanks
Paddy
--
--
Some important links for excel
I have 3 different macros that work, and as opposed to giving them
each their own ctrl+ key combinations to run, I'd like to create a
kind of drop down msgbox or something like that that would list the
different options available to the user so that they can select the
appropriate macro to run.
I
I don't know what this type of chart this would be called and I was
not able to find it in the chart selections in Excel. But I want to
create a chart with the following criteria.
1. Percentages from 0% to 100% along the left side of the chart
2. A bar from 25% to 75%. This is the hit area.
3
Thanks
Mog
--
**
Omoghene Obahor
www.obahor.com
Cell: 214-493-7403
Fax: 866-338-1397
"As a Man Thinks So is He"
**
--~--~-~--~~~---~--~~
---
Hello, I am trying to create a macro. I would like for user to be
able to type in a search criteria and hit search button. I would like
the macro to search a range of cells for the input and return the row
number of the first search result. Any help will be greatly
appreciated...
I think my ma
29 matches
Mail list logo
