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 49
Search took 0.17 seconds.
Search: Posts made by: Trying
Forum: Tables May 29th, 2010, 06:36 AM Posted to microsoft.public.word.tables
Replies: 2
Views: 1,845
Posted By Trying
how do I multiply numbers across in a table

In a word table I'm trying to multiply 50x$7.66.
Forum: General Discussion December 23rd, 2009, 08:56 PM Posted to microsoft.public.word.docmanagement
Replies: 9
Views: 313
Posted By Trying
How do I move my cursor between columns in a Word document?

"RTH" wrote:

I have a document with two columns. I would like to type in the right-hand
coiumn with out having the words wrap from the left-hand column.

HOW DO I GET MY CURSOR TO THE...
Forum: General Discussion March 1st, 2008, 12:57 AM Posted to microsoft.public.access
Replies: 4
Views: 70
Posted By Trying
COUNT expression in a report

Steve
I used your expression in an unbound text box in the footer of my report.
An error window poped up saying.....The expression
=Sum(IIf([Type]="Truck",1,0)) is invalid. Aggregate functions are...
Forum: General Discussion February 29th, 2008, 11:01 PM Posted to microsoft.public.access
Replies: 4
Views: 70
Posted By Trying
COUNT expression in a report

Hi
I have a field, named [Type].
In a report, what is the expression to count this field “[Type]” where
Type="Truck"
??? =Count([Type]) where type = “Truck”
Thanks
Forum: General Discussion February 27th, 2008, 05:31 PM Posted to microsoft.public.access
Replies: 1
Views: 44
Posted By Trying
"Count" expression in report

Hi
I have a field, named [Type].
In a report, what is the expression to count this field “[Type]” where
Type=Truck
??? =Count([Type]) where type = “Truck”
Thanks
Forum: General Discussion January 15th, 2008, 07:02 PM Posted to microsoft.public.excel.misc
Replies: 7
Views: 58
Posted By Trying
Freeze more than one column

I believe the first option (Freeze Panes) is what you want.

"Kim" wrote:

Dave,

No joy. When I select D1 (or column D for that matter) the ViewFreeze Pane
options are only Freeze Panes...
Forum: General Discussion January 11th, 2008, 10:43 PM Posted to microsoft.public.excel.misc
Replies: 7
Views: 59
Posted By Trying
Simple % deduciton in excel 2007

That's a great example, David. I was NOT trying to argue FOR doing more than
necessary. I'm for the simplest, shortest, most efficient solution.


"David Biddulph" wrote:

There's lot of other...
Forum: General Discussion January 11th, 2008, 08:01 PM Posted to microsoft.public.excel.misc
Replies: 7
Views: 59
Posted By Trying
Simple % deduciton in excel 2007

Just out of curiosity, I did like spuds did and typed "@sum(A1*B1)" and I
still got .5 in C1. I remembered that was how we did formulas back in Lotus
days. I am using Excel 2007 and neither...
Forum: General Discussion January 9th, 2008, 11:24 PM Posted to microsoft.public.excel.misc
Replies: 14
Views: 141
Posted By Trying
fill a series keeping the last number constant

That should work for Cindy. It would take her a while before the first 4
digits become 5. By then she can easily edit the formula to fit the new
situation.

"Dave Peterson" wrote:

How about this...
Forum: General Discussion January 9th, 2008, 11:00 PM Posted to microsoft.public.excel.misc
Replies: 14
Views: 141
Posted By Trying
fill a series keeping the last number constant

GORD: Thanks. Even though I wasn't the original poster. I could use the
concept.

However, when I tried to extend the series past 2599-1, I got 25100-1, 25101-1

"Gord Dibben" wrote:

One...
Forum: General Discussion January 9th, 2008, 10:48 PM Posted to microsoft.public.excel.misc
Replies: 7
Views: 44
Posted By Trying
Finding Multiple Entries & Deleting All but One

DON: Seems to me Brandy does not want to delete the rows. She only wants to
clear the PO number from the second and subsequent cells. The other 5 rows
for PO # 200205 might contain information...
Forum: General Discussion January 9th, 2008, 10:28 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 48
Posted By Trying
Modify date in certain rows

If I understand you correctly, unless the other 8 rows are conditionally
formatted based on the 2 rows you are modifying, the format of those 8 rows
should not change.

"dmb4473" wrote:

,I have...
Forum: General Discussion January 9th, 2008, 10:23 PM Posted to microsoft.public.excel.misc
Replies: 14
Views: 141
Posted By Trying
fill a series keeping the last number constant

Based on my limited knowledge, here's what I'd do. The regulars would
probably have a more efficient way of accomplishing this.

Assuming the first 4 digits keep incrementing by 1 and you want this...
Forum: General Discussion January 9th, 2008, 12:10 AM Posted to microsoft.public.excel.misc
Replies: 7
Views: 65
Posted By Trying
Sort .csv file

Excel 2003 only goes up to 65,536 rows so presumably you are using Excel 2007.

In any case, I don't think you would be gaining much by using a macro for a
simple sort, especially if this is a...
Forum: General Discussion January 8th, 2008, 11:51 PM Posted to microsoft.public.excel.misc
Replies: 5
Views: 49
Posted By Trying
if then statement

AMY: You can see, just like I did, the wisdom and accuracy of David's reply
by testing it with a small sample. What I did is enter 4998, 4999, 5000,
9998, 9999, 10000, and 10001 into cells A1 to...
Forum: General Discussion January 4th, 2008, 06:12 PM Posted to microsoft.public.excel.misc
Replies: 4
Views: 60
Posted By Trying
isnotblank function?

For someone like me who needs to interpret the TRUE or FALSE that the
suggested formulas would return, I would use something like this:

=IF(ISBLANK(A1),"Cell A1 is blank","Cell A1 is NOT blank")....
Forum: New Users January 3rd, 2008, 12:28 AM Posted to microsoft.public.excel.newusers
Replies: 12
Views: 145
Posted By Trying
how to quick calculate sum of colume A1 to A115?

Anthony B:

Another approach would be to define a name for your range, for example
QuickSum. After you do this, the named range would be available in the Name
Box (which is immediately above column...
Forum: Worksheet Functions January 2nd, 2008, 10:20 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 6
Views: 58
Posted By Trying
Changing text dates to date serial numbers

I'm just trying to learn from reading the posts here.

Just like you, I'm wondering what George wants to do with the contents of
cells B2 and down the column. Perhaps if George would tell you, you...
Forum: Worksheet Functions December 27th, 2007, 08:23 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 4
Views: 83
Posted By Trying
Excel Manual Controls

I am new here myself and am trying to learn from the posts.

No disrespect intended, but I just copied a formula that is in row 1 to rows
2 to 1001 of a spreadsheet I'm working on and it took me 8...
Forum: Worksheet Functions December 27th, 2007, 07:56 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 6
Views: 77
Posted By Trying
Need Formula Help

I don't necessarily have a solution for you. I am trying to learn myself.

So I don't know if this would help you, but it would help me in working out
the solution. In your first example, would the...
Forum: Installation & Setup December 27th, 2007, 05:50 PM Posted to microsoft.public.outlook.installation
Replies: 3
Views: 72
Posted By Trying
Transferring saved personal folders file from old computer to

Thanks for the quick and workable solution.

"Roady [MVP]" wrote:

Copy it back to your computer and use File- Open- Outlook Data File... to
connect to it.

--
Robert Sparnaaij...
Forum: Installation & Setup December 27th, 2007, 04:41 PM Posted to microsoft.public.outlook.installation
Replies: 3
Views: 72
Posted By Trying
Transferring saved personal folders file from old computer to new

I recently changed computers at work. I created a personal folders file for
saving messages in my old computer. I saved this personal folders file and
now it is in a network drive. I want to use...
Forum: New Users December 22nd, 2007, 12:10 AM Posted to microsoft.public.excel.newusers
Replies: 4
Views: 108
Posted By Trying
how do i add and subtract

Nice suggestion here. Being new to this forum, I observed that most, if not
all, who post are not only knowledgeable and helpful but also kind and
considerate in their language. I appreciate this....
Forum: Worksheet Functions December 21st, 2007, 09:16 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 86
Posted By Trying
Copy a Negative value to another WS

Not only should you remove the ABS function (which of course disregards the
negative sign), but you should rewrite your formula as such:
=IF(ISBLANK(Input!E7),"",Input!E7)

I don't think there is...
Forum: Worksheet Functions December 14th, 2007, 09:11 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 12
Views: 76
Posted By Trying
automatic data sorting?

Please know that I am here mostly to observe and learn. I have very little to
contribute, if any, by way of solutions to problems posted here.

From my limited experience with Excel, and even less...
Showing results 1 to 25 of 49

 
Forum Jump

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


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