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 2.02 seconds.
Search: Posts made by: Joe User[_2_]
Forum: Worksheet Functions May 6th, 2010, 12:50 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 1
Views: 69
Posted By Joe User[_2_]
Present Value of equal payments of a future value

"Quentin N" wrote:
How do I find the present value at the end of each
year for the vested stock options and have my
present value plus interest earned equal my future
value.

I think you are...
Forum: General Discussion May 6th, 2010, 12:15 AM Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Replies: 61
Views: 1,543
Posted By Joe User[_2_]
Microsoft Responds to the Evolution of Online Communities

"T. Valko" wrote:
I will never again reply to any of your posts and I
will not acknowledge any of your replies to my posts.


Talk about overreaction!


Not sure if...
Forum: Worksheet Functions May 6th, 2010, 12:15 AM Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Replies: 22
Views: 581
Posted By Joe User[_2_]
Microsoft Responds to the Evolution of Online Communities

"T. Valko" wrote:
I will never again reply to any of your posts and I
will not acknowledge any of your replies to my posts.


Talk about overreaction!


Not sure if...
Forum: General Discussion May 5th, 2010, 11:34 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 337
Posted By Joe User[_2_]
Average Daily Balance

"Brian" wrote:
I have a spreadsheet with an opening balance and then multiple
rows of activtity (either deposits or withdrawls)

It would be better to maintain...
Forum: Worksheet Functions May 5th, 2010, 10:44 PM Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Replies: 22
Views: 581
Posted By Joe User[_2_]
Microsoft Responds to the Evolution of Online Communities

I wrote:
"Jef Gorbach" wrote:
So will google groups still access this forum
once it relocates??

That is not really possible, well at least not
without significant...
Forum: General Discussion May 5th, 2010, 10:44 PM Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Replies: 61
Views: 1,543
Posted By Joe User[_2_]
Microsoft Responds to the Evolution of Online Communities

I wrote:
"Jef Gorbach" wrote:
So will google groups still access this forum
once it relocates??

That is not really possible, well at least not
without significant...
Forum: Worksheet Functions May 5th, 2010, 08:55 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 9
Views: 111
Posted By Joe User[_2_]
Count If equals x AND y

"Nadine" wrote:
Sum all the amounts in column E if Col A=1
AND Col B=No.

First you say you want to sum column D; now you say column E. But really,
what difference does it...
Forum: General Discussion May 5th, 2010, 08:10 PM Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Replies: 61
Views: 1,543
Posted By Joe User[_2_]
Microsoft Responds to the Evolution of Online Communities

"Jef Gorbach" wrote:
So will google groups still access this forum once
it relocates??

That is not really possible, well at least not without significant
investment by...
Forum: Worksheet Functions May 5th, 2010, 08:10 PM Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Replies: 22
Views: 581
Posted By Joe User[_2_]
Microsoft Responds to the Evolution of Online Communities

"Jef Gorbach" wrote:
So will google groups still access this forum once
it relocates??

That is not really possible, well at least not without significant
investment by...
Forum: Worksheet Functions May 5th, 2010, 07:52 PM Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel
Replies: 22
Views: 581
Posted By Joe User[_2_]
Microsoft Responds to the Evolution of Online Communities

"Jim Thomlinson" wrote:
I think I will try the new forum before I express an opinion on whether it
is
better or worse.

You are right: I had not...
Forum: General Discussion May 5th, 2010, 07:52 PM Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel
Replies: 61
Views: 1,543
Posted By Joe User[_2_]
Microsoft Responds to the Evolution of Online Communities

"Jim Thomlinson" wrote:
I think I will try the new forum before I express an opinion on whether it
is
better or worse.

You are right: I had not...
Forum: General Discussion May 5th, 2010, 07:28 PM Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Replies: 61
Views: 1,543
Posted By Joe User[_2_]
Microsoft Responds to the Evolution of Online Communities

"T. Valko" wrote:
I didn't go to this link to read about the replacement forum:
http://www.microsoft.com/communities/newsgroups/default.mspx

Maybe you should be before...
Forum: Worksheet Functions May 5th, 2010, 07:28 PM Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Replies: 22
Views: 581
Posted By Joe User[_2_]
Microsoft Responds to the Evolution of Online Communities

"T. Valko" wrote:
I didn't go to this link to read about the replacement forum:
http://www.microsoft.com/communities/newsgroups/default.mspx

Maybe you should be before...
Forum: Worksheet Functions May 5th, 2010, 06:40 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 9
Views: 111
Posted By Joe User[_2_]
Count If equals x AND y

"Nadine" wrote:
Now I need to sum a different column based on the
same condition used for the "count". for those that
meet the same criteria, I now need to sum col D.

Isn't that simply a...
Forum: General Discussion May 5th, 2010, 06:31 PM Posted to microsoft.public.excel.misc
Replies: 0
Views: 77
Posted By Joe User[_2_]
Help with Google Groups search

Forgive me for this off-topic request. But since it impairs my ability to
help people with Excel questions, it might not be entirely inappropriate. I
have not gotten constructive help through the...
Forum: New Users May 5th, 2010, 05:50 PM Posted to microsoft.public.excel.newusers
Replies: 4
Views: 403
Posted By Joe User[_2_]
Question not posted?

I wrote:
Sorry. Obviously, the article I found is dated May 4,
not Apr 4. Is that what you meant by "4/5/2010"
(d/m/yyyy format)?

And my misreading of the date (I assumed m/d/yyyy format)...
Forum: New Users May 5th, 2010, 05:44 PM Posted to microsoft.public.excel.newusers
Replies: 4
Views: 403
Posted By Joe User[_2_]
Question not posted?

I wrote:
I posted it yesterday (4/5/2010)
[....]
I had no problem finding a posting [...]
dated 4/4/2010 (not 4/5) 8:26am PT

Sorry. Obviously, the article I found is dated May 4, not Apr 4....
Forum: New Users May 5th, 2010, 05:26 PM Posted to microsoft.public.excel.newusers
Replies: 4
Views: 403
Posted By Joe User[_2_]
Question not posted?

"Simon" wrote:
This may not be the correct place to post this
question but I cannot find any other access to
appropriate 'help'.

And thanks to a decision by Microsoft, to be implemented some...
Forum: Worksheet Functions May 5th, 2010, 03:53 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 83
Posted By Joe User[_2_]
Counting for frequency

"Roxana" wrote:
How can I count the frequency a piece of data occurs in an array?
I am trying to determine if a a set of data repeats itself and how
many...
Forum: General Discussion May 5th, 2010, 04:03 AM Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Replies: 61
Views: 1,543
Posted By Joe User[_2_]
Microsoft Responds to the Evolution of Online Communities

wrote:
Starting in early summer 2010, Microsoft will begin
progressively closing down the Microsoft public newsgroups
to enrich conversations in the rapidly-growing forum
...
Forum: Worksheet Functions May 5th, 2010, 04:03 AM Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Replies: 22
Views: 581
Posted By Joe User[_2_]
Microsoft Responds to the Evolution of Online Communities

wrote:
Starting in early summer 2010, Microsoft will begin
progressively closing down the Microsoft public newsgroups
to enrich conversations in the rapidly-growing forum
...
Forum: Worksheet Functions May 5th, 2010, 03:38 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 9
Views: 111
Posted By Joe User[_2_]
Count If equals x AND y

"Nadine" wrote:
Excel 2003
Col A Col B Col C
1 No Count this cell
I need to count all the cells in Col C if Col A=1 and Col B=No

To "count" all the rows that meet...
Forum: New Users May 4th, 2010, 03:42 PM Posted to microsoft.public.excel.newusers
Replies: 4
Views: 366
Posted By Joe User[_2_]
dates

"KRK" wrote:
How do I add 1 calendar month to a date, regardless
of the number of days in the month?

Depends on what you want for "one month after Jan 31",...
Forum: General Discussion May 3rd, 2010, 10:09 PM Posted to microsoft.public.excel.misc
Replies: 7
Views: 82
Posted By Joe User[_2_]
Excel 2003 IF AND question

"Ducklady" wrote:
What I've tried:
=IF(A1A5,A4,IF(A1B5,B4,IF(A1C5,C4,
IF(AND(A1D5,A2=3,D4)IF(AND(A1E5,A2=2,D4)
IF(AND(A1F5,A2=1,D4),"Employee"))))))

Based on the logic that you tried to...
Forum: Worksheet Functions May 3rd, 2010, 09:36 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 3
Views: 133
Posted By Joe User[_2_]
Simple calculation where values change to letters?

"Luke M" wrote:
PRODUCT and SUM both ignore text inputs.

Which is what I would want. And that might indeed be what Zuo really wants.

But I hasten to point out that...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 06:22 PM.


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