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
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
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
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
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
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
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
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
Calculating Duration by Barbara
Hi, I am trying to set up a spreadsheet calculation where I determine the duration in days between a date entered in Column A and a date entered in Column B....
September 15th, 2003 07:11 PM
by Barbara Go to last post
2 355
Countif using Criteria "<>""" ? by RagDyer
Thanks Tom, Never heard of "UsedRange" concept before. (Lots'a things I've never heard of !) But are there any other functions with similar...
September 15th, 2003 07:11 PM
by RagDyer Go to last post
0 528
Sumif of cells less than a system date by CJE
A B C 1 1/31/2003 2/28/2003 9/15/2003 2 1 1 1 =SUMIF(a1:c1,"=TODAY()",a2:c2) Should be simple but the formula...
September 15th, 2003 07:11 PM
by Peo Sjoblom Go to last post
1 378
How to prevent function range auto-modification ? by Manuel
Hi, I've discovered a feature that I find quite anoying: when I write something in a cell next to a range of cell used in any function, this range is changed...
September 15th, 2003 07:09 PM
by Harlan Grove Go to last post
2 661
Formula by pnoel
I need to extract a number from a text string, then list the number in a diffrent cell. Please Help. pnoel
September 15th, 2003 07:04 PM
by Harlan Grove Go to last post
3 417
Bolding specific text in a formula by Scot Rundell`
I am concatenating 3 cells, '=a2&b2&c2' and with the result of this, i need the text that is in cell b2, to be bold, so that i can get an answer of 'This is...
September 15th, 2003 06:53 PM
by Harlan Grove Go to last post
4 444
Examples needed by JM
Anyone know a site (library) in MS with examples?
September 15th, 2003 06:51 PM
by [email protected] Go to last post
1 426
concatenating cells by Rosson Cain
Hello, I need to concatenate two cells together. The problem is that the first cell always needs to be 6 digits long (e.g. if the entry is 23456 it need to...
September 15th, 2003 06:50 PM
by Cecilkumara Fernando Go to last post
2 298
Vlookup or Offset question by Bill
Not sure how to accomplish this so i will attempt to explain. Any assistance would be greatly appreciated! Sheet1 - consists of four columns of data for...
September 15th, 2003 06:34 PM
by Bill Go to last post
2 305
Calander by John Mansship
Let me rephrase my Calander question. Does anyone know how to copy the date clicked on the calender to a cell? Example: In Excel VB, I inserted a calander...
September 15th, 2003 06:30 PM
by John Manship Go to last post
2 320
attaching website links to excel file by lori
I am creating an excel file that I want to insert website links that I can access right from the excel file by double clicking them. I was able to do it in the...
September 15th, 2003 06:26 PM
by JM Go to last post
1 373
Error #VALUE with TEXT(A1;"[HH]:mm") when changing regional settings by Thierry De Bleye
I got the answer , the danes use :mm instead of :mm do somebody knows how to get a list of used time format per countries ? Regards Thierry
September 15th, 2003 06:20 PM
by Harlan Grove Go to last post
1 393
Change Case by Gary Ballance
I have the same question. Is there an easy way to change data in an entire spreadsheet from lower to uppercase?
September 15th, 2003 05:34 PM
by Don Guillett Go to last post
2 329
Post New Thread


Display Options
Showing threads 87741 to 87760 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:37 AM.


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