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 32.93 seconds.
Search: Posts made by: Dave Peterson
Forum: Worksheet Functions June 6th, 2010, 01:40 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 4
Views: 1,354
Posted By Dave Peterson
Count function seeing formulas as data

I'm sure Bob meant =CountA() will count cells with formulas.

=Count() will count cells with formulas if the formulas evaluate to a number.

Bob Phillips wrote:

I don't think COUNT will, COUNT...
Forum: General Discussion June 6th, 2010, 11:43 AM Posted to microsoft.public.excel.misc
Replies: 3
Views: 931
Posted By Dave Peterson
Help! how to cross - data with excel??

You have a response at one of your other posts.

gloriamar wrote:

Hi, I'm required to present some info at my work, using two excel files. This
is the task:

File 1, has ID numbers in...
Forum: New Users June 6th, 2010, 11:41 AM Posted to microsoft.public.excel.newusers
Replies: 23
Views: 6,201
Posted By Dave Peterson
The Day After ???

When you look at the list of newsgroups, do you see a list of about 10?
Including one named: eternal-september.where.are.all.the.newsgroups

If you see that then you haven't configured the...
Forum: Worksheet Functions June 6th, 2010, 02:07 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 890
Posted By Dave Peterson
xdate in Windows 7

I bet you were using an addin by John Walkenbach:
http://j-walk.com/ss/excel/files/xdate.htm



Help with scheduling issue wrote:

I finally entered the world of Windows 7, albeit only because my...
Forum: New Users June 6th, 2010, 01:31 AM Posted to microsoft.public.excel.newusers
Replies: 23
Views: 6,201
Posted By Dave Peterson
The Day After ???

It looks like you're using Windows Live Mail.

I set it up in Outlook Express.

I added the server and set my access rules (id and password).
Then I was prompted to see if I wanted to download the...
Forum: General Discussion June 6th, 2010, 01:24 AM Posted to microsoft.public.excel.misc
Replies: 1
Views: 558
Posted By Dave Peterson
how do we get 2003 .xlb toolbars and custom macros to show in 07

I would drop the toolbar file and create that toolbar on the fly when excel
opens the .xls file. It'll make things much easier.

Saved from a previous post:

For additions to the worksheet menu bar,...
Forum: Worksheet Functions June 5th, 2010, 10:39 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 3
Views: 681
Posted By Dave Peterson
Remove error notification X7/M7=0 when one or both cell values are

If m7 is different from 0, then if x7 is 0, it won't cause an error.
(assuming that both cells contain numbers).

=if(m7=0,"",x7/m7)

or if x7 or m7 could contain text
=if(iserror(x7/m7),"",x7/m7)
Forum: New Users June 5th, 2010, 10:37 PM Posted to microsoft.public.excel.newusers
Replies: 23
Views: 6,201
Posted By Dave Peterson
The Day After ???

Visit:
http://www.eternal-september.org/

Click on the Online link (in the notes about registering) and that'll take you
directly to this...
Forum: General Discussion June 5th, 2010, 08:34 PM Posted to microsoft.public.excel.misc
Replies: 7
Views: 632
Posted By Dave Peterson
Nested AND OR expressions

With worksheets("Someworksheetnamehere")
if .range("J11").value = 11 _
and (lcase(.range("e1").value) = "1bx" _
or lcase(.range("e1").value) = "2bx" _
or...
Forum: Worksheet Functions June 4th, 2010, 11:41 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 405
Posted By Dave Peterson
F4 no longer automatically creates absolute reference

Did you go into edit mode first (either hit F2 or click on the formula bar with
A1 selected)?

molla wrote:

I select the text of a cell name (A1, for example), hit F4, an nothing
happens. I...
Forum: General Discussion June 4th, 2010, 11:19 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 475
Posted By Dave Peterson
Separate AM/PM from time.

Are these really times or are they text?

If they're plain old text, then I'd convert them to times.

Select the range
Edit|replace:
what: AM
with: _AM (where _ represents the space...
Forum: General Discussion June 4th, 2010, 11:16 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 432
Posted By Dave Peterson
Macro/VB coding question

When I don't know the number of rows, I'll use something like this if there's a
column that can determine where the data stops:

Dim LastRow as long
....
with activesheet
'use column A to determine...
Forum: General Discussion June 4th, 2010, 07:49 PM Posted to microsoft.public.excel.misc
Replies: 10
Views: 648
Posted By Dave Peterson
SUMIFS

Then check the values in the other fields. Maybe they're not what you're
looking for.

RAK wrote:

"Dave Peterson" wrote:

Maybe the value in AN3:An997 aren't really numbers. Maybe...
Forum: Worksheet Functions June 4th, 2010, 04:15 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 4
Views: 422
Posted By Dave Peterson
Count number of instances

If you wanted to count the number of unique entries in that range, you could use
a formula like:

=sumproduct((a1:a10"")/countif(a1:a10,a1:a10&""))
(you can only use the entire column in...
Forum: General Discussion June 4th, 2010, 04:11 PM Posted to microsoft.public.excel.misc
Replies: 10
Views: 648
Posted By Dave Peterson
SUMIFS

Maybe the value in AN3:An997 aren't really numbers. Maybe they're just text
that looks like numbers.

If you put:
=count(an3:an997)
in a cell
and
=counta(an3:an997)
do those evaluate to the same...
Forum: Worksheet Functions June 4th, 2010, 02:26 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 1
Views: 531
Posted By Dave Peterson
Can't Edit Worksheet Comments

Check your other post.

Paul Calcagno wrote:

I'm running Vista Home Premium SP2, 2 GB RAM, Firefox, Spyware Doctor, MBAM,
SAS and CCleaner, Office 2007.

All of a sudden only one (of many)...
Forum: Worksheet Functions June 4th, 2010, 12:25 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 5
Views: 445
Posted By Dave Peterson
How do I unhide collom a?

Make sure that you haven't frozen the panes so that you can't scroll to column
A.

In xl2003:
Window|Unfreeze panes
and scroll to the left

If you still can't see column A, then try:
F5 (edit|goto)...
Forum: Worksheet Functions June 3rd, 2010, 09:04 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 9
Views: 512
Posted By Dave Peterson
Determine "on time" status

I would try a couple of things.

First, give N6 and O6 an unambiguous date/time format.
Like:
mmmm dd, yyyy hh:mm:ss

If the values don't change, then your entries aren't really date and times....
Forum: General Discussion June 3rd, 2010, 08:54 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 566
Posted By Dave Peterson
file with udf extension

Ignore the ads at the top of this page -- don't click on them:
http://filext.com/file-extension/udf

But do read the description at the bottom.

If you wanted, you could try opening the file in excel...
Forum: General Discussion June 3rd, 2010, 08:49 PM Posted to microsoft.public.excel.misc
Replies: 1
Views: 392
Posted By Dave Peterson
Excel Add-In and Dual Monitor Causing Read-Only

It sure sounds like choices are limited.

I would continue to contact the 3rd party to ask for help. That 3rd party may
even want you to buy updates, but you could just tell them if they don't...
Forum: General Discussion June 3rd, 2010, 08:44 PM Posted to microsoft.public.excel.misc
Replies: 1
Views: 493
Posted By Dave Peterson
Text Qualifiers

I'd use a helper column (say column C) with a formula in it that wraps the
fields that you need in quotes:

=""""&a1&""""&b1
and drag down.

Then select column C.
Copy it
Paste into Notepad
Save that...
Forum: General Discussion June 3rd, 2010, 08:43 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 1,199
Posted By Dave Peterson
Auto Row Height with Wrapped Text in Merged Cells Problem

I start with a macro that Jim Rech shared:
http://groups.google.com/groups?threadm=e1%241uzL1BHA.1784%40tkmsftngp05



Rick Cl. wrote:

I can't get my spreadsheet to automatically change the row...
Forum: General Discussion June 3rd, 2010, 04:08 PM Posted to microsoft.public.excel.misc
Replies: 1
Views: 492
Posted By Dave Peterson
My spreadsheet only appears in the top left of the page.

I'm not quite I understand, but maybe you've frozen the window so that only a
portion of the screen is visible.

In xl2003 menus, I'd try:
Window|Unfreeze panes



Terry Evans wrote:
Forum: General Discussion June 3rd, 2010, 03:27 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 481
Posted By Dave Peterson
Radio Buttons

ps. If your only choices are yes/no, you could use a single checkbox per
question.

If it's checked, it's yes. If it's unchecked, it's no.

John wrote:

I am creating a questionnaire, where...
Forum: General Discussion June 3rd, 2010, 03:26 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 481
Posted By Dave Peterson
Radio Buttons

Saved from a previous post:

If your optionbuttons are from the Forms toolbar, the put all your optionbuttons
in each group in a groupbox (also on that Forms toolbar).

If your optionbuttons are from...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 11:34 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.