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... 

Microsoft Excel forum - excelbanter.com | Site profile

Site profile page for http://excelbanter.com. This report page has aggregated and summarized the online discussions from the Message Board located at http://excelbanter.com. 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://excelbanter.com 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: Microsoft Excel forum - http://excelbanter.com Microsoft Excel forum
Url: http://excelbanter.com
Users activity: 3 posts per thread
site activity: 1,160 active threads during last week
Site rank: 814 (go to rank page)
Domain info for: excelbanter.com
 

Posting activity table on Microsoft Excel forum:

  Week Month 3 Months
Threads: 1,160 4,263 12,118
Post: 3,113 10,956 33,985
 

Authority Badge:

Microsoft Excel forum | Forum Authority Badge

Microsoft Excel forum posting activity graph:

Posts by:  day  week  month 
 

http://excelbanter.com Alexa graph:

Top authors on Microsoft Excel forum during last week:

Name
Posts
Jacob Skaria
212
user's latest post:
MIN from another worksheet
Published (2009-11-07 18:46:00)
Ofcourse with the sheet references.... (array entered) =MIN(IF((Sheet1!G1:G100="condo"),Sheet1!F1:F100)) 'error handled version..incase you have any error cells in the range F1:F100 (array entered) =MIN(IF((Sheet1!G1:G100="condo")* (ISNUMBER(Sheet1!F1:F100)),Sheet1!F1:F100)) If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: > Hi Shelina >...
T. Valko
148
user's latest post:
how to average a range of cells...
Published (2009-11-07 23:42:00)
mark -- Biff Microsoft Excel MVP "T. Valko" > wrote in message ... > Try something like this... > > The formula won't calculate an average until at least 1 number is entered > in > the range. > > > =IF(COUNT(A1:A10),AVERAGE(A1:A10),"") > > > -- > Biff > Microsoft Excel MVP > > >...
Gord Dibben
144
user's latest post:
One command in one cell...
Published (2009-11-07 18:19:00)
Formulas in a cell cannot change values in any other cell unless the other cell has a formula referencing the first cell. Q6, Z6 and E7 must have their own formulas referencing F2 value. i.e. In Q6 =IF(F2=B5,N6,"not equal") Gord Dibben MS Excel MVP On Sat, 7 Nov 2009 08:42:01 -0800, Chas52 > wrote: >I would like to create a cell that directs a number of cells formulas. eg. If >I direct F2=B5, then Q6...
Dave Peterson
120
user's latest post:
Want to keep...
Published (2009-11-07 18:08:00)
Change the formulas to values in the cells/worksheets where you don't want the formulas to update. Select the range to fix Edit|copy edit|paste special|values Is one way of doing it. raisingcain wrote: > > I use Excel 2002. I have a workbook where I enter data throughout the year > in one of the worksheets. There are 52 other worksheets, representing each > week of the year (with a beginning date and end date...
David Biddulph[_2_]
85
user's latest post:
formula for sum
Published (2009-11-07 18:50:00)
Double unary minus: a.. http://www.mcgimpsey.com/excel/formulae/doubleneg.html b.. http://xldynamic.com/source/xld.SUMPRODUCT.html -- David Biddulph "afdmello" > wrote in message ... > > It's magic to me.Bingo!!! > > Thanks a million. > > Biff can you please tell me the significance of the two "--" in the > formula. Please excuse my ignorance....
Mike H
82
user's latest post:
Lookup Wizard
Published (2009-11-07 11:58:00)
Hi, I'm not sure I understand but here's a formula that looks up columns A, B, C & D and returns column E =INDEX(E2:E8,MATCH(1,(A2:A8=F2)*(B2:B8=F3)*(C2:C8= F4)*(D2 8=F5),0)) The lookup values go in f2, f3, f4 & f5 and it is an *ARRAY* formula This is an array formula which must be entered by pressing CTRL+Shift+Enter 'and not just Enter. If you do it correctly then Excel will put curly brackets 'around the...
Luke M
64
user's latest post:
How do I open a workbook at startup
Published (2009-11-06 16:35: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, Luke M...
Bernard Liengme[_3_]
62
user's latest post:
User Defined Functions
Published (2009-11-07 19:02:00)
Where are you placing the UDFs ? Trail version should work best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "MoTrekker" > wrote in message ... > I imported a Excel 2003 spreadsheet with UDFs and the UDFs are not found. > Additionally, I have tried to rebuild the UDFs in 2007 and I can't get the > functions reconized. Is the issue that...
Don Guillett
55
user's latest post:
Deactivating a macro button
Published (2009-11-07 21:30:00)
You could use sheet activate and sheet deactivate macros to install/uninstall the button. OR, just put a non-printable shape on the desired sheet. -- Don Guillett Microsoft MVP Excel SalesAid Software
Peo Sjoblom[_3_]
50
user's latest post:
Time Format and Calculate...
Published (2009-11-07 00:04:00)
Post what is in the cells and the formula you used, time is pretty straightforward just subtract =A1-B1 where B1 holds 05:00 and A1 holds 14:00 will return 9:00 and not 7:00 Of course if you use time you should tell Excel that you are using time and use : as a delimiter or else how would excel know that 1400 is time and not One Thousand Four Hundred? -- Regards, Peo Sjoblom "da" > wrote in message ... > Hello...
 

Top 10 active forums on Microsoft Excel forum during last week:

Excel Discussion (Misc queries) - 1,719 new posts Excel Discussion (Misc queries) - forum profile
Excel Worksheet Functions - 1,118 new posts Excel Worksheet Functions - forum profile
New Users to Excel - 202 new posts New Users to Excel - forum profile
Charts and Charting in Excel - 108 new posts Charts and Charting in Excel - forum profile
Setting up and Configuration of Excel - 28 new posts Setting up and Configuration of Excel - forum profile
Links and Linking in Excel - 4 new posts Links and Linking in Excel - forum profile
 

Top 10 forums on Microsoft Excel forum:

Excel Discussion (Misc queries) - 80,369 posts Excel Discussion (Misc queries) - forum profile
Excel Worksheet Functions - 52,015 posts Excel Worksheet Functions - forum profile
New Users to Excel - 11,209 posts New Users to Excel - forum profile
Charts and Charting in Excel - 9,015 posts Charts and Charting in Excel - forum profile
Setting up and Configuration of Excel - 2,832 posts Setting up and Configuration of Excel - forum profile
Links and Linking in Excel - 735 posts Links and Linking in Excel - forum profile

Latest active threads on Microsoft Excel forum:

Microsoft Excel forum
Started 1 day, 20 hours ago (2009-11-08 02:40:00)  by Joe User[_2_]
"JohnH" wrote: > I have two years to save > I have a starting value, say $100 > I have an intrest rate, say 2% > I want to add $10 a month > [Q] How can I use Excel to show my total compounded balance > 'each month' forecast over the two years ? Depends on what you mean. 1. You mean that you invest $100 at the beginning of the first month and $10 at the beginning of each of the...
Forum:  Excel Worksheet Functions Excel Worksheet Functions - forum profile
Thread:  Show this thread (3 posts) Thread info: [Q] How to use Excel to show est. compounded value displayed by mo Size: 2,187 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: [Q] How to use Excel to show est. compounded value displayed by mo :: Excel Worksheet Functions :: Microsoft Excel forum"
Microsoft Excel forum
Started 1 day, 21 hours ago (2009-11-08 01:39:00)  by Bernard Liengme[_3_]
last nonblank Non-array, non-volatile formula for contents of last, non-blank cell in a range: =LOOKUP(2,1/(A1:A100<>""),A1:A100) For last non-blank text =LOOKUP(REPT("z",255),Sheet1!e1:e100,Sheet1!e1:e1 0 0) You can shorten that to: =LOOKUP(REPT("z",255),Sheet1!e1:e100) Last non-zero =LOOKUP(2,1/(B7:H7<>0),B7:H7) -- Bernard V Liengme Microsoft Excel MVP http://...
Forum:  Excel Discussion (Misc queries) Excel Discussion (Misc queries) - forum profile
Thread:  Show this thread (3 posts) Thread info: Find first empty cell in column Size: 1,403 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Find first empty cell in column :: Excel Discussion (Misc queries) :: Microsoft Excel forum"
Microsoft Excel forum
Started 1 day, 21 hours ago (2009-11-08 00:55:00)  by Gary''s Student
Select the cells you want to fix and run this small macro: Sub AddADot() For Each r In Selection s = Split(r.Value, " ") If UBound(s) = 2 Then If Len(s(1)) = 1 Then s(1) = s(1) & "." r.Value = Join(s, " ") End If End If Next End Sub -- Gary''s Student - gsnu200908 "G. B. Needs Excel Help" wrote: > I am looking for an ...
Forum:  Excel Worksheet Functions Excel Worksheet Functions - forum profile
Thread:  Show this thread (3 posts) Thread info: If..The Statement to automatically format a name Size: 1,076 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: If..The Statement to automatically format a name :: Excel Worksheet Functions :: Microsoft Excel forum"
Microsoft Excel forum
Started 1 day, 20 hours ago (2009-11-08 02:03:00)  by Gary''s Student
The array formula: =ADDRESS(MIN((IF(ISBLANK(A1:A99),ROW(A1:A99)))),C O LUMN(A:A)) should be entered with CNTRL-SHFT-ENTER rather than just the ENTER key. -- Gary''s Student - gsnu200908 "TomHull" wrote: > Hi, > > Is there a formula method to find the first empty cell in a column? > > Thanks, > > Tom
Forum:  Excel Discussion (Misc queries) Excel Discussion (Misc queries) - forum profile
Thread:  Show this thread (6 posts) Thread info: Finding First Empty Cell in a Column Size: 568 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Finding First Empty Cell in a Column :: Excel Discussion (Misc queries) :: Microsoft Excel forum"
Microsoft Excel forum
Started 3 days, 4 hours ago (2009-11-06 18:23:00)  by Peo Sjoblom[_3_]
Hi Linda, First of all, June-08 is that supposed to be June 2008? If so make sure by selecting a cell with this value and look in the formula bar and make sure it doesn't say 6/8/2009, that is what my Excel does if I type June-08, Excel thinks you mean June 8th current year. Anyway it is very easy to get average for particular months and years, =AVERAGE(IF((MONTH(A3:A21)=6)*(...
Forum:  New Users to Excel New Users to Excel - forum profile
Thread:  Show this thread (4 posts) Thread info: Average Function Size: 2,866 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Average Function :: New Users to Excel :: Microsoft Excel forum"
Microsoft Excel forum
Started 1 day, 21 hours ago (2009-11-08 01:41:00)  by Dave Peterson
=sumproduct(--(a1:a10="texta"),--(b1:b10="textb"), --(c1:c10="text c")) Adjust the ranges to match--but you can't use whole columns (except in xl2007). =sumproduct() likes to work with numbers. The -- stuff changes trues and falses to 1's and 0's. Bob Phillips explains =sumproduct() in much more detail he http://www.xldynamic.com/source/xld.SUMPRODUCT.htm l And J.E. McGimpsey has...
Forum:  Excel Discussion (Misc queries) Excel Discussion (Misc queries) - forum profile
Thread:  Show this thread (4 posts) Thread info: Help with Excel Size: 1,224 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Help with Excel :: Excel Discussion (Misc queries) :: Microsoft Excel forum"
Microsoft Excel forum
Started 1 day, 21 hours ago (2009-11-08 01:52:00)  by Bernard Liengme[_3_]
Use custom format 0 ??/14 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "dmowday" > wrote in message ... >
Forum:  Excel Worksheet Functions Excel Worksheet Functions - forum profile
Thread:  Show this thread (2 posts) Thread info: How do I customize the available fraction formats to fourteenths? Size: 445 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: How do I customize the available fraction formats to fourteenths? :: Excel Worksheet Functions :: Microsoft Excel forum"
Microsoft Excel forum
Started 2 days, 3 hours ago (2009-11-07 19:03:00)  by Joe User[_2_]
"Robbie G" > wrote: > I am using the PMT function to calculate mortgage payments. > payments are at the end of each month and there will be 240 > payments. how should i account for the fact that the mortgage > may start partway through the first month? I cannot think of a way to use the PMT function for this. And my mathematical formula is complicated. See below. Alternatively, ...
Forum:  Excel Worksheet Functions Excel Worksheet Functions - forum profile
Thread:  Show this thread (4 posts) Thread info: PMT function and 1st payment partway through a period Size: 1,743 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: PMT function and 1st payment partway through a period :: Excel Worksheet Functions :: Microsoft Excel forum"
 

Hot threads for last week on Microsoft Excel forum:

Excel Worksheet Functions
Complex Count formula - 36 new posts
Started 5 days, 21 hours ago (2009-11-04 01:47:00)  by GoBucks[_2_] external usenet poster
I am looking to get a formula that count the number of rows that match some criteria. The sample table is listed below. I would to have a formula calculate the # of rows in which values in column B >=3 along with values in Column C = 0 ID RATING AMOUNT formula match 00304 4.0 (5.0) x 00299 2.5 - x 00069 2.5 2.0 01380 4.0 - x 01729 3.0 - x 01783 2.5 - x 01934 2...
Forum:  Excel Worksheet Functions Excel Worksheet Functions - forum profile
Thread:  Show this thread (36 posts) Thread info: Complex Count formula Size: 951 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Complex Count formula :: Excel Worksheet Functions :: Microsoft Excel forum"
Excel Worksheet Functions
Started 4 days, 10 hours ago (2009-11-05 12:01:00)  by Mattlynn via OfficeKB.com
Another way of saying this is... In Column D, i would want to say that if Column A = Retail Direct, and Column B = 25500 sales value. then the answer should be 6 Or If Column A =Distributor, and Column B = 200,000 then the result should be 25 Hoping someone can help !! Thanks Matt Mattlynn wrote: >Hi, > >I have data in 3 Columns > >Sales Group (Col A) Sales Value (Col B)...
Forum:  Excel Worksheet Functions Excel Worksheet Functions - forum profile
Thread:  Show this thread (14 posts) Thread info: Lookup with AND i think Size: 1,658 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Lookup with AND i think :: Excel Worksheet Functions :: Microsoft Excel forum"
Excel Discussion (Misc queries)
Started 4 days, 21 hours ago (2009-11-05 01:06:00)  by Peo Sjoblom[_3_]
The data from Access is probably text whereas the data you type into the cell is a number, copy an empty cell formatted as general or number and select all the imported numbers, then do paste special and select add. That will force any numbers formatted as text to turn into matching numbers. -- Regards, Peo Sjoblom "Bob1866" > wrote in message ... > Hi, If I ...
Forum:  Excel Discussion (Misc queries) Excel Discussion (Misc queries) - forum profile
Thread:  Show this thread (14 posts) Thread info: Problem with VLookup Size: 1,557 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Problem with VLookup :: Excel Discussion (Misc queries) :: Microsoft Excel forum"
Excel Worksheet Functions
Started 5 days, 7 hours ago (2009-11-04 15:08:00)  by Bernie Deitrick
Abdul, =$C$1-D4 + 1 - SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(E4&":"&C1)),1)= 6)) I'm not sure if you want 2 or 1 when you use two dates that are consecutive days - if you want 1, then remove the +1, otherwise, leave it. HTH, Bernie MS Excel MVP "Abdul" > wrote in message ... > Hi, > > I am using the following formula to get number of days passed > excluding Fridays in a ...
Forum:  Excel Worksheet Functions Excel Worksheet Functions - forum profile
Thread:  Show this thread (12 posts) Thread info: Formula to get number of days excluding Fridays in a given period Size: 1,688 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Formula to get number of days excluding Fridays in a given period :: Excel Worksheet Functions :: Microsoft Excel forum"
Excel Discussion (Misc queries)
RE: Hide Names - 12 new posts
Started 4 days, 10 hours ago (2009-11-05 12:37:00)  by Jarek Kujawa[_2_]
excel 2003 one way might be to set your own password for file opening if not matched the Workbook_Open event would delete the Formula toolbar Private Sub Workbook_Open() Application.DisplayFormulaBar = True k = InputBox("Insert a password") If k <> "your_password" Then Application.DisplayFormulaBar = False End Sub pls click YES if it helped On 6 Lis, 12:16, Stanley > wrote: ...
Forum:  Excel Discussion (Misc queries) Excel Discussion (Misc queries) - forum profile
Thread:  Show this thread (12 posts) Thread info: Hide Names Size: 994 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Hide Names :: Excel Discussion (Misc queries) :: Microsoft Excel forum"
Excel Discussion (Misc queries)
RE: Median formula - 11 new posts
Started 6 days, 8 hours ago (2009-11-03 14:50:00)  by Jarek Kujawa[_2_]
=MEDIAN(IF(Sheet1!C1:C100="sold",Sheet1!C1:C100)) array-entered i.e. CTRL+SHIFT+ENTER On 3 Lis, 14:43, Trev > wrote: > I need a formula that will give me median if Column C on Sheet 1 =sold. Any > ideas? *Thanks > Trev
Forum:  Excel Discussion (Misc queries) Excel Discussion (Misc queries) - forum profile
Thread:  Show this thread (11 posts) Thread info: Median formula Size: 466 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Median formula :: Excel Discussion (Misc queries) :: Microsoft Excel forum"
Excel Discussion (Misc queries)
Started 5 days, 10 hours ago (2009-11-04 12:33:00)  by Jarek Kujawa[_2_]
=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" > 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 C, but > including rows with the same value in col B. The answer would be from col A ...
Forum:  Excel Discussion (Misc queries) Excel Discussion (Misc queries) - forum profile
Thread:  Show this thread (11 posts) Thread info: finding a value with parameters Size: 1,094 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: finding a value with parameters :: Excel Discussion (Misc queries) :: Microsoft Excel forum"
Excel Discussion (Misc queries)
Started 1 week ago (2009-11-02 10:49:00)  by Geoff_L[_2_]
If you keep the information in Access you could create a report that was a lot easier to format than in Excel. You can create all the subtotals etc that you need and have full control over how they appear. You can also force a new page for each group, if the whole group won't fit on the remainder of the page. If you are looking for presentation and not just raw facts and figures, ...
Forum:  Excel Discussion (Misc queries) Excel Discussion (Misc queries) - forum profile
Thread:  Show this thread (10 posts) Thread info: Automatic page breaks and formulas Size: 1,795 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Automatic page breaks and formulas :: Excel Discussion (Misc queries) :: Microsoft Excel forum"
Excel Worksheet Functions
Started 1 week, 1 day ago (2009-11-01 03:20:00)  by T. Valko
What should happen if the date is entered but the rest of the cells are empty? -- Biff Microsoft Excel MVP "Kimti" > wrote in message ... >I have data in multipal rows and one column is for date. If date column is > blank I would like to highlight rest of the row in color. > > A B C D E F > 21 32 12 54 12 OCT 12, 2009 > 23 43 12 11 34 > > As F2 is blank I ...
Forum:  Excel Worksheet Functions Excel Worksheet Functions - forum profile
Thread:  Show this thread (10 posts) Thread info: Conditional Formating Size: 856 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Conditional Formating :: Excel Worksheet Functions :: Microsoft Excel forum"
Excel Worksheet Functions
Started 6 days, 2 hours ago (2009-11-03 20:03:00)  by Luke M
Assuming it is truly just the format that's causing the display (and not text inputted as a date) you can just use the MONTH and YEAR functions. Example: =MONTH(SerialDate) See XL help file for further detail. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "TDMP" wrote: > Hello, I have a sheet that contains dates in column (W) formatted per ...
Forum:  Excel Worksheet Functions Excel Worksheet Functions - forum profile
Thread:  Show this thread (10 posts) Thread info: Uk Date Format to US Date Format Size: 928 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Uk Date Format to US Date Format :: Excel Worksheet Functions :: Microsoft Excel forum"