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.misc - 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.misc - http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.excel.misc Discussions in microsoft.public.excel.misc
Url: http://www.microsoft.com/communities/newsgroups...
Users activity: 3 posts per thread
site activity: 444 active threads during last week
Site rank: 1,751 (go to rank page)
Domain info for: microsoft.com
 

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

  Week Month 3 Months
Threads: 444 1,500 4,872
Post: 963 3,740 14,285
 

Authority Badge:

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

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

Posts by:  day  week  month 
 

http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.excel.misc Alexa graph:

Top authors on Discussions in microsoft.public.excel.misc during last week:

Name
Posts
Jacob Skaria
64
user's latest post:
Editing cell names in...
Published (2009-11-08 22:19:00)
  Use the below macro to rename all the named ranges at one shot...The below macro would get the sheet name for each named range and if it is SHEET1 then add a "_A" to the current name "_B" if the range is referred to Sheet2 and so on.. --Edit the sheetnames to suit your requirement --Note that the sheetnames are in upper case If you are new to macros.. --Set the Security level to low/medium in...
Mike H
38
user's latest post:
sumif and left in...
Published (2009-11-06 07:09:00)
  Hi, This works for your posted data =SUMPRODUCT((INT(A1:A10/100))*(B1:B10)) Mike "Bonita" wrote: > col a col b > 103 100 > 204 500 > > need to sum col b based on the first left character of col a > ie 1 100 > 2 500 > > -- > Bonita  
Luke M
33
user's latest post:
How do I open a workbook at...
Published (2009-11-06 07:34:00)
  If you mean startup of XL: Under Tools - Options, General, you can specifiy a folder to open all files in. Place your file in this folder, then setup the option. If you mean startup of computer: Explore the start menu, doulbe click programs, and you should see a folder called "startup". Place any programs/files you want opened upon login into this folder (place shortcuts, not the actual file!) -- Best Regards,...
Gary''s Student
29
user's latest post:
Finding First Empty Cell in a...
Published (2009-11-08 17:12:00)
  Very nice -- Gary''s Student - gsnu200908 "Jacob Skaria" wrote: > For cell address..(normal entered) > =ADDRESS(SUMPRODUCT(MATCH("",A1:A100&"",0)),COLUMN(A1:A100)) > > If this post helps click Yes > --------------- > Jacob Skaria > > > "Jacob Skaria" wrote: > >...
Gord Dibben
27
user's latest post:
How do i add a pop up picture in...
Published (2009-11-04 15:39:00)
  What do you mean by "scaled down to nothing"? Right-click cell and Insert Comment. Right-click on border of Comment and Format Comment. Select Colors and Lines>Color>Fill Effects>Picture. Exactly the same as 2003. Gord Dibben MS Excel MVP On Wed, 4 Nov 2009 09:03:01 -0800, notahacker <notahacker@discussions.microsoft.com> wrote: >I have seen how to add a pop up picture as...
Dave Peterson
25
user's latest post:
Launch Click Event Using...
Published (2009-11-04 10:23:00)
  You know the codename of that sheet that holds that button, right? Dim OtherWkbk As Workbook Set OtherWkbk = Workbooks("Budget Payee Names.xls") Application.Run "'" & OtherWkbk.Name & "'!sheet1.cbAddPayee_Click" Replace sheet1 with the codename for worksheet that owns that commandbutton. Another way if you know the sheetname, but not its codename: Dim...
JLatham
23
user's latest post:
How to search for a code, and...
Published (2009-11-08 21:05:00)
  Well, sorry about the triple post - damned HTML side of this mess kept telling me that it wasn't posting my response. "Jared" <Jared@discussions.microsoft.com> wrote in message news:E965ACF7-6955-4B76-B25F-09C0438E6D91@microsoft.com... > So, here is the basic problem - I have one spreadsheet that has 100's of > codes, and information below each code. I have another spreadsheet...
Bob I
16
user's latest post:
Convert multiple excel files...
Published (2009-11-04 15:40:00)
  What happens when you select the Files in Windows Explorer, and then r-click on them and pick Convert to PDF? Phil J W wrote: > Can this be done? I have about 500 store specific excel files, with 2 sheets > each. I'd like a quick way to PDF all of them, not as one big file, but as > individule PDFs. Here at the office we are using Office 2007 and Adobe > Acrobat 9 Pro...thank you. .  
MS-Exl-Learner
15
user's latest post:
how do I put in a name for the...
Published (2009-11-08 22:03:00)
  Just select the column or columns and press Cntrl+F3 and give the name you want and press ok. Now use the defined name in your formula. For Example:- Select the B to E and press Cntrl+F3 and give the desired name as ABC and give Ok. And use the defined name in your formula like this. =SUM(ABC) This will total the Numeric values which are all available in B to E Column If this post helps, Click Yes! --------------------...
JBeaucaire
14
user's latest post:
Want to keep...
Published (2009-11-07 10:31:00)
  To "flatten" a worksheet...removing all the formulas but keeping the data: 1) Select the sheet 2) Press CTRL-A to select ALL the data on the sheet. You might have to press CTRL-A several time to get it all 3) Press CTRL-C to copy everything 4) Click on Edit > PasteSpecial > Values Now the sheet is flattened, no formulas are left on the sheet. -- "Actually, I *am* a rocket...
 

Top 10 active forums on Discussions in microsoft.public.excel.misc during last week:

microsoft.public.excel.misc - 1,022 new posts microsoft.public.excel.misc - forum profile
 

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

microsoft.public.excel.misc - 107,230 posts microsoft.public.excel.misc - forum profile

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

Discussions in microsoft.public.excel.misc
Started 1 day, 5 hours ago (2009-11-09 13:05:00)  by Anthony Fontana
What exactly do you mean by "does not want to copy down." Does Excel not show the fill handle or does the copy/paste functions not work? Or does the function copy but not evaluate at all, or correctly? "Janet T" wrote: > =sum(c1-a2+b2). Just a simple formula for keeping track of cks for bank > ...
Forum:  microsoft.public.excel.misc microsoft.public.excel.misc - forum profile
Thread:  Show this thread (2 posts) Thread info: excel formula won't copy down in microsoft.public.excel.misc Size: 970 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: excel formula won't copy down in microsoft.public.excel.misc :: microsoft.public.excel.misc :: Discussions in microsoft.public.excel.misc"
Discussions in microsoft.public.excel.misc
Started 1 day, 6 hours ago (2009-11-09 12:08:00)  by Pammy
I want the cell to always be a negative, I misunderstood what was asked me. Thanks, "Pammy" wrote: > If I enter a 2 in a cell, I want it to always show as a -2. > Anytime I type 2, if comes in as -2. Is there a way to do this?
Forum:  microsoft.public.excel.misc microsoft.public.excel.misc - forum profile
Thread:  Show this thread (2 posts) Thread info: cell to stay same in microsoft.public.excel.misc Size: 615 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: cell to stay same in microsoft.public.excel.misc :: microsoft.public.excel.misc :: Discussions in microsoft.public.excel.misc"
Discussions in microsoft.public.excel.misc
Started 1 day, 8 hours ago (2009-11-09 10:05:00)  by Joe User
"DRKENNE" wrote: > I'm looking for a formula (simple I hope) that would calculate interest > that's been accruing at an annual rate of 10% on $10,500 that should have > been paid on 3/6/07 and no payment has been made. Since there is no end date > at this time, I'd be using the date (today) of the calculation. So many details...
Forum:  microsoft.public.excel.misc microsoft.public.excel.misc - forum profile
Thread:  Show this thread (5 posts) Thread info: Calculating acruing interest in microsoft.public.excel.misc Size: 1,413 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Calculating acruing interest in microsoft.public.excel.misc :: microsoft.public.excel.misc :: Discussions in microsoft.public.excel.misc"
Discussions in microsoft.public.excel.misc
Started 1 day, 7 hours ago (2009-11-09 11:00:00)  by Jacob Skaria
Try =COUNTIF(A:A,"complete")/COUNTA(A:A)% If this post helps click Yes --------------- Jacob Skaria "Matt" wrote: > I have specific status codes in Text Format in Column B of my workbook. I'm > wanting to setup a formula that will calculate the average of one status > marked complete to be ...
Forum:  microsoft.public.excel.misc microsoft.public.excel.misc - forum profile
Thread:  Show this thread (2 posts) Thread info: Formula Question in microsoft.public.excel.misc Size: 914 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Formula Question in microsoft.public.excel.misc :: microsoft.public.excel.misc :: Discussions in microsoft.public.excel.misc"
 

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

microsoft.public.excel.misc
Started 1 day, 16 hours ago (2009-11-09 01:30:00)  by Jacob Skaria
Hi George The below formula will sum the fleet entries for the month specified in cell A2. =SUMPRODUCT((TEXT(A2:A100,"mmyyyy")=TEXT(A2,"mm yyyy"))*(B1:G1="Fleet"),B2:G100) You can take out the first condition if you want a full sum of fleets =SUMPRODUCT((B1:G1="Fleet")*B2:G100) If this post helps click ...
Forum:  microsoft.public.excel.misc microsoft.public.excel.misc - forum profile
Thread:  Show this thread (15 posts) Thread info: Jululian Excel in microsoft.public.excel.misc Size: 1,303 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Jululian Excel in microsoft.public.excel.misc :: microsoft.public.excel.misc :: Discussions in microsoft.public.excel.misc"
microsoft.public.excel.misc
Started 6 days, 7 hours ago (2009-11-04 10:24:00)  by Luke M
using formulas, you can use the UPPER function. via macros, you can use the UCase operator. Something like: Sub CapMe() For Each ws In ThisWorkbook.Worksheets 'Adjust as desired For Each cell In ws.Range("A1:Z200") cell.Value = UCase(cell.Value) Next cell Next ws End Sub -- Best Regards,...
Forum:  microsoft.public.excel.misc microsoft.public.excel.misc - forum profile
Thread:  Show this thread (10 posts) Thread info: Changing from lower case to upper case in microsoft.public.excel.misc Size: 1,219 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Changing from lower case to upper case in microsoft.public.excel.misc :: microsoft.public.excel.misc :: Discussions in microsoft.public.excel.misc"
microsoft.public.excel.misc
Started 6 days, 8 hours ago (2009-11-04 09:56:00)  by Jarek Kujawa
=MIN(IF($A$2:$A$5="j",$B$2:$B$5)) array-enter this formula i.e. with CTRL+SHIFT+ENTER instead of using ENTER only On 4 Lis, 11:18, "soonic" <xxsoo...@op.pl> wrote: > Hi > > Is it possible to make it work in excel in this situation: > > I've got 3 columns: A,B,C. I want to find the smallest number in col...
Forum:  microsoft.public.excel.misc microsoft.public.excel.misc - forum profile
Thread:  Show this thread (10 posts) Thread info: finding a value with parameters in microsoft.public.excel.misc Size: 1,429 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: finding a value with parameters in microsoft.public.excel.misc :: microsoft.public.excel.misc :: Discussions in microsoft.public.excel.misc"
microsoft.public.excel.misc
Started 1 week, 1 day ago (2009-11-02 09:51:00)  by Jacob Skaria
With your data in A1:B8 try the below formula =VLOOKUP(F3,A1:B8,2,0) If this post helps click Yes --------------- Jacob Skaria "Michelle" wrote: > I am trying to create a formula that will do this: > > Look at a letter in cell f3-- > > If it's Then it should write > ...
Forum:  microsoft.public.excel.misc microsoft.public.excel.misc - forum profile
Thread:  Show this thread (8 posts) Thread info: If statement HELP! in microsoft.public.excel.misc Size: 1,053 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: If statement HELP! in microsoft.public.excel.misc :: microsoft.public.excel.misc :: Discussions in microsoft.public.excel.misc"
microsoft.public.excel.misc
Started 1 week ago (2009-11-03 05:50:00)  by Luke M
Try this array** formula: =AVERAGE(IF(C1:C100="sold",B1:B100)) Adjust ranges as necessary. **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!* "Trev" wrote: > I need a formula ...
Forum:  microsoft.public.excel.misc microsoft.public.excel.misc - forum profile
Thread:  Show this thread (7 posts) Thread info: Median formula in microsoft.public.excel.misc Size: 881 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Median formula in microsoft.public.excel.misc :: microsoft.public.excel.misc :: Discussions in microsoft.public.excel.misc"
microsoft.public.excel.misc
Started 6 days, 9 hours ago (2009-11-04 09:13:00)  by Mike H
Yes http://www.amazon.co.uk/s/?ie=UTF8&keywords=excel+ 2007&tag=googhydr-21&index=software&hvadid=4130744 773&ref=pd_sl_2dkqmyk5nd_e Mike "george" wrote: > If you have Office 2003 and just want to upgrade Excel to 2007, is it possible?
Forum:  microsoft.public.excel.misc microsoft.public.excel.misc - forum profile
Thread:  Show this thread (7 posts) Thread info: Upgrading just Excel in microsoft.public.excel.misc Size: 841 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Upgrading just Excel in microsoft.public.excel.misc :: microsoft.public.excel.misc :: Discussions in microsoft.public.excel.misc"
microsoft.public.excel.misc
Started 5 days, 12 hours ago (2009-11-05 05:25:00)  by Tom Hutchins
Try this in F160: =IF(C160=0,"",C160) Hope this helps, Hutch "hoyos" wrote: > I have the following formula in cell "F160" > =IF($C160,C160,0) > > If I wish cell "F160" to be empty if cell "C160" = 0 > How do add to the formula...
Forum:  microsoft.public.excel.misc microsoft.public.excel.misc - forum profile
Thread:  Show this thread (7 posts) Thread info: Cell empty if value is 0????? in microsoft.public.excel.misc Size: 738 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Cell empty if value is 0????? in microsoft.public.excel.misc :: microsoft.public.excel.misc :: Discussions in microsoft.public.excel.misc"
microsoft.public.excel.misc
Started 1 day, 12 hours ago (2009-11-09 05:38:00)  by Luke M
Select the first table, A1:C6, with A1 being active cell. CF formula is: =A1=MAX(A1,A8) Set format, ok out. Select second table, A8:C13, with A8 being active cell. CF formula is: =A8=MAX(A1,A8) Set format, ok out. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!*...
Forum:  microsoft.public.excel.misc microsoft.public.excel.misc - forum profile
Thread:  Show this thread (7 posts) Thread info: Excel 2003 Conditional formatting challenge question in
microsoft.public.excel.misc Size: 1,376 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Excel 2003 Conditional formatting challenge question in
microsoft.public.excel.misc :: microsoft.public.excel.misc :: Discussions in microsoft.public.excel.misc"
microsoft.public.excel.misc
Started 1 week, 1 day ago (2009-11-02 15:07:00)  by T. Valko
If you open a file in xls format from an earlier version of Excel then you only get 255 columns / 65536 rows. You'd have to open the file then do a save as in one of the Excel 2007 formats. The next time you open the file you'll get all the rows/columns in Excel 2007. -- Biff Microsoft Excel MVP "Otto ...
Forum:  microsoft.public.excel.misc microsoft.public.excel.misc - forum profile
Thread:  Show this thread (6 posts) Thread info: Changing number of available columns & rows in microsoft.public.excel.misc Size: 1,053 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Changing number of available columns & rows in microsoft.public.excel.misc :: microsoft.public.excel.misc :: Discussions in microsoft.public.excel.misc"
microsoft.public.excel.misc
Started 1 week, 1 day ago (2009-11-02 02:29:00)  by Jacob Skaria
With DOB in cell A1 and future date in cell B1 try the below... =DATEDIF(A1,B1,"y") 'OR =DATEDIF(A1,B1,"y")&" years "& DATEDIF(A1,B1,"ym")&" months "& DATEDIF(A1,B1,"md")&" days" If this post helps click Yes --------------- Jacob Skaria "Roy Gudgeon" wrote: > HiGuys...
Forum:  microsoft.public.excel.misc microsoft.public.excel.misc - forum profile
Thread:  Show this thread (6 posts) Thread info: Age in microsoft.public.excel.misc Size: 1,309 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Age in microsoft.public.excel.misc :: microsoft.public.excel.misc :: Discussions in microsoft.public.excel.misc"