Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

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.

Title: Discussions in microsoft.public.excel.newusers - http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.excel.newusers Discussions in microsoft.public.excel.newusers
Url: http://www.microsoft.com/communities/newsgroups...
Users activity: 2 posts per thread
site activity: 31 active thread during last week
Site rank: 16,181 (go to rank page)
Domain info for: microsoft.com
 

Posting activity table on Discussions in microsoft.public.excel.newusers:

  Week Month 3 Months
Threads: 31 136 392
Post: 65 298 958
 

Authority Badge:

Discussions in microsoft.public.excel.newusers | Forum Authority Badge

Discussions in microsoft.public.excel.newusers posting activity graph:

Posts by:  day  week  month 
 

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:

Name
Posts
Bernard Liengme
4
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...
Gord Dibben
4
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...
Max
4
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
Caithness Girl
3
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!*...
Luke M
3
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...
Doug Mc
3
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 .  
JLatham
3
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...
T. Valko
3
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
Mike
2
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  
Dave Peterson
2
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:

microsoft.public.excel.newusers - 53 new posts microsoft.public.excel.newusers - forum profile
 

Top 10 forums on Discussions in microsoft.public.excel.newusers:

microsoft.public.excel.newusers - 10,038 posts microsoft.public.excel.newusers - forum profile

Latest active threads on Discussions in microsoft.public.excel.newusers:

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
Forum:  microsoft.public.excel.newusers microsoft.public.excel.newusers - forum profile
Thread:  Show this thread (2 posts) Thread info: Return Value in Cell Diagonally opposite in microsoft.public.excel.newusers Size: 589 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Return Value in Cell Diagonally opposite in microsoft.public.excel.newusers :: microsoft.public.excel.newusers :: Discussions in microsoft.public.excel.newusers"
Discussions in microsoft.public.excel.newusers
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...
Forum:  microsoft.public.excel.newusers microsoft.public.excel.newusers - forum profile
Thread:  Show this thread (2 posts) Thread info: Shadow Effect in microsoft.public.excel.newusers Size: 1,137 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Shadow Effect in microsoft.public.excel.newusers :: microsoft.public.excel.newusers :: Discussions in microsoft.public.excel.newusers"
Discussions in microsoft.public.excel.newusers
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 .
Forum:  microsoft.public.excel.newusers microsoft.public.excel.newusers - forum profile
Thread:  Show this thread (2 posts) Thread info: automate cell to divide by 1000 in microsoft.public.excel.newusers Size: 658 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: automate cell to divide by 1000 in microsoft.public.excel.newusers :: microsoft.public.excel.newusers :: Discussions in microsoft.public.excel.newusers"
Discussions in microsoft.public.excel.newusers
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 ...
Forum:  microsoft.public.excel.newusers microsoft.public.excel.newusers - forum profile
Thread:  Show this thread (2 posts) Thread info: Buchup tape rotation in microsoft.public.excel.newusers Size: 1,404 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Buchup tape rotation in microsoft.public.excel.newusers :: microsoft.public.excel.newusers :: Discussions in microsoft.public.excel.newusers"
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 ...
Forum:  microsoft.public.excel.newusers microsoft.public.excel.newusers - forum profile
Thread:  Show this thread (7 posts) Thread info: add info to column in microsoft.public.excel.newusers Size: 822 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: add info to column in microsoft.public.excel.newusers :: microsoft.public.excel.newusers :: Discussions in microsoft.public.excel.newusers"
Discussions in microsoft.public.excel.newusers
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 ...
Forum:  microsoft.public.excel.newusers microsoft.public.excel.newusers - forum profile
Thread:  Show this thread (2 posts) Thread info: Collating entries from multiple sheets in microsoft.public.excel.newusers Size: 1,170 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Collating entries from multiple sheets in microsoft.public.excel.newusers :: microsoft.public.excel.newusers :: Discussions in microsoft.public.excel.newusers"
Discussions in microsoft.public.excel.newusers
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 ...
Forum:  microsoft.public.excel.newusers microsoft.public.excel.newusers - forum profile
Thread:  Show this thread (2 posts) Thread info: CountIF on two criteria in microsoft.public.excel.newusers Size: 1,258 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: CountIF on two criteria in microsoft.public.excel.newusers :: microsoft.public.excel.newusers :: Discussions in microsoft.public.excel.newusers"
 

Hot threads for last week on Discussions in microsoft.public.excel.newusers:

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 ...
Forum:  microsoft.public.excel.newusers microsoft.public.excel.newusers - forum profile
Thread:  Show this thread (7 posts) Thread info: add info to column in microsoft.public.excel.newusers Size: 822 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: add info to column in microsoft.public.excel.newusers :: microsoft.public.excel.newusers :: Discussions in microsoft.public.excel.newusers"
microsoft.public.excel.newusers
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 ...
Forum:  microsoft.public.excel.newusers microsoft.public.excel.newusers - forum profile
Thread:  Show this thread (3 posts) Thread info: increase number in cell by one continuously... in
microsoft.public.excel.newusers Size: 2,553 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: increase number in cell by one continuously... in
microsoft.public.excel.newusers :: microsoft.public.excel.newusers :: Discussions in microsoft.public.excel.newusers"
microsoft.public.excel.newusers
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...
Forum:  microsoft.public.excel.newusers microsoft.public.excel.newusers - forum profile
Thread:  Show this thread (3 posts) Thread info: Show top three rows when scrolling in microsoft.public.excel.newusers Size: 909 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Show top three rows when scrolling in microsoft.public.excel.newusers :: microsoft.public.excel.newusers :: Discussions in microsoft.public.excel.newusers"
microsoft.public.excel.newusers
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 ...
Forum:  microsoft.public.excel.newusers microsoft.public.excel.newusers - forum profile
Thread:  Show this thread (3 posts) Thread info: sum to = 1 for each cell in microsoft.public.excel.newusers Size: 953 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: sum to = 1 for each cell in microsoft.public.excel.newusers :: microsoft.public.excel.newusers :: Discussions in microsoft.public.excel.newusers"
microsoft.public.excel.newusers
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 ...
Forum:  microsoft.public.excel.newusers microsoft.public.excel.newusers - forum profile
Thread:  Show this thread (2 posts) Thread info: Password protected spreadsheet in microsoft.public.excel.newusers Size: 640 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Password protected spreadsheet in microsoft.public.excel.newusers :: microsoft.public.excel.newusers :: Discussions in microsoft.public.excel.newusers"
microsoft.public.excel.newusers
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 ...
Forum:  microsoft.public.excel.newusers microsoft.public.excel.newusers - forum profile
Thread:  Show this thread (2 posts) Thread info: How do you export pictures from my pictures file into a word docu in
microsoft.public.excel.newusers Size: 912 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: How do you export pictures from my pictures file into a word docu in
microsoft.public.excel.newusers :: microsoft.public.excel.newusers :: Discussions in microsoft.public.excel.newusers"
microsoft.public.excel.newusers
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...
Forum:  microsoft.public.excel.newusers microsoft.public.excel.newusers - forum profile
Thread:  Show this thread (2 posts) Thread info: Macros for template in microsoft.public.excel.newusers Size: 842 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Macros for template in microsoft.public.excel.newusers :: microsoft.public.excel.newusers :: Discussions in microsoft.public.excel.newusers"
microsoft.public.excel.newusers
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 <...
Forum:  microsoft.public.excel.newusers microsoft.public.excel.newusers - forum profile
Thread:  Show this thread (2 posts) Thread info: Is there an excel template for coupon organization? in
microsoft.public.excel.newusers Size: 1,351 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Is there an excel template for coupon organization? in
microsoft.public.excel.newusers :: microsoft.public.excel.newusers :: Discussions in microsoft.public.excel.newusers"
microsoft.public.excel.newusers
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 ...
Forum:  microsoft.public.excel.newusers microsoft.public.excel.newusers - forum profile
Thread:  Show this thread (2 posts) Thread info: Mark Rows for scrolling in microsoft.public.excel.newusers Size: 1,413 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Mark Rows for scrolling in microsoft.public.excel.newusers :: microsoft.public.excel.newusers :: Discussions in microsoft.public.excel.newusers"
microsoft.public.excel.newusers
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...
Forum:  microsoft.public.excel.newusers microsoft.public.excel.newusers - forum profile
Thread:  Show this thread (2 posts) Thread info: Calculating with Variable Search in microsoft.public.excel.newusers Size: 606 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Calculating with Variable Search in microsoft.public.excel.newusers :: microsoft.public.excel.newusers :: Discussions in microsoft.public.excel.newusers"