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 Reverse Sort Order / Thread Starter Last Post Replies Views
"macro Worksheet" by sal
HiI have created a few macros using VBA in excel. I now want to use a macro worksheet instead, since it seems easier to find your macros. This is totaly new to...
September 8th, 2004 06:10 AM
by Arvi Laanemets Go to last post
1 246
"Match" Function - how to find multiple matches ?? by Keith
I am comparing two worksheets, and the only way I have found to compare and find both exact and partial matches is by using the Match function, and since it...
March 2nd, 2004 11:27 AM
by David Byrne Go to last post
2 418
"Microsoft" Patch Virus Messages by Alan
Does anyone know if the flurry of these things appearing in the newsgroups recently is due to people maliciously sending them, or if the virus is sending...
September 25th, 2003 07:36 PM
by Harlan Grove Go to last post
5 429
"Not enough memory" by Bill H.
When working with a small excel file (136 KB) I get the "Not enough memory" error.I've cleared the save external link values but same message. Any simple fixes?
May 9th, 2005 01:04 AM
by David McRitchie Go to last post
2 118
"ON ERROR GOTO" by Krappo
Hello ppls, I need an Error Handler which looks like this: Sub Macro1() On Error Goto AAA Workbooks.Open Filename:="C:\dir\dir\book2.xls" Exit Sub
(Multi-page thread 1 2)
September 21st, 2003 03:31 AM
by Krappo Go to last post
13 274
"OR" function by Connie
Working with Excel 2000. My workbook has four worksheets. Worksheet 4 is a summary of some of the cells in the first three. One employee may only be required...
November 6th, 2003 10:28 PM
by Go to last post
4 161
"OR" in a array by wildman
=SUM(IF((FIXEDm!$F$2:$F$5000="WG1")*OR((LEFT(FIXEDm!$I$2:$I$5000,4)="2q13"),(LEFT(FIXEDm!$I$2:$I$5000,4)="2q15"),(LEFT(FIXEDm!$I$2:$I$5000,4)="2q17")),1,0)) I...
September 30th, 2003 04:10 PM
by Dave Go to last post
3 142
"OR" operator to evaluate multiple conditions by Scott P
Is there an arithmetic operator that represents "OR" for use in functions such as SUMPRODUCT? I am aware that you may use the "*" operator in SUMPRODUCT to...
May 23rd, 2005 08:49 PM
by Bob Phillips Go to last post
9 126
"pick from list" by [email protected]
does anyone know how to delete a choice from any of the drop down list "pick from list" in the fields? Thanks
March 12th, 2004 07:26 PM
by Gord Dibben Go to last post
2 280
"Pleading paper" in Excel? by geebee
I need to be able to print Excel data so that it looks like it was printed on "pleading paper" (this term will be well-known to legal-types. It mostly involves...
(Multi-page thread 1 2)
March 31st, 2005 02:37 AM
by Harlan Grove Go to last post
15 432
"Pop-up" messages in excel by Katrina Hancock
Can you create in excel "pop-up" messages as a reminder for specific dates?
October 13th, 2003 08:49 PM
by Nick Hodge Go to last post
1 134
"possible number combinations" of different numbers of integers -. by rsdauer
what would the formula be to "see" all "possible number combinations" of any given about of intigers (0-9)
September 2nd, 2004 07:28 AM
by Harlan Grove Go to last post
7 366
"proper" function excel wksht by CajnBred
Why would the "proper" funtion for capitalizing work on some columns of my worksheet and not on others. Some display the proper Capitalized text,...
April 12th, 2005 11:47 PM
by Gord Dibben Go to last post
2 111
"Randomising" "number" by Leslie
I have a worksheet, cells, b1, b2 and b3 of which each contains a 10-digit hexadecimal number. In another cell, I have the following formula:...
February 10th, 2005 09:02 AM
by Leslie Go to last post
3 105
"Saturday as a work day? by keith m
I am using the formula "=Workday" but I want this formula to include Saturdays. I have a Start Date and a duration and want to calculate the end date with...
August 12th, 2005 10:17 PM
by Bob Phillips Go to last post
6 117
"SchedTask 1.0 Type Library" by tal
Hello Everyone. where can i find "SchedTask 1.0 Type Library" ? Thanks, Tal.
April 21st, 2004 07:06 AM
by tal Go to last post
0 306
"Select" type statement by Richard Davies
Hello all I have a grid of data, with prices for posting parcels in the UK. There are 3 different ways which parcels get sent, 1st Class, 2nd Class...
February 23rd, 2004 02:58 PM
by Andy Wiggins Go to last post
1 211
"Sort" help by lehu
Hi, maybe someone can help me with a simple "sort" question. I'm using excel 2000, how do I sort in the order that the data was...
October 9th, 2005 03:51 PM
by Barb Reinhardt Go to last post
1 164
"Suggest a match" from a list or drop down. by pjpuddles
Is it possible to pull information from a database into another worksheet without having the exact spelling of that information? I have a database with names...
July 5th, 2005 09:37 PM
by pjpuddles Go to last post
0 92
"Sumif"or "if" ...followup question by Peter
Thanx, Paul, that worked! But I have another question. If I get a "NO" and enter that in the RSVP column, can I get the "balance due" to blank...
September 16th, 2003 11:24 PM
by James S Go to last post
1 328
Post New Thread


Display Options
Showing threads 61 to 80 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 10:13 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.