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
password to open workbook by Margaret
How to set up that it is a password is required to open a workbook
October 7th, 2003 04:37 PM
by Margaret Go to last post
4 425
Hidden worksheets displaying on opening by randula
I have a problem that I haven't seen before. I have a workbook that I update and distribute daily. This workbook contains hidden worksheets that I do not...
October 7th, 2003 04:49 PM
by Danny Go to last post
1 617
Worksheets by Mike Psarras
How can I locate a value in a worksheet but among multiple worksheets. I don't want to use find&replace from edit menu. I prefer to use a function such...
October 7th, 2003 05:31 PM
by Earl Kiosterud Go to last post
1 172
Pause in an Excel Macro by Harry Bennett
I need to create a macro with multiple functions, one of which is "SaveAs", so I can save the worksheet to a different name. How can I record/enter a "pause"...
October 7th, 2003 05:42 PM
by Bernie Deitrick Go to last post
1 541
Inserting symbols shortcut by Warren
Is there a way to provide a shortcut to inserting symbols in excel. I've only found the cut and paste from the characer map. Anyone know how to add-in...
October 7th, 2003 05:58 PM
by Peo Sjoblom Go to last post
1 304
BAHTTEXT by manharawy
I have a problem working with the BAHTTEXT function in the Excel, As i enter the numbers in the box inorder to be shown as text , the excel displays the text...
October 7th, 2003 06:10 PM
by J.E. McGimpsey Go to last post
2 288
VLOOKUP next greatest value? by bostitch
I would like to find the SMALLEST value in an array that is GREATER than lookup_value. However VLOOKUP returns the LARGEST value in an array that is LESS than...
October 7th, 2003 06:51 PM
by Harlan Grove Go to last post
3 175
column headings for multiple pages in Excel by Claudia
I have created a report to list our daily purchase orders received from vendors. This report has seven columns in landscape mode. Some days I only have...
October 7th, 2003 06:54 PM
by Barbara Go to last post
2 436
Where is circular reference? by Brett
I'm using Excel 2002. I have a spreadsheet with several function cells. When I open the sheet, I get a circular reference message. It doesn't tell me where...
October 7th, 2003 07:22 PM
by Brett Go to last post
3 477
Next Row by Jay Easley
I am using a vlookup to find a value in a list and then directly below that I would like to find the value beneath the value found in the list. For...
October 7th, 2003 07:22 PM
by Jay Easley Go to last post
4 173
Extracting Data based on Equal Cell Values by Ken Wright
Take a look at Advanced Filter / Unique records only. Debra Dalgleish has a good intro on her site:- http://www.contextures.com/xladvfilter01.html Look at...
October 7th, 2003 07:27 PM
by Ken Wright Go to last post
5 676
INT, MOD or ROUNDDOWN function help needed by Dan E
Rpb, I would suggest changing your column G formula to: =ROUND(H2/A3,2) and drag down for all rows Dan E "rpb" wrote in...
October 7th, 2003 07:58 PM
by rpb Go to last post
2 237
Calculating Dates by Kerrick Sawyers
Need a little help: Trying to calculate the number of days between two dates formatted as mm/dd/yy hh:mm:ss. Any help would be greatly appreciated. ...
October 7th, 2003 08:09 PM
by End-User Go to last post
3 163
macro by kendra lewin
Is it possible to assign unique macros to individual items in a "combo drop down box"? For example, I have 5 items that a user can select in a combo box. I can...
October 7th, 2003 08:39 PM
by Dan E Go to last post
1 196
Combine Multiple Spreadsheets by CCourtois
I have about 200 separate spreadsheet files that I need to combine into one. Other than copying and pasting I don't know how to do this. Can it even be...
October 7th, 2003 09:38 PM
by Ron de Bruin Go to last post
3 267
user input in macros by donna culberson
How do I create a macro with a prompt inserted to force the user to enter input then resume the macro once the user input has been entered?
October 7th, 2003 10:03 PM
by Danny Go to last post
3 322
Extract Data by Steved
Hello from Steved A1 is text = Arthur St A2 is text = Penrose High A3 is a number = 4.0 Could somebody be kind enough to write me a lookup The...
October 7th, 2003 10:10 PM
by Big Chris Go to last post
2 149
Copy last characters form one column to another by George
I need to copy the last five characters form one column to another. How do I do this? G
October 7th, 2003 10:16 PM
by Ken Wright Go to last post
1 219
add zeros to front of text string by Dave R.
Here ya go =+CHOOSE(10-LEN(D7),"0","00","000","0000","00000","000000")&D7 What this does is decides how many 0s to put in front of the number based on how...
October 7th, 2003 10:59 PM
by Andy Brown Go to last post
5 278
Keep Top Row Heading for printing multiple pages by G118
I have a 5 column worksheet with hundred of rows of data. All of the columns come out in print preview mode in landscape mode. It is about a 20 page...
October 7th, 2003 11:56 PM
by Dan E Go to last post
1 637
Post New Thread


Display Options
Showing threads 1001 to 1020 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 08:21 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.