|
More site info...
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.
|
|
|
|
|
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:
|
|
|
BoardReader Authority Badge code for Microsoft Excel forum (http://excelbanter.com)
|
|
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.
|
|
|
|
|
Microsoft Excel forum posting activity graph:
|
|
http://excelbanter.com Alexa graph:
|
Top authors on Microsoft Excel forum during last week:
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 >...
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 > > >...
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...
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...
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....
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...
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...
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...
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
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:
|
|
Top 10 forums on Microsoft Excel forum:
|
|
|
|
Latest active threads on 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...
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://...
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 ...
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
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)*(...
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...
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
...
>
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, ...
|
|
Hot threads for last week on Microsoft Excel forum:
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...
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)...
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 ...
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 ...
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:
...
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
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
...
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, ...
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 ...
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 ...
|
|
![Thread info: [Q] How to use Excel to show est. compounded value displayed by mo](/images/thp_r1581.gif "Thread info: [Q] How to use Excel to show est. compounded value displayed by mo")
Size: 2,187 bytes
![Customize "RE: [Q] How to use Excel to show est. compounded value displayed by mo :: Excel Worksheet Functions :: Microsoft Excel forum"](/images/cust_r0.gif "Customize \"RE: [Q] How to use Excel to show est. compounded value displayed by mo :: Excel Worksheet Functions :: Microsoft Excel forum\"")
