|
More site info...
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.
|
|
|
|
|
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:
|
|
|
BoardReader Authority Badge code for Discussions in microsoft.public.excel.misc (http://www.microsoft.com/communities/newsgroups...)
|
|
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.
|
|
|
|
|
Discussions in microsoft.public.excel.misc posting activity graph:
|
|
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:
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...
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
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,...
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: > >...
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...
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...
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...
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. .
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! --------------------...
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:
|
|
Top 10 forums on Discussions in microsoft.public.excel.misc:
|
|
|
|
Latest active threads on 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
> ...
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?
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...
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 ...
|
|
Hot threads for last week on Discussions in 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 ...
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,...
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...
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
> ...
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 ...
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?
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...
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!*...
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 ...
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...
|
|
Size: 970 bytes
