|
More site info...
New Users to Excel | Forum profile
|
|
Forum profile page for New Users to Excel on http://excelbanter.com.
This report page is the aggregated overview from a single forum: New Users to Excel, located on the Message Board at http://excelbanter.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "New Users to Excel" on the Message Board at http://excelbanter.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on New Users to Excel:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
87
|
261
|
659
|
|
Post:
|
207
|
599
|
1,660
|
|
|
New Users to Excel Posting activity graph:
|
Top authors during last week:
user's latest post:
How move arrow keys from cell to...
Published (2009-11-13 18:19:00)
Tap Scroll Lock key once. Gord Dibben MS Excel MVP On Fri, 13 Nov 2009 08:58:01 -0800, Arrow keys: cell to cell; not entire row <Arrow keys: cell to cell; not entire
user's latest post:
Excluding cells from average on...
Published (2009-11-10 20:24:00)
Except that you would include all cells in the range as opposed to F10, F13, F16, F19, F22, F26 and F30 only -- Regards, Peo Sjoblom "Luke M" > wrote in message ... > We can use an array* formula to exclude errors. > > =AVERAGE(IF(ISNUMBER(F10:F30),F10:F30)) > > If you need additional conditions, such as greater than 0, we can add an > additional IF check > >...
user's latest post:
Excluding cells from average on...
Published (2009-11-10 19:56:00)
We can use an array* formula to exclude errors. =AVERAGE(IF(ISNUMBER(F10:F30),F10:F30)) If you need additional conditions, such as greater than 0, we can add an additional IF check =AVERAGE(IF(ISNUMBER(F10:F30),IF(F10:F30>0,F10:F30 ))) *Array formulas must be confirmed using Ctrl+Shift+Enter, not just Enter. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Beth Gaines"...
user's latest post:
Excluding cells from average on...
Published (2009-11-10 19:43:00)
Hi Peo! They may not have seen your original reply. The ngs are broken and have been for about a week. If the question is posted through the MS web interface, which it was, and you reply to that question using an application other than the web interface, which you are doing, then your reply doesn't get posted. MS does know about this. The OP won't see my reply either until the problem is corrected. -- Biff Microsoft Excel MVP...
user's latest post:
Brain fart in simple subtraction
Published (2009-11-13 18:22:00)
Hi, use c3=$b$2-b3 "Fritz W" wrote: > How do I fix a cell that is always subtracted from? > > I want to have b2 a fixed value > then c3=b2-b3 > d3=b2-d3 > e3=b2-e3 > > If I just pull cell down to copy I get > d3=b3-b4 > e3=b4-b5 > > Brain fart I am sure > > > . >
user's latest post:
Create a 3rd sheet containing...
Published (2009-11-13 21:38:00)
If desired, send your file to my address below. I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software
user's latest post:
can I put an email address in a...
Published (2009-11-05 19:20:00)
See Ron de Bruin's site Example Code for sending mail from Excel http://www.rondebruin.nl/sendmail.htm -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Roger" > wrote in message ... > I have Excel 2002. I have a spreadsheet that I need to convert to csv > format and email each week to another person. My macro does a save as to > convert it from...
user's latest post:
Average Function
Published (2009-11-06 17:26:00)
Hi Everyone, I am using Excel 2003. I understand there is probably a very sophisticated way to get what I want but I need to learn the simple way first. I have a data sheet named "MICU". I inserted another sheet in the workbook called "Stats". I want to break down the data by month on my new Stats sheet. The MICU sheet has many columns of info. The 2 I think I need to use is a column for start date...
user's latest post:
Daily Macro for 31 days
Published (2009-11-13 01:30:00)
I am having problems with the Macro below. The 6th line is off somehow or 6,7,8,9, being off. Would appreciate any help on the line or any other problem you see with the Macro. Sub BuildingSalvage() 'Assuming row Corresponds to date: 'Sub MyMacro() 'Dim x As Integer 'Determine what day it is x = Format(Date, "d") Cells(x, "G").Formula = Date Cells(x, "J").FormulaR1C1 =...
user's latest post:
Can I calculate quartiles in an...
Published (2009-11-04 02:06:00)
Hi Graeme, Unfortunately Quartile is not a summary option for pivot tables, nor is median. However there is a worksheet function: =QUARTILE(A:A,2) which is the same as =MEDIAN(A:A) Hope this helps. PShepard "Graeme Williams" wrote: > When I build a pivot table, I can use the sum, average, minimum or maximum of > the data values. Can I use quartiles as well?
|
|
|
|
Latest active threads on New Users to Excel::
Started 2 days, 3 hours ago (2009-11-13 11:49:00)
by Nicholas Perkins
Hi Pete,
What you would be best to use is an array formula. When you enter an
array formula, you press Ctrl+Shift+Enter instead of just Enter. (Some
people call them CSE formulas because of this key combo).
I won't go too deep into specifics of how they work as there are much
better people and websites to check out.
The formula you would enter is:
=MIN(IF($H$2:$H$5>H2,$H$2:$H$5...
Started 1 day, 14 hours ago (2009-11-14 00:10:00)
by Gord Dibben
You want to get rid of all the "pipes" that de-limiting the text?
Pipe character is found above Enter key Shift\
Edit>Replace
What: Alt + 0124 ( enter digits via Numpad)
With: nothing
Gord Dibben MS Excel MVP
On Fri, 13 Nov 2009 14:35:54 -0800, wjr > wrote:
>Received an excel file which needs to be exported into a plain ascii csv
>file. It appears that the ...
Started 1 day, 18 hours ago (2009-11-13 21:03:00)
by Roadtripper902902V3V
By the way, I am a REAL BIG beginner with excel, so please provide some
hand-holding in the instructions. 8-) thank you.
Started 1 day, 20 hours ago (2009-11-13 18:18:00)
by Gord Dibben
=$B$2-B3
See help on absolute and relative references.
BTW your examples show you are copying across, not down
C3, D3 and E3 are in same row.
Gord Dibben MS Excel MVP
On Fri, 13 Nov 2009 11:18:39 -0500, "Fritz W" > wrote:
>How do I fix a cell that is always subtracted from?
>
>I want to have b2 a fixed value
>then c3=b2-b3
> d3=b2-d3
> e3=b2-e3
>
>If...
Started 1 day, 20 hours ago (2009-11-13 18:19:00)
by Gord Dibben
Tap Scroll Lock key once.
Gord Dibben MS Excel MVP
On Fri, 13 Nov 2009 08:58:01 -0800, Arrow keys: cell to cell; not entire row
<Arrow keys: cell to cell; not entire
Started 1 day, 23 hours ago (2009-11-13 15:31:00)
by RonaldoOneNil
Click the grey blank square to the left of column A and just above row 1.
Click copy, go to your other sheets and either clcik the gery square or cell
A1 and click paste.
"KRK" wrote:
> hello,
>
> I have a large (26 * 750 cells) complex sheet which I want to copy to
> another sheet in the same workbook. I want to copy everything, formats,
> values, formulae, fonts, and column &...
Started 2 days, 12 hours ago (2009-11-13 02:16:00)
by Per Jessen[_2_]
Hi
Range("K") is not a valid cell reference.
Not sure if you want to paste in row x, but maybe this:
Range("K" & x).select
Or better:
Range("F32").Copy
Range("K" & x).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks_:=False, Transpose:=False
Hopes this helps.
....
Per
On 13 Nov., 01:30, paintbrush <Eastern Ks.com> wrote:
> I am having problems with ...
Started 1 week, 1 day ago (2009-11-07 15:03:00)
by Bernie Deitrick
Steve,
Explicitly check for empty cells ("")
=IF(ROWS($2:2)>COUNT(OFFSET(' Raw Data'!$J:$J,,MATCH(WSN,'Raw
Data'!$K$2:$V$2,0))),"",IF(INDEX('Raw Data'!E:E,SMALL(OFFSET('Raw
Data'!$J:$J,,MATCH(WSN,'Raw
Data'!$K$2:$V$2,0)),ROWS($2:2)))="","",INDEX('Raw
Data'!E:E,SMALL(OFFSET('Raw Data'!$J:$J,,MATCH(WSN,'Raw
Data'!$K$2:$V$2,0)),ROWS($2:2)))))
HTH,
Bernie
MS Excel MVP
"...
Started 5 days, 8 hours ago (2009-11-10 06:22:00)
by sammy external usenet poster
How can I have the option of "None" rather than picking a date in the
Date/Time Picker of a dropdown Calendar using Excel 2003
Started 2 days, 2 hours ago (2009-11-13 12:05:00)
by Nicholas Perkins[_2_]
Hi Brunzeg,
This would require the use of a user-defined function. I'm happy to help you
with this.
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after ...
|
|
Hot threads for last week on New Users to Excel::
Started 4 days, 20 hours ago (2009-11-10 18:47:00)
by Peo Sjoblom[_3_]
I posted this to your original post but you chose to got with another
person's solution that doesn't work
=SUM(F10,F13,F16,F19,F22,F26,F30)/SUMPRODUCT(COUN TIF(INDIRECT({"F10","F13","F16","F1 9","F22","F26","F30"}),">0"))
this will exclude all values zero or less since I assume they cannot be
negative.
However now you seem to have changed the criteria and are using formulas
...
Started 2 weeks, 3 days ago (2009-10-28 16:27:00)
by Peo Sjoblom[_3_]
At the bottom there is a formula solution turning on iterations
http://www.mcgimpsey.com/excel/accumulator.html
--
Regards,
Peo Sjoblom
"Brad Grow" <Brad
Started 2 days, 3 hours ago (2009-11-13 11:49:00)
by Nicholas Perkins
Hi Pete,
What you would be best to use is an array formula. When you enter an
array formula, you press Ctrl+Shift+Enter instead of just Enter. (Some
people call them CSE formulas because of this key combo).
I won't go too deep into specifics of how they work as there are much
better people and websites to check out.
The formula you would enter is:
=MIN(IF($H$2:$H$5>H2,$H$2:$H$5...
Started 5 days, 15 hours ago (2009-11-10 00:01:00)
by bhchen external usenet poster
Dear all:
I'm a college teacher and have been using Excel to post students' various
quiz/exam grades on the web. However, starting from this semester, we were
asked to respect students' privacy of NOT sending/posting the grades of the
entire class anymore.
Since I usually have several hundreds of students' grades to take care of
each semester, it really becomes a burden if I had to...
Started 1 week, 1 day ago (2009-11-06 23:59:00)
by Peo Sjoblom[_3_]
How many cells are we talking about? And is there any system to it? Your
cells seem to be every third cell until after F22, after that here is one
cell gap extra. If indeed it is every third cell you can use
=AVERAGE(IF((MOD(F10:F30,3)=1)*(F10:F30>0),F10:F3 0 ))
entered with ctrl + shift & enter
If your cells are like what you posted, try
=SUM(F10, F13,F16,F19,F22,F26,F30)/...
Started 1 week, 1 day ago (2009-11-06 18:23:00)
by Peo Sjoblom[_3_]
Hi Linda,
First of all, June-08 is that supposed to be June 2008? If so make sure by
selecting a cell with this value and look in the formula bar and make sure
it doesn't say 6/8/2009, that is what my Excel does if I type June-08, Excel
thinks you mean June 8th current year. Anyway it is very easy to get average
for particular months and years,
=AVERAGE(IF((MONTH(A3:A21)=6)*(...
Started 1 week, 1 day ago (2009-11-07 14:43:00)
by Bernie Deitrick
David,
Save the workbook as a template, and the user will be prompted for a name
when they use save or save as, unless they specifically save the file as a
template as well.
HTH,
Bernie
MS Excel MVP
"David128" > wrote in message
...
>i have a report that others use. the main bady of the report is protected
> against change. but i need to disable the save so they only use ...
Started 3 days ago (2009-11-12 14:08:00)
by Eduardo
Hi,
Let's say you have the name in cell A2, the price in B2 and you want the
price to be multiplied by a constant in C2. First you need to create a table
with the names and the constant let's say in sheet2, then hide the sheet and
protect your workbook so nobody can see it and use the formula as follow in C2
=B2*SUMPRODUCT((A2=Sheet2!A:A)*Sheet2!B:B)
if this helps please click yes ...
Started 1 day, 23 hours ago (2009-11-13 15:31:00)
by RonaldoOneNil
Click the grey blank square to the left of column A and just above row 1.
Click copy, go to your other sheets and either clcik the gery square or cell
A1 and click paste.
"KRK" wrote:
> hello,
>
> I have a large (26 * 750 cells) complex sheet which I want to copy to
> another sheet in the same workbook. I want to copy everything, formats,
> values, formulae, fonts, and column &...
Started 1 day, 14 hours ago (2009-11-14 00:10:00)
by Gord Dibben
You want to get rid of all the "pipes" that de-limiting the text?
Pipe character is found above Enter key Shift\
Edit>Replace
What: Alt + 0124 ( enter digits via Numpad)
With: nothing
Gord Dibben MS Excel MVP
On Fri, 13 Nov 2009 14:35:54 -0800, wjr > wrote:
>Received an excel file which needs to be exported into a plain ascii csv
>file. It appears that the ...
|
|
Size: 3,689 bytes
