Forum: Worksheet Functions
June 6th, 2010, 02:16 PM Posted to microsoft.public.excel.worksheet.functions
|
|
Replies: 5
Views: 1,931
Count function seeing formulas as data
Think COUNTIF is what you're after, not COUNT
Try something like this:
=COUNTIF(D2:F4,"=2")
which returns the number of cells within D2:F4 containing numbers greater
than or equal to 2. Adapt the...
|
|
Forum: General Discussion
June 6th, 2010, 04:18 AM Posted to microsoft.public.excel.misc
|
|
Replies: 4
Views: 690
|
|
Forum: Worksheet Functions
June 6th, 2010, 03:24 AM Posted to microsoft.public.excel.worksheet.functions
|
|
Replies: 4
Views: 3,881
Select a worksheet
Assuming your vlookup formula as posted is in cell X1,
you could place this in say, Y1:
=IF(X1"Error!!!!!!!",HYPERLINK("#"&CELL("address",INDIRECT("'"&X1&"'!A1")),X1),"")
to produce a clickable...
|
|
Forum: New Users
June 6th, 2010, 02:58 AM Posted to microsoft.public.excel.newusers
|
|
Replies: 23
Views: 7,353
' The Day After ???
So, get newsreader software and don't access Usenet by Web links
But that's easier said than done. Not possible in office. Even Google/groups
are barred.
Only access to MS webpages are...
|
|
Forum: New Users
June 5th, 2010, 12:04 PM Posted to microsoft.public.excel.newusers
|
|
Replies: 23
Views: 7,353
The Day After ???
That can't be true. I'm looking at this from a pure simple user viewpoint. I
don't know how it all works. Right now I don't have any assurance what to
expect when MS finally kills/switches off its...
|
|
Forum: Worksheet Functions
June 4th, 2010, 02:21 PM Posted to microsoft.public.excel.worksheet.functions
|
|
Replies: 6
Views: 598
AMVERAGIF Condition
Don't know the new function AVERAGEIF,
but indicatively something like this array-entered should do it:
=average(if((Cond1)*(Cond2),Range))
--
Max
Singapore
---
"rwtrader" wrote:
I am having...
|
|
Forum: New Users
June 3rd, 2010, 11:43 PM Posted to microsoft.public.excel.newusers
|
|
Replies: 23
Views: 7,353
The Day After ???
Below is an extract 2 liner from MS' message "Final Reminder ..."
So .... what does it mean exactly?
When will this Happen?
Effective June 1, 2010 this newsgroup will be closed
|
|
Forum: General Discussion
June 3rd, 2010, 02:55 PM Posted to microsoft.public.excel.misc
|
|
Replies: 8
Views: 686
Top value
Here's a pure non-array formulas play which will achieve your multiple
objectives, viz: extract unique names, total up scores per name then
auto-sort in descending order with tiebreaks (to cater...
|
|
Forum: Worksheet Functions
June 2nd, 2010, 09:20 PM Posted to microsoft.public.excel.worksheet.functions
|
|
Replies: 1
Views: 512
Source and Destination
Assume source data running in A2 down,
and in B2 down you will mark it as: C, S, etc
In say, E2: =IF(OR(B2={"C","S"}),ROW(),"")
In F2:...
|
|
Forum: Worksheet Functions
June 2nd, 2010, 01:19 PM Posted to microsoft.public.excel.worksheet.functions
|
|
Replies: 10
Views: 1,034
Drop Down Lists 2007
Roger, no prob .. as we got the answer from Mike g
--
Max
Singapore
---
"Roger Govier" wrote:
Sorry, Gord and Max
Didn't read the bit about Paste List.
Fortunately Mike read the question...
|
|
Forum: Worksheet Functions
June 2nd, 2010, 01:15 PM Posted to microsoft.public.excel.worksheet.functions
|
|
Replies: 10
Views: 1,034
Drop Down Lists 2007
Aha! so that's where its hidden, Gord.
My thanks to Mike as well
--
Max
Singapore
---
"Gord Dibben" wrote:
Thank you Mike.
"Use in Formula" is grayed out on Bar if no names have been...
|
|
Forum: New Users
June 1st, 2010, 09:44 PM Posted to microsoft.public.excel.newusers
|
|
Replies: 5
Views: 2,940
|
|
Forum: Worksheet Functions
June 1st, 2010, 09:24 PM Posted to microsoft.public.excel.worksheet.functions
|
|
Replies: 5
Views: 783
|
|
Forum: New Users
June 1st, 2010, 09:13 PM Posted to microsoft.public.excel.newusers
|
|
Replies: 1
Views: 2,674
|
|
Forum: Worksheet Functions
June 1st, 2010, 09:07 PM Posted to microsoft.public.excel.worksheet.functions
|
|
Replies: 2
Views: 526
Remove columns containing all zeros
A simple formula way to flag it, use COUNTIF
Eg in A1: =COUNTIF(A2:A5,0)=4
Copy across. Cols to be deleted will be TRUE
--
Max
Singapore
---
"Nora_GG" wrote:
How can I create a macro or...
|
|
Forum: Worksheet Functions
June 1st, 2010, 09:00 PM Posted to microsoft.public.excel.worksheet.functions
|
|
Replies: 10
Views: 1,034
Drop Down Lists 2007
Roger, a short Q. where the deuce is InsertNamePaste List in xl2007? where
we can immediately paste a list of defined names (to check for example).
Thanks
--
Max
Singapore
---
|
|
Forum: Worksheet Functions
June 1st, 2010, 08:51 PM Posted to microsoft.public.excel.worksheet.functions
|
|
Replies: 5
Views: 783
modifying T. Valko ws function
Think there's probably a simpler way to get whatever you want going with a
helper col or two. Try re-explaining your basic sheet set-up & objectives,
show some sample data and expected results.
--...
|
|
Forum: Worksheet Functions
June 1st, 2010, 08:46 PM Posted to microsoft.public.excel.worksheet.functions
|
|
Replies: 3
Views: 577
IF formula question
One way to flag it
In N1: =IF(AND(J1="R",OR(L1={3221,3223})),"x","")
Copy down. Insert a new 1st row, apply autofilter, filter out the "x".
--
Max
Singapore
---
"charlie" wrote:
I need to write a...
|
|
Forum: New Users
May 31st, 2010, 11:06 PM Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|
Replies: 20
Views: 6,102
The last day
Will google groups be "picking up" the new forum's archives in due course?
|
|
Forum: Worksheet Functions
May 31st, 2010, 11:06 PM Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|
Replies: 20
Views: 1,205
The last day
Will google groups be "picking up" the new forum's archives in due course?
|
|
Forum: General Discussion
May 31st, 2010, 11:06 PM Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|
Replies: 20
Views: 1,287
The last day
Will google groups be "picking up" the new forum's archives in due course?
|
|
Forum: Worksheet Functions
May 31st, 2010, 06:54 AM Posted to microsoft.public.excel.worksheet.functions
|
|
Replies: 2
Views: 657
|
|
Forum: Worksheet Functions
May 31st, 2010, 04:47 AM Posted to microsoft.public.excel.worksheet.functions
|
|
Replies: 6
Views: 1,043
|
|
Forum: General Discussion
May 31st, 2010, 04:39 AM Posted to microsoft.public.excel.misc
|
|
Replies: 1
Views: 272
|
|
Forum: Worksheet Functions
May 31st, 2010, 02:52 AM Posted to microsoft.public.excel.worksheet.functions
|
|
Replies: 6
Views: 1,043
Need Help with Sumif Function including dates
well, if you want to use SUMIF to get the sum of col B for dates in col A in
Apr 2010, this seems to work fine:
=SUMIF(A:A,"="&--"1 Apr 2010",B:B)-SUMIF(A:A,"="&--"1 May 2010",B:B)
Care should be...
|
