|
More site info...
General Discussion | Forum profile
|
|
Forum profile page for General Discussion on http://www.officefrustration.com.
This report page is the aggregated overview from a single forum: General Discussion, located on the Message Board at http://www.officefrustration.com.
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 "General Discussion" on the Message Board at http://www.officefrustration.com 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 General Discussion:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
568
|
2,238
|
6,681
|
|
Post:
|
1,434
|
5,851
|
20,485
|
|
|
General Discussion Posting activity graph:
|
Top authors during last week:
user's latest post:
How do I refer to a...
Published (2009-11-07 17:32:00)
It is not clear to me what you want to do. Can you post a formula and desribe what you want to do with it? Maybe this UDF? Function EvalCell(RefCell As String) Application.Volatile EvalCell = Evaluate(RefCell) End Function =evalcell(cellref) Which does nothing more than return the value from the formula in cellref. Just as easy to enter =cellref Evalcell function is handy to return a value from a string such as 1+2+3 Gord Dibben MS Excel MVP...
user's latest post:
Automatic data entry problem in...
Published (2009-11-08 01:16:00)
It's called autocomplete. In xl2003 menus: Tools|Options|Edit Tab|Uncheck "Enable Autocomplete for cell values" TONY wrote: I set up a list to automatically plug in city names when i typed the first few letter. However, now it does it for every sheet, new or old and I don't need it to. I can't remember the name of the function and have scoured help (local and on-line) trying to find the feature - no luck. Can...
user's latest post:
Different cells that need to sum...
Published (2009-11-08 15:54:00)
--Copy the IF() formula down.. --Select the range and set the data validation...Slight change in the formula =COUNT($A1:$F1)3 If this post helps click Yes --------------- Jacob Skaria "Cbdavis" wrote: That worked Great ! What if I want to continue that formula in the next rows below that throughout the sheet? "Jacob Skaria" wrote: --You can try the below formula. (all in one line)...
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 "Vince" wrote: How do I average a range of cells that are blank until data is entered later with out the destination cell returning a #div/o!...
user's latest post:
sumif and left
Published (2009-11-06 16:10: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 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:
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:
getting data from a range in...
Published (2009-11-07 15:25:00)
Try it and see. Post back your results -- Gary''s Student - gsnu200908 "Mainer" wrote: can i just put the workbook name if the workbook is in the same folder? "Gary''s Student" wrote: Something like: =SUM('C:\Documents and Settings\Owner\My Documents\Book2.xls'!alpha) Where alpha is a Named Range -- Gary''s Student - gsnu200908 "Mainer" wrote:...
user's latest post:
Multiplying 2 columns with IF
Published (2009-11-06 15:36:00)
=IF(G2="letter",C2*E2,IF(G2="tabloid",C2*E2*2,"ans wer undefined")) -- David Biddulph "paulab" wrote in message ... Can someone help me out with a formula? I'm trying to get a running total of impressions from data in two columns with a variable. If column g=letter than mulitply column C with column E and If column g=tabloid multiply column C with column E *2
user's latest post:
wrapping text in cell
Published (2009-11-05 23:41:00)
No. gachubach wrote: Can I reduce the amount of space between wrapped text lines withing a cell? (Reduce the leading?)
|
|
|
|
Latest active threads on General Discussion::
Started 2 days, 14 hours ago (2009-11-07 21:27:00)
by Don Guillett
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 explanation of what you want
4. You send before/after examples and expected results.
Also show your efforts to date
--
Don Guillett
Microsoft MVP Excel
...
Started 1 day, 15 hours ago (2009-11-08 19:55:00)
by Per Jessen
Hi
Just enlarge the range to as many rows as you think you will need:
=COUNTIF(P2:P1000,"x")
Regards,
Per
"Verne" skrev i meddelelsen
...
I am using a count if formula =COUNTIF(P2:P25,"x") - everytime I add a new
row, that row is not included in the formula. What can I do so it is
included. Right now, I have to add the row to the formula manaually. Thank
you for your ...
Started 1 day, 16 hours ago (2009-11-08 19:02:00)
by Bernard Liengme[_2_]
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. ...
Started 2 days, 5 hours ago (2009-11-08 05:56:00)
by Jacob Skaria
--You can try the below formula. (all in one line)
=IF(COUNT(A1:B1)=2,A1*B1,IF(COUNT(C1 1)=2,C1*D1,
IF(COUNT(E1:F1)=2,E1*F1,0)))
--Also to make sure you have only two numbers entered you can set data
validation for this range.. Select A1:F1 . From menu DataValidationselect
'Custom' and copy paste the below formula.
=COUNT($A$1:$F$1)3
If this post helps click Yes
---------------...
Started 2 days, 14 hours ago (2009-11-07 21:30:00)
by Don Guillett
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
Started 2 days ago (2009-11-08 11:34:00)
by Jacob Skaria
Hi George
'Sum of sales in ColB for the month March 2009
=SUMPRODUCT((TEXT(A1:A100,"mmyyyy")="032009")*B1: B 100)
'OR with query date in cell reference say(F1)
=SUMPRODUCT((TEXT(A1:A100,"mmyyyy")=TEXT(F1,"mmyy y y"))*B1:B100)
If this post helps click Yes
---------------
Jacob Skaria
"George A. Jululian" wrote:
Hi all,
i have table as below
A B C D E F G
...
Started 1 day, 23 hours ago (2009-11-08 11:45:00)
by Ron Rosenfeld
On Sun, 08 Nov 2009 00:38:57 -0800, Nasr Mostafa wrote:
Hi What is the formula to get the following
Mark Points
90 & more 4
85 & less 90 3.7
82.5 & less 85 3.3
77.5 & less 82.5 3
75 & less 77.5 2.7
67.5 & less 75 2.3
67.5 & less 72.5 2
65 & lees 67.5 1.7
62.5 & less 65 1.3
60 & less 62.5 1
less 60...
Started 1 day, 23 hours ago (2009-11-08 11:42:00)
by Arceedee
The answer to both your points can be found in the MS help. Search for
"Protect worksheet elements"
The first point is quite simple. In the ribbon select view and in the "Show
hide" area simply untick Formula Bar. The other is quite lengthy so try the
help solution. Basically what you do is select all to be locked and then
unlock those cells that you will allow editing rights to. ...
Started 2 days, 14 hours ago (2009-11-07 21:10:00)
by Lars-Åke Aspelin[_2_]
On Sat, 7 Nov 2009 11:48:01 -0800, Lainyb
wrote:
I am trying to pick information on salary spinal column points within certain
grades. I want to look at the current scp in cell J2 and then get the next
scp for that grade. The grade information is in cell I2.
eg if I2 is grade 2 and J2 is SCP 11 then put the next SCP in cell T2 (13).
This would change until the top of the scale is...
|
|
Hot threads for last week on General Discussion::
Started 1 week, 1 day ago (2009-11-01 11:55:00)
by George A. Jululian[_2_] external usenet poster
Dear All,
I have one colum and 30 rows
and i want to put all in one cell and i am using
A1&A2&A3
please advice if there is any other soultion
regards
Started 1 week, 1 day 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 5 days, 23 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
with the ...
Started 6 days, 20 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, 6 hours ago (2009-11-05 04:42:00)
by Dave Peterson
You can, but wouldn't it be safer to use a formula in (say) an adjacent cell:
=F9*2
But if you want to try a macro...
Rightclick on the worksheet tab that should have this behavior. Select View
code. Paste this into the newly opened code window:
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
With Me.Range("F7")
If Intersect(Target, .Cells) Is ...
Started 5 days, 16 hours ago (2009-11-04 19:04:00)
by Bob I
=UPPER(ref)
Hok Wong wrote:
If I have an excel document where most of the text within the cells have been
written in lowercase, is there an easy way to change all the text into
uppercase? I thought i'd seen an option for that years ago, but typically,
now i want to use it, i can't find it.
Started 4 days, 21 hours ago (2009-11-05 14:26: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 week, 1 day ago (2009-11-01 16:04:00)
by rainyday external usenet poster
I wish to sum the values in a column that meets certain critieria such as
greated than 35%. I can write the formula so it works but I have been unable
to enter an absolute cell reference or range name in the criteria of the
formula in order to be able to vary the percentage criteria to be added.
Formula =sumif(percentage_hrs, "=35%", K15:K202)
I have had to copy the conditional ...
Started 1 week ago (2009-11-02 20:33:00)
by Gord Dibben
Alt + F11 to open VBE
ViewImmediate Window
Paste in Application.CommandBars("Ply").Enabled = True
then hit Enter
The "all of sudden" part prolly came from some code you ran.
Gord Dibben MS Excel MVP
On Mon, 2 Nov 2009 11:09:01 -0800, blanch2009
wrote:
All of a sudden I have no right click on my sheet tabs. The sheet or even
the workbook is not protected ...
Started 6 days, 10 hours ago (2009-11-04 00:55:00)
by Don Guillett
Look in the help index for SUMIF. Should be able to do it using col a as the
criteria for col c total
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
|
|