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
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
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
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
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
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
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
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
Columns by Mark
My colums changed from letters to numbers. Do not know why. I want hem to be letters. All my worksheets changes.
October 7th, 2003 04:12 PM
by Jim Go to last post
4 154
Erro message while using move and copy by Joyce Johnson
I get the error message "No more fonts may be applied in this notebook" when I try to copy a new spreadsheet. I need a total of 16 sheets and after 12 I get...
October 7th, 2003 03:39 PM
by Ron de Bruin Go to last post
1 168
Floating cells by sanjay
I need some help with excel and I was wondering if you could aid me in this regard. I need to create a floating cell(if that is the right name) in excel. The...
October 7th, 2003 03:33 PM
by Harald Staff Go to last post
1 163
Arrays by Bernard V Liengme
Hi Jan Assuming you have an extra 0 in the example, this works for me in C1 enter =MATCH(A1,$B$1:$B$2,0) Copy down to C8 Best wishes Bernard "Jan"...
October 7th, 2003 03:10 PM
by Jan Go to last post
1 135
Relative Links by David
I am using an xl spreadsheet as a front end to link data to other spreadsheets in the same folder. I have no problem creating the links and getting the...
October 7th, 2003 11:28 AM
by David Go to last post
0 601
Sumproduct clarification by Walter Mayes
Various members of this forum have stated that the arrays used in SUMPRODUCT must be the same. Excel HELP says, under remarks, in part..."Array arguments must...
(Multi-page thread 1 2)
October 7th, 2003 10:52 AM
by Walter Mayes Go to last post
18 442
Function or formula to return active cell? by Dan
I am looking for a way (in a formula or function) to determine the active cell. I would like the value to be the active cell every time the worksheet is...
October 7th, 2003 07:28 AM
by Tim Otero Go to last post
3 568
Time Sheet function by John Logan
I need assistance constructing a time sheet for department employees. Is it possible to calculate regular time AND overtime from time start and time end? In...
October 7th, 2003 07:26 AM
by Tim Otero Go to last post
3 725
Question on referencing Worksheets in other Workbooks by Paul Laska
I have a Workbook where I am trying to pull information from other Workbooks, and I'm having trouble figuring out the syntax. What I have got to work so far...
October 7th, 2003 07:17 AM
by Paul Laska Go to last post
3 342
Excel Cell Limitations by JD Kronicz
Hi I am trying to create a large cell in Excel so that people can type many paragraphs of information. I have done this by merging a number of cells together...
October 7th, 2003 04:12 AM
by Dave Peterson Go to last post
3 262
random number generator formula by Dave R.
Have you used the RAND() function? If i remember right, it may not be installed automatically so you might have to add it on. But then just use RAND() next to...
October 7th, 2003 04:02 AM
by Max Go to last post
1 363
Subtotal Mystery by EU
I added added a SUBTOTAL with COUNTA sub_function =SUBTOTAL(3,range) and it counts ALL cells in that range instead of just the non-empty ones. So, if there...
October 7th, 2003 04:02 AM
by Dave Peterson Go to last post
4 185
Spam by Mike
I posted a message on this site a couple of weeks ago. Since posting that message I have received a ton of spam. This is the only site I have posted my...
October 7th, 2003 02:41 AM
by Tim Otero Go to last post
2 126
Post New Thread


Display Options
Showing threads 86781 to 86800 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 01:28 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.