|
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:
|
498
|
1,703
|
5,069
|
|
Post:
|
1,260
|
4,288
|
14,566
|
|
|
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:
Insert Picture from File -...
Published (2009-11-25 23:43:00)
---Try the below Sub Macro1() Dim strFile As String strFile = "path and filename here""" 'If you are looking at inserting to the sheet ActiveSheet.Pictures.Insert (strFile) 'OR Insert the log as a page header.. ActiveSheet.PageSetup.RightHeaderPicture.Filename = strFile End Sub ----If you are using the web interface.. -For this question; on the right panel where you see the question...
user's latest post:
what is xlxs? in...
Published (2009-11-25 15:31:00)
Do you really mean xlxs? If it were xlsx, it would be Excel 2007. Excel 2007 compatibility pack for Excel 2003 users: http://support.microsoft.com/kb/923505 Download: http://www.microsoft.com/downloads/details.aspx?FamilyID=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en
user's latest post:
Mail Merge in...
Published (2009-11-25 17:41:00)
Select A2 and scroll down and across to select the range of data. Give this range a name like mymaildata. Word's mailmerge will accept that name in "select a table" See these sites for very good help with mailmerge. http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm Gord Dibben MS Excel...
user's latest post:
vba converters in...
Published (2009-11-25 17:46:00)
Look here: http://support.microsoft.com/kb/926430/ Chejo wrote: > > I'm obtaininig an error that requires a "VBA converter" when I load an old > add-in in Excel 2007. How could I fix this problem?
user's latest post:
Macro for Search in...
Published (2009-11-25 10:46:00)
(after writing macro) Doh! To expand on Dave's solution, you could even use the Advanced AutoFilter since you have criteria setup using the same headers. Check out Debra's article: http://www.contextures.com/xladvfilter01.html
user's latest post:
rows and colums in...
Published (2009-11-20 11:26:00)
Hide them lizfox wrote: > I'm a new user on 2003 excel. How do i change the amount of cells. I need > ten down only .
user's latest post:
How to count days in excel in...
Published (2009-11-25 12:16:00)
One way... =SUMPRODUCT(--(MONTH(A1:A25)=n)) Where n = the month number from 1 to 12. Note that empty cells will evaluate as month number 1 (Jan). To account for that: =SUMPRODUCT(--(A1:A25<>""),--(MONTH(A1:A25)=n))
user's latest post:
Matching Data in...
Published (2009-11-25 05:04:00)
Here's a macro that will do the job for you. Just be sure the sheet with the data on it is the selected sheet when you run it. To put it into place, open the workbook and press [Alt]+[F11] to open the VB Editor and then choose Insert --> Module. Copy the code below and paste it into the code module shown. Change the definitions of the Const values to match the layout of your worksheet and then close the VB Editor. Run...
user's latest post:
Converting 123 CR & 4567 DB...
Published (2009-11-25 11:19:00)
Select the cells you want to convert and run: Sub FixThem() For Each r In Selection v = r.Value vn = Left(v, Len(v) - 3) If Right(v, 2) = "DB" Then r.Value = -vn Else r.Value = vn End If Next End Sub
user's latest post:
How do I create a macro to...
Published (2009-11-25 06:21:00)
Sub insertsamelinerow() Rows(ActiveCell.Row).Copy Rows(ActiveCell.Row + 1).Insert Application.CutCopyMode = False End Sub
|
|
|
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, 10 hours ago (2009-11-26 04:26:00)
by Gary''s Student
Severl things at issue:
1. VLOOKUP() is a great way to grab data, but it only gets one value. To
get more than one value, see:
http://office.microsoft.com/en-us/excel/HA01226038 1033.aspx
2. The usual method is to use AutoFilter:
a. set the filter
b. set the criteria ( hides or reveals rows)...
Started 1 day, 7 hours ago (2009-11-26 07:06:00)
by Dave Peterson
Debra Dalgleish has lots of notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble
Enyaw wrote:
>
> Is there any way to lookup values from another worksheet. The ...
Started 1 day, 7 hours ago (2009-11-26 07:06:00)
by Dave Peterson
Pivottables work with numbers (sum of, max of, average of). They won't work
with text.
And I don't understand how Name 1 can have both course 1 and course 4 as its
first choice. I'm guessing that this is an error in your post--each person can
have at most one first choice, at most one 2nd choice, ...
If that's true, then ...
Started 1 day, 8 hours ago (2009-11-26 06:46:00)
by Bernard Liengme
In A1:A7 I have: Mon, Tue, ....
In B1:B7 I have $ amounts: 20,10,50,10,20....
In D1 I have the amount in hand: 85
I selected B1:B7 and in Conditional Formatting,
used Formula Is =SUM($B$1:B1)<=$D$1 and set a green fill
This seems to do what you asked for
The difference between COUNT and SUM is critical
best wishes
Started 1 day, 10 hours ago (2009-11-26 04:39:00)
by MS-Exl-Learner
Try this in E4 Cell
=IF(OR(D4="YES",D5="YES",D6="YES"),G1,IF(AND(D4 ="NO",D5="NO",D6="NO"),G2,IF(AND(D4="",D5="",D6="" ),"","Value is not Matching the Criteria")))
If this post helps, Click Yes!
--------------------
(Ms- Exl-Learner)
--------------------
"Tel" wrote:
> I'm trying to write an ...
Started 1 day, 9 hours ago (2009-11-26 04:55:00)
by Gary''s Student
Format > Style > Hyperlink > Modify
Then customize to your heart's content.
Started 1 day, 11 hours ago (2009-11-26 03:11:00)
by Jacob Skaria
Why dont you merge the .csv files together using MS- DOS copy command.
--Copy all .csv files to a single folder (say c:\temp\)
--From command line type the command
copy c:\temp\*.csv c:\All.csv/b
--Open c:\All.csv from Excel
If this post helps click Yes
---------------
Jacob Skaria
"Mary Ann" ...
Started 1 day, 11 hours ago (2009-11-26 03:05:00)
by Pete_UK
You can't remove them, as the sheet is a fixed size. However, you can
hide them. Select the rows below the data then click on Format | Rows
| Hide then click OK.
Hope this helps.
Pete
On Nov 26, 10:01Â am, alun.re...@bamnuttall.co.uk
<alun.re...@bamnuttall.co.uk@discussions.microso ft.com> wrote:
> I have some...
Started 1 day, 13 hours ago (2009-11-26 01:16:00)
by Jacob Skaria
In B1
=IF(A1<TODAY(),"Please pay",A1-TODAY())
If this post helps click Yes
---------------
Jacob Skaria
"puiuluipui" wrote:
> Hi, i need something like this in B1: " =today-A1 ", but i need to display a
> message if the date in A1 has past.
> Ex 1:
> A1= 08.12.2009
> B1= 12
> The ...
|
|
Hot threads for last week on Discussions in microsoft.public.excel.misc:
Started 5 days, 4 hours ago (2009-11-22 10:11:00)
by Don Guillett
Your example is not clear. You do not show a before/after
I am a retired Reg Mgr for ING and held a series 7.
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear ...
Started 1 week ago (2009-11-20 02:23:00)
by MS-Exl-Learner
What is the values you are having in D12 to D22?
--------------------
(Ms- Exl-Learner)
--------------------
"VivienW" wrote:
> Hello,
>
> Does anyone know why Excel sometimes give an incorrect result when adding
> the contents of cells? It may only be 1p out but even if I increase the...
Started 1 day, 13 hours ago (2009-11-26 01:16:00)
by Jacob Skaria
In B1
=IF(A1<TODAY(),"Please pay",A1-TODAY())
If this post helps click Yes
---------------
Jacob Skaria
"puiuluipui" wrote:
> Hi, i need something like this in B1: " =today-A1 ", but i need to display a
> message if the date in A1 has past.
> Ex 1:
> A1= 08.12.2009
> B1= 12
> The ...
Started 1 week, 1 day ago (2009-11-19 03:46:00)
by David Biddulph
No, you are not on the right track.
AND(A25<0) is just the same as (A25<0), as you haven't told Excel what you
want to AND with (A25<0). It isn't clear what you were trying to do.
If you need Excel help on the syntax of the AND function, look up AND in
Excel help.
You've also got a number of unnecessary parentheses, such as ...
Started 1 week, 2 days ago (2009-11-18 12:04:00)
by Paul C
The issue is that your payment amount is calculating to 89.215 not 89.22 and
is only being displayed as 89.22.
If you change your payment formula to Round(k16/k17,2) you will get a pament
amout of exactly 89.22 and a final payment of 89.19
Started 3 days, 5 hours ago (2009-11-24 09:18:00)
by Paul C
The formula looks fine, I suspect the problem is the format in Column C
Try a simple test and just add 1 to C2 =c2+1
if this gives you a #value error then you have found your problem.
My guess would be that the data in Column C is some kind of text and not a
number.
Started 3 days, 9 hours ago (2009-11-24 05:41:00)
by David Biddulph
=SUMPRODUCT(((YEAR(A6: A100)=2009)*(MONTH(A6:A100)> =7))+((YEAR(A6:A100)=2010)*(MONTH(A6:A100)<=6))*(B 6:B100="u")*C6:C100)
or
=SUMPRODUCT((TEXT(A6:A100,"yyyymm")>="200907")*( TEXT(A6:A100,"yyyymm")<="201006")*(B6:B100="u")*C6 :C100)
Started 3 days, 2 hours ago (2009-11-24 12:17:00)
by JLatham
The reason the cells still contained information was, as you've no doubt
figured out, because macros were disabled, so the code couldn't run to clear
the cells.
You don't want people to have to deal with macro warnings, well, it's hard
to get around that little thing. You could tell your users to set Macro
Security to LOW ...
Started 2 days, 5 hours ago (2009-11-25 08:57:00)
by Gary''s Student
With your text in A1, use:
=RIGHT(A1,20)
Started 1 week, 2 days ago (2009-11-18 07:38:00)
by RonaldoOneNil
=IF(G25>H25,H25/G25+1,IF(G25=H25,H25/G25,H25/G25-1 ))
"WildWill" wrote:
> I have G25=60 and H25=30, where a person was given 60 days to perform a task
> and he ended up performing the task in 30 days. Thus he has "over-performed"
> and scores 150% for that task.
>
> If he completed the task in 60 days, I would have ...
|
|