A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 100
Search took 17.50 seconds.
Search: Posts made by: Max
Forum: Worksheet Functions June 6th, 2010, 02:16 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 5
Views: 1,705
Posted By Max
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: 504
Posted By Max
formula for moving information from one sheet to another sheet

You can use formulas to achieve the desired functionality in the new "blank"
sheet, dynamically

Assume your source data in Sheet1, in A2 down
In B2 down is where you will mark "x"

In your new...
Forum: Worksheet Functions June 6th, 2010, 03:24 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 4
Views: 3,006
Posted By Max
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: 5,673
Posted By Max
' 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: 5,673
Posted By Max
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: 401
Posted By Max
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: 5,673
Posted By Max
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: 498
Posted By Max
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: 335
Posted By Max
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: 774
Posted By Max
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: 774
Posted By Max
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,190
Posted By Max
What Excel formula converts hourly wage to annual salary

Think there's no such single function. You need to DIY. How would you
calculate it by hand? Explain it fully, step by step. This increases your
chances of getting help with the formula.
--...
Forum: Worksheet Functions June 1st, 2010, 09:24 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 5
Views: 590
Posted By Max
modifying T. Valko ws function

Sorry I'm out, think its too complex for me.
Forum: New Users June 1st, 2010, 09:13 PM Posted to microsoft.public.excel.newusers
Replies: 1
Views: 1,995
Posted By Max
#VALUE! result when using defined name in formula

That means there's a #VALUE! error in your sum range. Go check & clean it up,
the sum should work fine
--
Max
Singapore
---
"Tacrier" wrote:
I am learning how to name cells and use these...
Forum: Worksheet Functions June 1st, 2010, 09:07 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 387
Posted By Max
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: 774
Posted By Max
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: 590
Posted By Max
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: 425
Posted By Max
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: 4,563
Posted By Max
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: 753
Posted By Max
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: 966
Posted By Max
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: 517
Posted By Max
Excel formula to incrementally increase a value by 1 every 365 day

With startdates in A2 down
put in B2: =DATEDIF(A2,TODAY(),"y")
Copy down
--
Max
Singapore
---
"ScheduleMyAppointmentNow_Com" wrote:
I need help with correct formula to take a starting date from...
Forum: Worksheet Functions May 31st, 2010, 04:47 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 6
Views: 879
Posted By Max
Need Help with Sumif Function including dates

Note the careful avoidance of having to specify the last day of the month
(the "ugh" moment) in the earlier SUMIF expression g
--
Max
Singapore
---
Forum: General Discussion May 31st, 2010, 04:39 AM Posted to microsoft.public.excel.misc
Replies: 1
Views: 252
Posted By Max
How to clear up useless content within worksheet?

One better? way is NOT to copy/paste the entire sheet but only the target
areas.
To clean-up, think you'd need to select all cols to the right of your target
area*, then DELETE these. Then do...
Forum: Worksheet Functions May 31st, 2010, 02:52 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 6
Views: 879
Posted By Max
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...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 01:08 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 OfficeFrustration.
The comments are property of their posters.