|
More site info...
microsoft.public.excel.misc | Forum profile
|
|
Forum profile page for microsoft.public.excel.misc on http://www.microsoft.com/communities/newsgroups....
This report page is the aggregated overview from a single forum: microsoft.public.excel.misc, located on the Message Board at http://www.microsoft.com/communities/newsgroups....
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "microsoft.public.excel.misc" on the Message Board at http://www.microsoft.com/communities/newsgroups... is also shown in the following ways:
1) Latest Active Threads
2) 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 forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on microsoft.public.excel.misc:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
445
|
1,710
|
5,024
|
|
Post:
|
1,150
|
4,310
|
14,465
|
|
|
microsoft.public.excel.misc Posting activity graph:
|
Top authors during last week:
user's latest post:
Current Region..Cntrl Asterick...
Published (2009-11-27 09:14:00)
Sorry, I am wrong as Bernard mentioned.. For the "problem" mentioned in your query....may be you dont have data in any of the adjacent cells . "Jacob Skaria" wrote: > You must be using XL2007. The short cut to select the current region around > the active cell has changed from Ctrl+ * in 2003 to Shift+Ctrl+* > > If this post helps click Yes > ---------------...
user's latest post:
Summing data in columns in...
Published (2009-11-27 03:51:00)
COUNTIF, not SUMIF From help for SUMIF: "Microsoft Excel provides additional functions that can be used to analyze your data based on a condition. For example, to count the number of occurrences of a string of text or a number within a range of cells, use the COUNTIF function. To have a formula return one of two values based on a condition, such as a sales bonus based on a specified sales amount, use the IF...
user's latest post:
fixed cell reference in...
Published (2009-11-26 11:21:00)
No such function to pre-select type of cell references. Only F4 during or after entry as others have posted. Or use macros to change a complete range of cells after entry. Example macro............. Sub Absolute() Dim Cell As Range For Each Cell In Selection If Cell.HasFormula Then Cell.Formula = Application.ConvertFormula _ (Cell.Formula, xlA1, xlA1, xlAbsolute) 'Or choose from below '(Cell.Formula, xlA1, xlA1,...
user's latest post:
Excel - New Instance in...
Published (2009-11-27 14:31:00)
Tools|Options|General|Uncheck "Ignore other applications" (xl2003 menus) --- or --- Close Excel and Windows Start Button|Run "C:\yourpathtoexcel2003\excel.exe" /unregserver then Windows Start Button|Run "C:\yourpathtoexcel2003\excel.exe" /regserver The /unregserver & /regserver stuff resets some of the windows registry to excel's factory defaults. JMay wrote:...
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:
How to avoid to underline a...
Published (2009-11-26 04:55:00)
Format > Style > Hyperlink > Modify Then customize to your heart's content.
user's latest post:
Difficult formula required. in...
Published (2009-11-26 10:29:00)
No worries, then! The solution I offer is dependent on column A only having one of those 4 values as legitimate entries, and column B having text of "Mon", "Tue" ... "Sun". I agree with your local Excel guru - darned difficult to build into a single nested formula, but if you break it out into several parts and then create a formula that deals with different parts of it, I...
user's latest post:
Shortcut key in...
Published (2009-11-26 16:27:00)
hi sorry, you wanted a short cut key. yes you can do that too. 2003 on the menu bar>tools>macros>macros. select your macro then click options. assign your custom shortcut key. not sure how to do that in 2007 yet. working on it. Regards FSt1 "FSt1" wrote: > hi > short answer no. > but you can record a macro that does that and attach the macro to a custom > icon....
user's latest post:
Consolidate Data in...
Published (2009-11-27 16:01:00)
Here is the basic idea for using DIR Sub FindFilesToChangeSAS()' Bare bones version to test for DIR Dim FN As String FN = Dir(ThisWorkbook.Path & "\*.*") Do Until FN = "" MsgBox FN 'Name of each file in the directory(folder) displayed 'Do what is desired with the workbook Loop End Sub
user's latest post:
Summing data in columns in...
Published (2009-11-27 03:34:00)
Hi, Try this =COUNTIF(A1:A20,"m") =COUNTIF(A1:A20,"f") Mike "ElGordo" wrote: > I have data in letter form: M=male and F= female. I have tried SUMIF but cant > get a total of aal the "M"s or"F"s in a column.What am I doing wrong as the > help pages dont ma ke it clear?
|
|
|
|
Latest active threads on microsoft.public.excel.misc::
Started 10 hours, 24 minutes ago (2009-11-29 02:04:00)
by MS-Exl-Learner
Select the data range and select Data>Text to Columns>Fixed Width>Next>Click
where do you want to seperate the data (i.e. Near to Number) >Next>Finish.
Then apply the Sorting from Data>>sort for the names.
Remember to Click Yes, if this post helps!
--------------------
(Ms- Exl-Learner)
--------------------...
Started 15 hours, 6 minutes ago (2009-11-28 21:22:00)
by Jacob Skaria
Try the below
=SUMPRODUCT((Y1: Y100<>"")/COUNTIF(Y1:Y100,Y1:Y10 0&""))
If cell Y1 is header then adjust the range as Y2:Y100
If this post helps click Yes
---------------
Jacob Skaria
"driller2" wrote:
> helllo again,
>
> i a have a "Y" column of date entry.
>
> Most of ...
Started 12 hours, 27 minutes ago (2009-11-29 00:01:00)
by muddan madhu
Sub permutations()
Dim I As Integer, J As Integer, Rng As Integer
Rng = Cells(Rows.Count, "B").End(xlUp).Row
J = 1
Range("A1").Select
Do Until ActiveCell.Value = ""
For I = 1 To Rng
Cells(J, " D").Value = "'" & ActiveCell & Cells(I, "B")
J = J + 1
Next I
ActiveCell.Offset(1, 0).Select
Loop...
Started 12 hours, 20 minutes ago (2009-11-29 00:08:00)
by Arceedee
Instead of a4 having "a3-a2" try this
=INT((A3-A2)*24)
this should get you started.
Try looking in the Excel Help pages under Multiply time.
"The Caterer" wrote:
> I am trying to make a simple schedule worksheet for a manger to use to
> calculate the time he schedules an employee to clock in and out and what it
...
Started 13 hours, 55 minutes ago (2009-11-28 22:33:00)
by Max
One thought - CORREL?
Eg: =CORREL(A2:A6,B2:B6)
would return the Correlation coefficient
of the two numeric series in A2:A6 and B2:B6
The closer it is to 1, the better the correlation between the 2 series
Voila? hit the YES below
Started 17 hours, 2 minutes ago (2009-11-28 19:26:00)
by Gary''s Student
Select the cells you want to convert and run this small macro:
Sub formulator()
For Each r In Selection
r.Formula = "=" & Replace(r.Value, "x", "*")
Next
End Sub
Macros are very easy to install and use:
1. ALT-F11 brings up the VBE window
2. ALT-I
ALT-M opens a fresh module
3. paste ...
Started 17 hours, 52 minutes ago (2009-11-28 18:36:00)
by JLatham
Is it not in the list when you use
Tools --> Add-Ins?
"linda wireless" wrote:
> I am trying to install the analysis toolpak addin. I was able to find it in
> the library but cant figure out how to install. i click on it but it doesnt
> seem to install any thing and i would assume it would show up in the addin
> ...
Started 1 day, 5 hours ago (2009-11-28 07:17:00)
by Gary''s Student
You don't need Excel for this, just a paper and pencil.
There are only four possible triplets to be considered:
word1,word2,word3
word1,word2,word4
word1,word4,word3
word4,word2,word3
Each triplet has only 6 posible combinations:
word1,word2,word3
word1,word3,word2
word2,word1,word3
...
|
|
Hot threads for last week on microsoft.public.excel.misc::
Started 1 week 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 3 days, 11 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 5 days, 3 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 5 days, 6 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 5 days 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 4 days, 3 hours ago (2009-11-25 08:57:00)
by Gary''s Student
With your text in A1, use:
=RIGHT(A1,20)
Started 3 days, 2 hours ago (2009-11-26 09:39:00)
by JLatham
Some questions:
#1 - Can column A have anything in it other than V, X, Y and/or Z ? i.e.,
could it have B or R or something else?
#2 - exactly what's in column B? Is it text as "Sat" or "Saturday", or is
it actually a date that you've formatted to show the day of week for?
I'm not saying I can do this, but knowing this ...
Started 4 days, 23 hours ago (2009-11-24 12:41:00)
by trip_to_tokyo
Chip, this is what you seem to be saying:-
InvoiceAmount InvoiceNumber CustomerPays
1 1,000
2 2,000
3 3,000 3
4 4,000
5 5,000
If customer pays 3 it could go against either Invoice Numbers 1,000 and
2,000 or just 3,000 alone so I think that the answer to your ...
Started 4 days, 5 hours ago (2009-11-25 07:27:00)
by Jacob Skaria
You can use the 'Convert Text to Columns Wizard to convert the dates
--Select the range of dates which needs to be corrected.
--From menu Data>'Text to Columns' will populate the 'Convert Text to Columns
Wizard'.
--Hit Next>Next will take you to Step 3 of 3 of the Wizard.
--From 'Column Data format' select ...
Started 4 days, 7 hours ago (2009-11-25 05:04:00)
by JLatham
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 ...
|
|
Size: 1,161 bytes
