|
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,180
|
4,386
|
12,278
|
|
Post:
|
3,325
|
11,817
|
34,530
|
|
|
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:
Is there anonther way to write...
Published (2009-11-20 18:46:00)
Try the below =SUMPRODUCT((Sheet1!$B$4:$B$28064=$C18)*(Sheet1!$F $4:$F$28064=$G18)* (Sheet1!$H$4:$H$28064="Selected")*(Sheet1!$L$4:$L$ 28064<=TODAY())* (Sheet1!$M$4:$M$28064={"A","N"})) If this post helps click Yes --------------- Jacob Skaria "Ayo" wrote: > Is there an easier, or simplier way to write this formular? > >...
user's latest post:
pasting content copied from...
Published (2009-11-20 22:41:00)
This can only be done when copied cells are in same column or row. Hold CTRL key and click on each of the non-contiguous cells C5, F5 and H5 Copy then paste. Gord Dibben MS Excel MVP On Fri, 20 Nov 2009 12:00:02 -0800, d.adams > wrote: >I am trying to copy text from nonadjacent cells in a row in one spreadsheet >using Control/Select/Copy, and paste the text into adjacent cells in a row in >another spreadsheet. When...
user's latest post:
Median of column I if column A...
Published (2009-11-20 23:29:00)
>I have a worksheet with 13,000 lines of data. If the data is sorted so that the items are grouped together: Item1 Item1 Item1 Item2 Item2 Item2 Item3 Item3 This normally entered formula is much more efficient than an array formula on that much data. K2 = some item =MEDIAN(INDEX(Price,MATCH(K2,Item,0)):INDEX(Price, MATCH(K2,Item,0)+COUNTIF(Item,K2)-1)) Whe Price refers to I2:I13000 Item refers to A2:A13000 -- Biff Microsoft Excel MVP...
user's latest post:
Pasting into merged cells
Published (2009-11-20 19:37:00)
Yes, merged cells are indeed a pain. Avoid them like the plague. Read the archives of this group for countless reasons why. -- David Biddulph "ann" > wrote in message ... >I have a merged cell in which I want to paste text from another cell. >Every > time I try get an error message saying that the cellsI have to unmerge the > merged cells first, paste, and them remerge. Is there any way to...
user's latest post:
Data not updating in linked...
Published (2009-11-20 17:53:00)
First, you don't need the =sum() function. You're not adding multiple cells. You're just retrieving the value from a cell in that workbook. Second, I'd guess that you don't have both workbooks open in the same instance of excel. Open excel and then use File|open to open both files. (Your formula includes the drive and path. These wouldn't be included if both workbooks were open in the same instance.) Teri wrote:...
user's latest post:
How to round up to the nearest five
Published (2009-11-20 23:22:00)
Hi, Try this =CEILING(A1,5) Mike "James" wrote: > How can I make a 34 to a 35 etc etc. > > How can i round up any number to the nearest five or ten? > > E.G a 39 to a 40, a 6 to a 10 and a 1132 to a 1135. > > thanks.
user's latest post:
vlookup in french excel
Published (2009-11-18 19:53:00)
The function name is: RECHERCHEV Hope this helps. Pete On Nov 18, 6:22*pm, Caro > wrote: > What is the equivalent name for the formule « vlookup » in an french excel *? > Thks
Jacob Skaria external usenet poster
41
user's latest post:
Column width
Published (2009-11-19 19:02:00)
--Copy range --Select the target cell and right click >PasteSpecial>All>OK --Keeping the target selection right click>PasteSpecial>select ColumnWidth>OK If this post helps click Yes --------------- Jacob Skaria "Emece" wrote: > In Sheet 1 I have a certain amount of data, I want to select some cells and > copy them to Sheet 2 keeping the same format. When I do this, the...
user's latest post:
VLOOKUP formula for multiple...
Published (2009-11-18 14:10:00)
Hi, Try this: 1. Select the data range on the Actions sheet and assign it a name (Ctrl+F3), say actions. When selecting the range for name assignment, please select the header row. If there is no header for the 2 columns, please create a header row (say, Date and Status) and use the same headings on the three other sheets 2. Repeat step 1 for ranges on the other three sheets. The names assigned should be issues, risks and plan 3. Save the...
user's latest post:
General number formats changing...
Published (2009-11-19 21:35:00)
You must be very careful about entering data. Even if a cell is formatted general, entering something like 1/1 will cause to "re-format" as a Date. -- Gary''s Student - gsnu200908 "KMH" wrote: > What causes Excel 2007 to change general number formats from general to dates > or euros? How can I easily fix a big model that has lots of this occuring > all over it? >...
|
|
|
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 12 hours, 19 minutes ago (2009-11-22 09:45:00)
by Jacob Skaria
Select data range say A2:A1000 and from Data>Filter>Advanced filter>Criteria
range you can specify the 400 name range say D1 400
If this post helps click Yes
---------------
Jacob Skaria
"sleepless" wrote:
> I have a list of about 400 last names that I want to use to find in those
> names in other lists I have by doing an advanced filter. Many of the names
> are only a few ...
Started 7 hours, 35 minutes ago (2009-11-22 14:29:00)
by Dave Peterson
You should post this in a forum dedicated to Outlook--not dedicated to excel.
sknair02 wrote:
>
> Hi,
>
> AppName: outlook.exe AppVer: 12.0.4518.1014 AppStamp:4542840f
> ModName: outlfltr.dll ModVer: 12.0.4326.0 ModStamp:44c81343
> fDebug: 0 Offset: 0004acff
>
> I get the above error and outlook 2007 closes and restarts and same mail
> repeatedly ...
Started 7 hours, 51 minutes ago (2009-11-22 14:13:00)
by Jacob Skaria
Try the below formula in a saved workbook.
=MID(CELL("filename",A1),FIND("]",CELL("filename" ,A1))+1,99)
If this post helps click Yes
---------------
Jacob Skaria
"Kate Bj" wrote:
> Could anyone please tell how I add the tab name to a specifik cell in the
> excel shet.
Started 16 hours, 32 minutes ago (2009-11-22 05:32:00)
by Ron Rosenfeld
On Fri, 20 Nov 2009 14:25:01 -0800, David >
wrote:
>I need a formula to parse text that looks something like this to extract the
>data contained in parentheses.
>
>FI-SL: Local Posting Periods (GCP1)
>
>I was using the following formula which worked just fine ...
>
>=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1) -1)
>
>...until I ran into text with another left parentheses to ...
Started 9 hours, 34 minutes ago (2009-11-22 12:30:00)
by Per Jessen
Hi Chris
This will get the value in cell H2 of the sheet specified in B2:
=INDIRECT(B2&"!H2")
Regards,
Per
"Chris" > skrev i meddelelsen
...
> I'm using Office 2007
> I have a workbook with 20+ pages. On one of them I want to use a formula
> that refers to a worksheet name, but in different cells I want it to refer
> to different worksheets.
>
> I have a cell that ...
Started 1 day, 23 hours ago (2009-11-20 22:51:00)
by Luke M
In your example, you could use:
=--(RIGHT(A2,3))
If your cells follow a pattern of:
Text(space)number
You can use:
=--(RIGHT(A2,LEN(A2)-FIND(" ",A2)))
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"April" wrote:
> Hi,
> I can't seem to remember how to use a formula to extract numbers only. For
> example, I would like to take a create a ...
Started 13 hours, 38 minutes ago (2009-11-22 08:26:00)
by Markytee
There are probably better ways than this, but I'd create an additional column
(between Average and Rank on your example) which works on the basis that if
the result is "Pass", then return the average score, else return "", and run
the rank from that column. You could always hide that column for the
purposes of neatness.
|
|
Hot threads for last week on Microsoft Excel forum:
Started 4 days, 14 hours ago (2009-11-18 07:18:00)
by rweiss
Trying to solve for the following:
Count if
1) Priority = "Must"
AND
2) Status <> "Closed", "Accepted", or "Testing"
AND
3) Functional Area begins with "RPT"
AND
4) Estimated Effort = "XL"
Wondering how best to modify the formula below to represent parts 2 and 3
above. How to represent contains "rpt" or begins with "rpt" (if wildcards
were permitted this ...
Started 6 days, 3 hours ago (2009-11-16 18:33:00)
by Bernard Liengme
=IF(OR(ISNA(VLOOKUP(A4,Sat!$A$16:$J$377,9,FALSE)),
VLOOKUP(A4,Sat!$A$16:$J$377,9,FALSE=0,"",VLOOKUP( A 4,Sat!$A$16:$J$377,9,FALSE))
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP
"Steve" > wrote in message
...
> This formula works if the data is present, however, I'm getting #N/A if
> the
> lookup cell (A4) doesn't exist, which it may not ...
Started 1 week, 2 days ago (2009-11-13 14:28:00)
by Mike H
Hi,
Try this with the file extension changed as required
=IF(A1="Brent",[Book2.xlsx]Sheet1!$A$1,"")
Mike
"Canon" wrote:
> Excel 2009
> I am looking for a formula that will do the following;
> If cell A1 in workbook one = Brent, then cell B1 must equal the amount in
> cell A1 of workbook two
>
Started 1 week, 1 day ago (2009-11-14 00:56:00)
by Max
Here's one dart throw ..
Assume your 24 source cells are A2:A25
Place in say, B2, normal ENTER to confirm:
=INDEX(A2:A25,MATCH(TRUE,INDEX(ISTEXT(A2:A25),),0 ) )
Bullseye? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Chad Wodskow" wrote:
> I have a row of 24 cells, some are blank and others ...
Started 4 days, 17 hours ago (2009-11-18 04:30:00)
by redstar_ external usenet poster
I have an investment spreadsheet that shows the qunaity I bought or sold, buy
date, buy price, sell date, and sell price. I am trying to calcualte the
average buy price for the investments. Unfortunatley when you sell it
includes a buy price as well. I need to exclude these cells from the
average. Below is the info.
Col C Col D Col E Col F Col G
...
Started 1 week, 1 day ago (2009-11-14 18:26:00)
by T. Valko
Works OK for me.
A1 = 1
A2 = 3
A3 = 5
Select A1:A3 then drag down as needed
A1 = 2
A2 = 4
A3 = 6
Select A1:A3 and drag down as needed
--
Biff
Microsoft Excel MVP
"alsaleh" > wrote in message
...
> Hi,
> I inserted numbers 1,2 and 3, respectively in three rows. I then
> dragged till row 10 and MS-Excel just filled out the rest of the
> numbers till 10.
> Now, ...
Started 1 week, 2 days ago (2009-11-12 22:40:00)
by Eva
Insert/Hyperlink/ and then choose from Look in the spreadsheet and then type
the sheet name and cell addres
example
C:\Book1.xls\Sheet1!A1
Click yes if helped
Eva
"Bill Kuunders" wrote:
> is there a way to hyperlink from one workbook to a specific worksheet in
> >>another workbook.
>
>
> Gord Dibben had this as a solution which works fine.
>
> Private Sub ...
Started 5 days ago (2009-11-17 21:10:00)
by Trevor Shuttleworth
Mike
For the average, it might be useful to have a range of "helper" cells to aid
the calculation. This wouldn't necessarily replace the existing cells.
For example, if you used the range A5 to BZ5, the (average) formula would
be:
=IF(ISERROR(SUM(A5:BZ5)/COUNTIF(A5:BZ5,"<>")),0,S UM(A5:BZ5)/COUNTIF(A5:BZ5,">0"))
Regards
Trevor
"Mike" > wrote in message
...
>I am trying...
Started 1 week, 1 day ago (2009-11-14 12:04:00)
by muddan madhu
Try this
=COUNTIF( INDIRECT("["&N1&"]"&"Sheet1!$C:$C"),C5)
On Nov 14, 2:56*pm, puiuluipui >
wrote:
> Hi, i have a number in "C5" and i need to search for this number in another
> workbook. I need to search only in column C:C.
> But i need an indirect function because the name of book2 will change every
> week. I will put in "N1" the name of other workbook.
>
> Can this be done?
...
Started 1 week, 1 day ago (2009-11-14 04:41:00)
by KeithD external usenet poster
I would like to know how to create a "To-Date" average. For example, lets say
I have 3 dates:
Nov 1
Nov 2
Nov 3
and I have numerical values for each date:
Nov 1 | 100
Nov 2 | 106
Nov 3 | 88
How could I get an "to-date" average where it will average every number up
to that number together. For example, the aveage that would display to the
right of Nov 1 is 100 [100/1], to ...
|
|