|
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:
|
31
|
136
|
392
|
|
Post:
|
65
|
298
|
958
|
|
|
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:
CountIF on two criteria in...
Published (2009-11-23 05:46:00)
=SUMPRODUCT(--(a1:a100<>"O"),--(B1:b100="CAT"),C1:C100) This will sum (total) every C value whose corresponding B value is CAT and corresponding A value is not O =SUMPRODUCT(--(a1:a100<>"O"),--(B1:b100="CAT")) This will count how many B values are CAT with corresponding A values that are not O For more details on SUMPRODUCT Bob...
user's latest post:
add info to column in...
Published (2009-11-25 14:56:00)
I would say the easiest way to copy down is to double-click the fill handle if there is data in the adjacent column...........which there is in this case. Gord Dibben MS Excel MVP On Wed, 25 Nov 2009 13:53:02 -0800, Max <demechanik@yahoo.com> wrote: >> How do i copy down? >Easiest way is to drag the cell's fill handle down, ie point the cursor at >the bottom right hand corner of the...
user's latest post:
add info to column in...
Published (2009-11-25 14:00:00)
Oops, clarification ... The cell's fill handle looks like a solid little black square When you point at it the cursor changes into a cross
user's latest post:
Obtaining the minimum of values...
Published (2009-11-18 09:00:00)
THANKS - As I said I am a bit of a "noddy" with Excel but certianly am finishing today wiser than I started this morning !!! Cheers, "Luke M" wrote: > Apologies, ignore that last formula. My brain had temporarily taken a leave > of absence... > -- > Best Regards, > > Luke M > *Remember to click "yes" if this post helped you!*...
user's latest post:
Obtaining the minimum of values...
Published (2009-11-18 07:57:00)
Apologies, ignore that last formula. My brain had temporarily taken a leave of absence...
user's latest post:
Mark Rows for scrolling in...
Published (2009-11-21 17:06:00)
This seems weird! I mark row 4 and row 1 and click on Freeze Panes. Rows 1-3 become frozen. There's also a black line below Row 6 that acts like another Freeze (Rows 4-6!) Does anybody have an answer to this? Thanks, Doug .
user's latest post:
data from many work books in...
Published (2009-11-23 05:10:00)
This can be done with VBA code (a macro). You haven't given enough information to provide a more detailed answer, but there is one command available that does allow you to browse and identify files to be worked with that will probably end up in the code: Application.GetOpenFilename will return a filename from a dialog box, and then the code can open that file and perform operations to copy information from that file into...
user's latest post:
Return Value in Cell Diagonally...
Published (2009-11-27 14:16:00)
See if this does what you want... ...........A..........B 1.......10........... 2...................... 3........5............ 4.......10.........X 5.......15.........Y 6....................Z A1 = lookup value =INDEX(B4:B6,MATCH(A1,A3:A5,0)) Result = Y
user's latest post:
Macros for template in...
Published (2009-11-21 10:35:00)
I have a Template for the 52 Weeks that i created if i want to change something in Template is it possible to have the 52 other sheets change as well through Macro,s if possible How
user's latest post:
Mark Rows for scrolling in...
Published (2009-11-21 18:16:00)
I'm not sure what mark means here, but freeze panes will freeze rows above the activecell and to the left of the activecell. So if you meant that you selected rows 1:4, then it would only matter what cell was the activecell. If that activecell is in row 4, then rows 1:3 would be frozen. (You can select a multicell range and tab through that selection to experiment.) And you may be seeing Window|Split. You only get one...
|
|
|
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 1 day, 13 hours ago (2009-11-27 14:16:00)
by T. Valko
See if this does what you want...
...........A..........B
1.......10...........
2......................
3........5............
4.......10.........X
5.......15.........Y
6....................Z
A1 = lookup value
=INDEX(B4:B6,MATCH(A1,A3:A5,0))
Result = Y
Started 1 day, 21 hours ago (2009-11-27 06:23:00)
by trip_to_tokyo
In EXCEL 2007 try this:-
Home group / Fornt - single left hand clik on the arrow in the lower right
hand corner / Format Cells should launch / Fill tab / Fill Effects . . . /
make your choice and hit OK / OK once more.
You should now have what you want.
Please hit Yes if my comments have helped.
Thanks...
Started 2 days, 3 hours ago (2009-11-26 23:31:00)
by Ed Ferrero
Hi Rohit,
> eg in cell A1, if i enter 1000,000 then the outcome should be 1,000.
Use a custom number format.
More number formats, then select Custom, then enter
#,##0,
including the trailing comma.
Ed Ferrero
www.edferrero.com
.
Started 3 days, 8 hours ago (2009-11-25 18:44:00)
by FSt1
hi
what have you tried so far???
seem like a simple add 45 days to previous date should do it.
with the data in c2, in e2, enter
=C2+45
regards
FSt1
"Nelson" wrote:
> I am trying to put together a simple three column spreadsheet. Column A is a
> tape number, column C is the date that the ...
Started 3 days, 13 hours ago (2009-11-25 13:26:00)
by John
HI
Lets assume your list is starting at A1, just type in B1 =A1&"@gmail.com"
and copy down to A1000.
HTH
John
"jj348206" <jj348206@discussions.microsoft.com> wrote in message
news:E7E6911F-BE61-422D-BBA7-BCFB83A66656@micros oft.com...
>I have a list of over 1000 names in my a column but need to add @gmail.com to
> the ...
Started 4 days, 21 hours ago (2009-11-24 06:24:00)
by Max
Try this relatively formulas play which should deliver the expected results ...
Assume target data is within rows 2 to 100 in col O in each of the 28 drug
sheets
In the summary sheet,
List the 28 actual sheetnames for the drugs into AD1:BE1
(A once-off effort, take care to ensure that there's no typos in the
listing. Case ...
Started 5 days, 21 hours ago (2009-11-23 05:46:00)
by Bernard Liengme
=SUMPRODUCT(--(a1:a100<>"O"),--(B1:b100="CAT"),C1: C100)
This will sum (total) every C value whose corresponding B value is CAT and
corresponding A value is not O
=SUMPRODUCT(--(a1:a100<>"O"),--(B1:b100="CAT"))
This will count how many B values are CAT with corresponding A values that
are not O
For more details ...
|
|
Hot threads for last week on Discussions in microsoft.public.excel.newusers:
Started 3 days, 13 hours ago (2009-11-25 13:26:00)
by John
HI
Lets assume your list is starting at A1, just type in B1 =A1&"@gmail.com"
and copy down to A1000.
HTH
John
"jj348206" <jj348206@discussions.microsoft.com> wrote in message
news:E7E6911F-BE61-422D-BBA7-BCFB83A66656@micros oft.com...
>I have a list of over 1000 names in my a column but need to add @gmail.com to
> the ...
Started 1 week, 1 day ago (2009-11-20 04:29:00)
by Ms-Exl-Learner
Just copy and paste the below formula in any of the cell
="store.murpheythejeweler.com/store/p/"&7062+RO W(A1)&"- Tungsten-Flat-8mm-Polished-Band.aspx"
Now place the cursor on the pasted cell and drag it for the remaining cells.
Or
Copy that cell and paste it for the remaining cells.
If this post helps, Click ...
Started 1 week, 1 day ago (2009-11-20 15:51:00)
by Dave Peterson
It sounds like you set the rows to repeat at top when the worksheet is printed.
If you want to always see rows 1:3 on the display, then...
Select A1 (just so it's visible)
select A4
Window|freeze panes
Everything above the activecell and to the left of the activecell will be
frozen.
Doug Mc...
Started 1 week ago (2009-11-21 11:46:00)
by Bernie Deitrick
Mike,
Sorry, that just isn't clear. Perhaps a formula
=SUM(A1: A37)/A1
where A1 to A37 have your number 997?
Bernie
"Mike" <Mike@discussions.microsoft.com> wrote in message
news:FCCAEB85-AF11-4227-9A2F-E194408F5C2F@micros oft.com...
>I am trying to sum up 37 cells to = 1 each for each cell ...
Started 1 week, 1 day ago (2009-11-20 06:24:00)
by Paul C
What this is picking up is the user name you have entered in excel
All you need to do is edit this.
In excel 2007 click the office button (that round window thing in the top
left), select Excel Options and at the bottom in the Personalize Excel
section enter your name in the User name Field.
In earlier version you ...
Started 1 week, 1 day ago (2009-11-20 11:36:00)
by Gord Dibben
Select the photo files from your picure folder by SHIFT or CTRL + click and
"Copy"
Open a Word document and Edit>Paste.
Gord Dibben MS Excel MVP
On Fri, 20 Nov 2009 08:33:02 -0800, Becky <Becky@discussions.microsoft.com>
wrote:
> I am in need of some help I am trying to export some photos from my ...
Started 1 week ago (2009-11-21 12:11:00)
by Gord Dibben
Best to stick with your original posting Mike.
See my reply there.
Gord
On Sat, 21 Nov 2009 10:36:01 -0800, Mike <Mike@discussions.microsoft.com>
wrote:
> I have a Template for the 52 Weeks that i created if i want to change
>something in Template is it possible to have the 52 other sheets change as...
Started 1 week ago (2009-11-21 12:21:00)
by Gord Dibben
I see nothing specific at the Office Template Gallery but a 'net search for
"coupon database excel" turned up a few.
Download a sample workbook from here.
http://projects.newsobserver.com/tags/coupon_updat e
Gord Dibben MS Excel MVP
On Sat, 21 Nov 2009 11:26:01 -0800, katinsunlakes
<...
Started 1 week ago (2009-11-21 18:16:00)
by Dave Peterson
I'm not sure what mark means here, but freeze panes will freeze rows above the
activecell and to the left of the activecell.
So if you meant that you selected rows 1:4, then it would only matter what cell
was the activecell. If that activecell is in row 4, then rows 1:3 would be
frozen.
(You can select a multicell range ...
Started 1 week ago (2009-11-21 20:41:00)
by T. Valko
If this data is imported from another application is the date/time stamp a
true Excel date/time?
If C2 is a date/time stamp what is the result of this formula:
=ISNUMBER(C2)
Can you post a small example of your data with the expected result? Don't
really need the Device/SubDevice data. Just the date/time and the X/Y...
|
|
Size: 589 bytes
