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 » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Line spacing by Rupa
Does anyone know how to increase line spacing in Excel? I don't seem to be able to do it Thanks Rupa
September 15th, 2003 07:15 PM
by Ken Wright Go to last post
1 507
ISERR vs ISERROR by Biff
Hi Folks, The only difference I can see between these two is that ISERR will not handle #N/A. Also, what about ISNA? Is there any advantage in using ISERROR...
September 15th, 2003 07:20 PM
by Harlan Grove Go to last post
8 447
How to pass array variables in sub procedure by Ying
Suppose I have a sub procedure with array variables: Build_Matrix(Matrix_Dim as interger, MatDate() as Date, TimeInterval() as double) I want to call...
September 15th, 2003 07:35 PM
by Ying Go to last post
0 407
Excel Conditional Formatting? by Ben Blackmore
Hi, I have our company IP address range in excel format. I want to do conditional formatting so I clearly see the different scopes. If I do conditional...
September 15th, 2003 07:48 PM
by David McRitchie Go to last post
3 829
Date List by JP
I have a column of dates that looks something like this: A 9/1/03 9/1/03 9/1/03 9/2/03 9/2/03 9/4/03 9/4/03
September 15th, 2003 08:12 PM
by Manish Bajpai Go to last post
1 282
reversing lastname, firstname by Mich
I have a list of names that have lastname, firstname in one cell. I would like to make it firstname lastname in one cell. Thanks you.
September 15th, 2003 08:43 PM
by Gerry Kuta Go to last post
2 370
Possible to set Zoom on worksheets via Macro? by Randy Harris
I'm in an office where several different people on different computers work with many different Excel spreadsheets. Because we all have different preferences...
September 15th, 2003 09:02 PM
by Andy Wiggins Go to last post
7 399
combining formulas by Yolande Koval
7738 WE 080903 -737.65 7738 WE 081603 -340.06 7738 WE 081903 -393.96 7738 WE 082103 -68.29 7738 WE 082303 -248.88 7738 WE 082903 -62 7738 WE...
September 15th, 2003 09:12 PM
by David Pierce Go to last post
1 277
deleting duplicate rows by margaret
Any information/instruction on how to delete an entire row of data if data in column is duplicated? In use of eliminating duplicate address labels. Thank you
September 15th, 2003 09:13 PM
by Pablo Go to last post
1 599
Rounding up at 4 by Micheline Morin
I believe that, by default, Excel 2002 rounds up at 5. Example: 24.445 is rounded up to 24.45 How would I go about getting Excel 2002 to round at 4? Example:...
September 15th, 2003 09:42 PM
by Peo Sjoblom Go to last post
1 317
import data from one worksheet to another by ckeel
I have a worksheet with 3 columns. I need to pull data to another sheet. For example if sheet1!b3=cat i need to pull sheet1!b1 to sheet2!a1, sheet1!b2 to...
September 15th, 2003 10:04 PM
by Peo Sjoblom Go to last post
1 263
How to multiply a text function by a dollar ammount by Kenya Johnson
I am trying to create a time sheet that will calculate the number of hours and minutes and multiply that number by a rate of pay. I have been having problems...
September 15th, 2003 10:06 PM
by Kenya Johnson Go to last post
2 293
formulas by Andrea
I want to enter a price chart for a product that has specific prices for specific sizes. I want to enter a size and have a formula find that specific size...
September 15th, 2003 10:48 PM
by Peo Sjoblom Go to last post
1 299
Printing group symbols on report by Jim Goughenour
How can I get the group symbols to print on my reports? The group symbols and marks show where one can collapse/expand sets of rows/columns to...
September 15th, 2003 11:58 PM
by Debra Dalgleish Go to last post
1 576
Upper case to lower case by betsy
is there an easy way to convert test from upper to lower case? Thanks
September 16th, 2003 12:00 AM
by David McRitchie Go to last post
6 487
Merge 2 Worksheets like Word Mail Merge??? by Lori Factor-Marcus
Hi~ Is it possible to merge 2 Excel worksheets, similarly to Word Mail Merges? Where could I find info on this? THANK YOU!!! ~Lori Both my Data Source and...
September 16th, 2003 12:07 AM
by David McRitchie Go to last post
1 780
his own PR thrust by Hamza Jadallah El Hassan
Rethink the Cool + the Shoe phil knight had a dream. he'd sell shoes. he'd sell dreams. he'd get rich. he'd use sweatshops if he had to. then along came a...
September 16th, 2003 01:30 AM
by Hamza Jadallah El Hassan Go to last post
0 358
changing a button color by amy
Hi. I have excel 2000 and I'm trying to change the color of a button that I have on a form, that is assigned to a particular macro, but on the format control...
September 16th, 2003 02:07 AM
by John Wilson Go to last post
2 649
Creating new Option buttons by Seamus McMillan
I have a worksheet with a pair of option buttons (Male/Female), both referencing the same cell. This works fine. I now wish to add another pair of...
September 16th, 2003 02:26 AM
by Rafael Ortiz Go to last post
1 617
Fields - Tabbing to the next by Tim
I have created a standard template. I want users to tab from one field to the next which may mean moving several columns over or several rows down. How do I...
September 16th, 2003 02:51 AM
by RagDyer Go to last post
2 345
Post New Thread


Display Options
Showing threads 41 to 60 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:52 PM.


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