|
More site info...
microsoft.public.excel.newusers | Forum profile
|
|
Forum profile page for microsoft.public.excel.newusers on http://www.microsoft.com/communities/newsgroups....
This report page is the aggregated overview from a single forum: microsoft.public.excel.newusers, located on the Message Board at http://www.microsoft.com/communities/newsgroups....
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 "microsoft.public.excel.newusers" on the Message Board at http://www.microsoft.com/communities/newsgroups... 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 microsoft.public.excel.newusers:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
41
|
146
|
417
|
|
Post:
|
93
|
330
|
1,063
|
|
|
microsoft.public.excel.newusers Posting activity graph:
|
Top authors during last week:
user's latest post:
Excluding cells from average on...
Published (2009-11-10 10:55: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...
user's latest post:
Create a 3rd sheet containing...
Published (2009-11-13 13:11: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.
user's latest post:
auto sum will not work in...
Published (2009-11-10 22:11:00)
Sounds like the cell if formatted as TEXT. Change the cells format to GENERAL then hit function key F2 then hit Enter. -- Biff Microsoft Excel MVP "Soshagayle" <Soshagayle@discussions.microsoft.com> wrote in message news:C059BF57-C602-467E-B480-620A84DBCF15@microsoft.com... >I am new.. I did the tutorials.. I have a new spread sheet and I can not >get > the auto sum to work. I...
user's latest post:
Brain fart in simple subtraction...
Published (2009-11-13 09:21: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:
Export CSV dash is \226...
Published (2009-11-13 18:06:00)
I sure missed this one! I don't speak Octal<g> Gord On Fri, 13 Nov 2009 15:27:45 -0800, wjr <usenet@gomonarch.com> wrote: >Gord Dibben wrote: >> You want to get rid of all the "pipes" that de-limiting the text? >> >> Pipe character is found above Enter key Shift\ >> >> Edit>Replace >>...
user's latest post:
Modify range of cells at once......
Published (2009-11-05 20:51:00)
hi no, not that i know of. excel need a way to know what to add( or mutiply, subtract, divide) to all the cells. and in my last post, i seem to have forgotten to mention to high light all the cells first. then do the copy/paste special. the operation will only effect high lighted cells. Regards FSt1 "Andrey Kazak" wrote: > Yes. This is exacly what I want. But is there any way to do it without >...
user's latest post:
Excluding cells from average on...
Published (2009-11-10 19:19: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" <LukeM@discussions.microsoft.com> wrote in message news:6D582243-BB91-4F34-B748-7A180553C546@microsoft.com... > We can use an array* formula to exclude errors. > > =AVERAGE(IF(ISNUMBER(F10:F30),F10:F30)) > > If you need...
user's latest post:
Excel Question in...
Published (2009-11-12 10:02:00)
1) Copy the cell with the formula in it showing the value you want 2) Switch to the other sheet and select the target cell (do not press ENTER on it) 3) Click on EDIT > PASTE SPECIAL > Values That should paste in just the value of the formula, not the formula itself. Does that help? -- "Actually, I *am* a rocket scientist." -- JB (www.MadRocketScientist.com) Your feedback is appreciated, click YES if...
user's latest post:
Daily Macro for 31 days in...
Published (2009-11-12 16:29: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,...
user's latest post:
Create a 3rd sheet containing...
Published (2009-11-13 12:13:00)
Or if it would be easier to have all the info on one sheet, I could put info on Sheet 2 into some columns on Sheet 1. And I do not mind having the Sheet3 data (the "pairs") onto some colum(s) on sheet 1, as well.
|
|
|
|
Latest active threads on microsoft.public.excel.newusers::
Started 1 day, 2 hours ago (2009-11-14 11:16:00)
by Bernie Deitrick
Gary,
Generally, if you insert rows into a table, you will mess up the formula
references. You can easily solve this by copying down the formula for that
column from a row that is above your insertion point, all the way down to
the end of your table.
One way around this is to not use formulas in your table, but to use ...
Started 1 day, 1 hour ago (2009-11-14 12:31:00)
by Dave Peterson
The icon has a macro in a different workbook assigned to it.
I'm not sure where this icon is or how you made it, but if modified the a
toolbar, you can:
Tools|Customize (just to see that dialog)
rightclick on the icon
Choose Assign macro
and assign the macro in the currently open version of personal.xls....
Started 2 days, 10 hours ago (2009-11-13 03:00: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....
Started 1 day, 21 hours ago (2009-11-13 15:46: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 <usenet@gomonarch.com> wrote:...
Started 2 days, 1 hour ago (2009-11-13 12:02: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 2 days, 3 hours ago (2009-11-13 09:56: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 row@discussions.microsoft.com> wrote:
>Arrow keys move entire column or row. I want arrow keys to move from cell to
>cell..
....
Started 2 days, 4 hours ago (2009-11-13 09:21:00)
by Eduardo
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 ...
Started 2 days, 7 hours ago (2009-11-13 06:30: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 ...
Started 2 days, 19 hours ago (2009-11-12 17:56:00)
by Per Jessen
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.
.......
Started 2 days, 14 hours ago (2009-11-12 23:41:00)
by Ron@Buy
KFH
Version 9.5 will work with Excel 2007 & Vista
No, Excel does not have anything to compare with Synkronizer!!
"KFH" wrote:
> I used a spreadsheet comparison tool (add in) Synkronizer with MS Excel 2003.
> Does Synkronizer work with MS Excel 2007? Does MS Excel 2007 have a
> built-in data comparison tool?...
|
|
Hot threads for last week on microsoft.public.excel.newusers::
Started 2 days, 10 hours ago (2009-11-13 03:00: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....
Started 5 days, 2 hours ago (2009-11-10 10:43:00)
by Peo Sjoblom
Started 2 days, 7 hours ago (2009-11-13 06:30: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 ...
Started 1 day, 2 hours ago (2009-11-14 11:16:00)
by Bernie Deitrick
Gary,
Generally, if you insert rows into a table, you will mess up the formula
references. You can easily solve this by copying down the formula for that
column from a row that is above your insertion point, all the way down to
the end of your table.
One way around this is to not use formulas in your table, but to use ...
Started 5 days, 2 hours ago (2009-11-10 10:55:00)
by Luke M
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:F 30)))
*Array formulas must be confirmed using Ctrl+Shift+Enter, not just Enter....
Started 3 days, 8 hours ago (2009-11-12 05:07: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...
Started 2 days, 1 hour ago (2009-11-13 12:02: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, 21 hours ago (2009-11-13 15:46: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 <usenet@gomonarch.com> wrote:...
Started 4 days, 15 hours ago (2009-11-10 22:11:00)
by T. Valko
Sounds like the cell if formatted as TEXT. Change the cells format to
GENERAL then hit function key F2 then hit Enter.
--
Biff
Microsoft Excel MVP
"Soshagayle" <Soshagayle@discussions.microsoft.com> wrote in message
news:C059BF57-C602-467E-B480-620A84DBCF15@micros oft.com...
>I am new.. I did the ...
Started 3 days, 3 hours ago (2009-11-12 10:02:00)
by JBeaucaire
1) Copy the cell with the formula in it showing the value you want
2) Switch to the other sheet and select the target cell (do not press ENTER
on it)
3) Click on EDIT > PASTE SPECIAL > Values
That should paste in just the value of the formula, not the formula itself.
Does that help?
--
"Actually, I *am* a rocket...
|
|