|
More site info...
Discussions in microsoft.public.excel.newusers - www.microsoft.com/communities/newsgroups... | Site profile
|
|
Site profile page for http://www.microsoft.com/communities/newsgroups....
This report page has aggregated and summarized the online discussions from the Message Board located at http://www.microsoft.com/communities/newsgroups....
This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional site profile information for http://www.microsoft.com/communities/newsgroups... is also shown in the following divisions:
1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) 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 site's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity table on Discussions in microsoft.public.excel.newusers:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
39
|
139
|
415
|
|
Post:
|
76
|
298
|
1,048
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for Discussions in microsoft.public.excel.newusers (http://www.microsoft.com/communities/newsgroups...)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
Discussions in microsoft.public.excel.newusers posting activity graph:
|
|
http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.excel.newusers Alexa graph:
|
Top authors on Discussions in microsoft.public.excel.newusers 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:
fitting in graphic to footer in...
Published (2009-11-03 07:13:00)
I'm not sure why you think you need a graphic to do this. You can adjust the size and style of the font in an Excel header/footer when making it, so that should make this an easy thing to do. Choose File --> Page Setup and select the Header/Footer Tab. Then choose Custom Footer. click in the center section and then click on the [A] icon above the data entry area. That will allow you to define the font style and size....
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:
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:
automatically put date and time...
Published (2009-11-03 16:49:00)
Hi Vivek, Excel 2007, from the help menu: You can View the history worksheet by going to the Review tab, in the Changes group, click Track Changes, and then click Highlight Changes. Under Highlight which changes, select the When check box and then, in the When list, click All. Clear the Who and Where check boxes. Select the List changes on a new sheet check box. Click OK. Hope this helps. PShepard "Vivek" wrote:...
user's latest post:
Find and IF statement in...
Published (2009-11-03 14:28:00)
Yes, I need more conditions. "cm" wrote: > you can nest up to 7 if statements; if you need more conditions, there will > need to be a different solution. > -- > hope to help, > cm > > > "Atif" wrote: > > > Can we add more conditions? > > > > "cm" wrote: > >...
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:
Find and IF statement in...
Published (2009-11-03 14:25:00)
you can nest up to 7 if statements; if you need more conditions, there will need to be a different solution. -- hope to help, cm "Atif" wrote: > Can we add more conditions? > > "cm" wrote: > > > replace your formula with this one: > > > >...
user's latest post:
using percentages in...
Published (2009-11-04 05:13:00)
I am using percentages to calculate a score of 1 - 5 which updates a dashboard. I have an average of multiple scores adding up to 100% or less. I would like to make an input of 0 to remove this column from the average of other scores. example " =average(i7:i16)" if "i8" input is "0", remove "i8" from average "=average(i7,i9:i16)"... Any...
user's latest post:
Modify range of cells at once......
Published (2009-11-05 20:04:00)
Yes. This is exacly what I want. But is there any way to do it without utilizing of a spare cell? "FSt1" wrote: > hi > not sure if i understand but if you want to add 2 to a number of cells in a > range (or mutiply, subtract, divide), enter a 2 (or whatever number you need) > into a cell off to the side and copy it. then use pasted special>Add (or > mutiply, subtract,...
|
|
|
Top 10 active forums on Discussions in microsoft.public.excel.newusers during last week:
|
|
Top 10 forums on Discussions in microsoft.public.excel.newusers:
|
|
|
|
Latest active threads on Discussions in microsoft.public.excel.newusers:
Started 19 hours, 38 minutes ago (2009-11-11 06:06:00)
by Don Guillett
You could use a lookup table and VLookup formulas or a macro. More info OR
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 ...
Started 1 day, 3 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 1 day, 15 hours ago (2009-11-10 10:43:00)
by Peo Sjoblom
Started 1 day, 14 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 1 day, 16 hours ago (2009-11-10 09:18:00)
by Gary''s Student
Sub MyMacro()
Dim x As Integer
'Determine what day it is
x = Format(Date, " d")
Cells(x, "G").Formula = Date
Cells(x, "J").FormulaR1C1 = "=RC[-1]*7"
Cells(x, "K").FormulaR1C1 = "=R[7]C[-5]"
Cells(x, "K") = Cells(x, "K").Value
Range("E1:E31").ClearContents
End Sub
--
Gary''s ...
Started 1 day, 17 hours ago (2009-11-10 08:18:00)
by Niek Otten
In D1:
=C1*25.378692%
In E1:
=C1-D1
Copy down to fill 47 rows
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Maggie" <Maggie@discussions.microsoft.com> wrote in message
news:7F25BFE2-F1D1-4CE5-85D3-0038AEE967BF@microso ft.com...
>I have a spread sheet of 47 rows. I need to multiply each row in column C
>by...
Started 5 days, 2 hours ago (2009-11-06 23:28:00)
by JBeaucaire
Try this:
=SUM(F10,F13,F16,F19,F22,F26,F30) / COUNTA(F10,F13,F16,F19,F22,F26,F30)
--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)
Your feedback is appreciated, click YES if this post helped you.
"Beth Gaines" wrote:
> I want to average a group of percentages but want...
|
|
Hot threads for last week on Discussions in microsoft.public.excel.newusers:
Started 1 week, 1 day ago (2009-11-03 13:40:00)
by cm
replace your formula with this one:
=IF(ISERROR(SEARCH("BCOT",A2))=TRUE,IF(ISERROR( SEARCH("BCPN",A2))=TRUE,"","BCPN"),"BCOT")
--
hope to help,
cm
"Atif" wrote:
> Hi:
>
> I am using following formula to search a string and display in target cell,
> if first IF condition returns TRUE it displays ...
Started 1 day, 15 hours ago (2009-11-10 10:43:00)
by Peo Sjoblom
Started 6 days, 7 hours ago (2009-11-05 18:24:00)
by FSt1
hi
not sure if i understand but if you want to add 2 to a number of cells in a
range (or mutiply, subtract, divide), enter a 2 (or whatever number you need)
into a cell off to the side and copy it. then use pasted special>Add (or
mutiply, subtract, divide).
regards
FSt1
"Andrey Kazak" wrote:
> ...
Started 1 day, 14 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 1 week, 1 day ago (2009-11-03 16:15:00)
by pshepard
Hi Louise,
First select the SmartArt object then right click, select Hyperlilnk to
create a link from the SmartArt.
To change the color of the worksheet:
select all cells [CTRL] + [A]
then right click
select Format Cells
select the Fill tab
then select a color.
Hope this helps.
...
Started 1 week ago (2009-11-04 12:55:00)
by teylyn
Hi, you can try
=VLOOKUP(ROUNDUP(10.06%,1),A1:D2,4,FALSE)
This will round up the value to the nearest digit, so it is 10.1. Vlookup
then finds the exact match in your lookup table due to the FALSE operator.
does that help?
"hmz" wrote:
> I have a simple question, hopefullly.
>
> I ...
Started 6 days, 1 hour ago (2009-11-06 00:11:00)
by Ms-Exl-Learner
Use ISBLANK Function In your formula to get out of this issue.
Assume that you have the data like this
A1 to A3
ABC
XYZ
BKL
B1 to B3
44
68
Here B2 cell is blank.
If you apply the below formula in C1 cell and copy and paste the c1 cell
formula upto C3 you will notice ...
Started 1 day, 3 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 1 week, 1 day ago (2009-11-03 07:13:00)
by JLatham
I'm not sure why you think you need a graphic to do this.
You can adjust the size and style of the font in an Excel header/footer when
making it, so that should make this an easy thing to do.
Choose File --> Page Setup and select the Header/Footer Tab. Then choose
Custom Footer. click in the center section and then click on ...
Started 1 week, 1 day ago (2009-11-03 21:18:00)
by FSt1
hi
since you are moving down column AG, i'm assuming that column AG is empty.
try this...
Sub copyit()
Dim r As Range
Dim ro As Range
Set r = [E7]
Set ro = [AG65000].End(xlUp).Offset(1, 0)
ro.Value = r.Value
End Sub
this would go into a standard module.
Regards
FSt1
" John Calder...
|
|
Size: 1,244 bytes
