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
Macro by Shane
How do I save a macro to a floppy disk so that I may copy the macro to another computer?
September 17th, 2003 01:07 AM
by Don Guillett Go to last post
1 294
Date Function: How to determine number of Saturdays in a date range by Dan Picciotto
I'm trying to create a sprdsht that will give me the number of Saturdays and Sundays based on inputs of Starting Date and Ending Date. It's a nut i haven't...
September 17th, 2003 12:46 AM
by Daniel.M Go to last post
2 621
Solving for Coefficients of a polynomial by Dan Mertens
Is there a function in Excel that can return the coefficients of a polynomial from a set of X values and a set of Y values? I know you can get a trendline...
September 17th, 2003 12:04 AM
by Bernard V Liengme Go to last post
1 341
ROUND function or custom format by Lucy
i'm trying to round to the nearest 100th eg 1436 to 1400, or 1475 to 1500. i would like to use the custom since if we use ROUND, we don't have the numbers yet...
September 16th, 2003 11:42 PM
by Harald Staff Go to last post
1 428
"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
Fonts of Drop Down Forms by Stijn
When using the forms' drop downs, how can I modify the font size/type ... ?
September 16th, 2003 11:12 PM
by s-o-s Go to last post
3 581
Order form by Jamie
I'm creating an order form and I want to automatically copy information from a database that is on another sheet in the workbok. After I enter the Item number...
September 16th, 2003 11:02 PM
by Intruder9 Go to last post
1 548
drop down by anita
Does anyone know how to create a drop-down menu in Excel? For example in Cell A1 I want there to be a list that I can choose from.
September 16th, 2003 10:34 PM
by Debra Dalgleish Go to last post
2 390
cell references by Sandi
does anyone know how to enter a formula to link two pages when the cell reference always increases by 7 rows. Right now I have to type the formula in each...
September 16th, 2003 10:28 PM
by GB Go to last post
4 689
average function by Rod
When I use the average function like this =AVERAGE(B3:C3), I get a #DIV/0! error. B3 C3 (0.6 1.6 Any ideas?
September 16th, 2003 10:09 PM
by Rod Go to last post
2 466
"If" or "sumif" by Peter
I am holding a function where if the person comes alone, the price is $300, but if he brings his wife, the price is $400. I am collecting deposits, and will...
September 16th, 2003 10:06 PM
by Ken L Go to last post
4 311
worksheet protection/macro by wally
Hi, I have windows xp, home edition. After protecting a worksheet, which contains formulas, I would like to run a macro to copy and paste the text only of the...
September 16th, 2003 09:50 PM
by wally Go to last post
3 314
Average function by Jeff Kimbell
When I use the average function over a range of cells that includes a cell with "#VALUE!", the function returns with "#VALUE!". The description of the average...
September 16th, 2003 09:45 PM
by Harlan Grove Go to last post
2 505
Vlookup or Match/Index to return value 2 rows down by Donna
I have a spreadsheet where my lookup value is not listed in every row as it is just listed once like a header. Is there a way to create a formula to lookup a...
September 16th, 2003 09:43 PM
by Aladin Akyurek Go to last post
2 293
average f(x) by briank
Any ideas why this won't work? =average(ADDRESS(4,26):address(4,33))
September 16th, 2003 09:36 PM
by Harlan Grove Go to last post
2 343
match formula by donny
I want to create a match formula, I want the formula to look in column A AND B where numeric values are placed and look in cells j1 AND J3 because i have a...
September 16th, 2003 09:19 PM
by Dave Smith Go to last post
3 270
lotus 2.4 macro by Joe Silvers
The following is an example of a simple macro I used in Lotus 123. {goto}E3~ '{?}{D}'{?}{D}'{?}~ {GOTO}C8~'{?}~ Once invoked, the cursor goes to cell E3,...
September 16th, 2003 09:11 PM
by Harlan Grove Go to last post
1 304
Exposant by garnote
Hi all, I have X values in Range("A2":A42") I write x^2, 1-x^2, x^3-2*x^2+12, e^x, sin(x) ... in B1 (Format: Text) and use this macro for obtain graphic...
September 16th, 2003 08:57 PM
by garnote Go to last post
1 303
Excel formulas by D A Brook
Is it possible for data from several sheets in a workbook to be brought forward to a collection sheet by selecting the other sheets from a reference (a list of...
September 16th, 2003 08:24 PM
by Richard O. Neville Go to last post
1 305
Sorting by cell or text format by
Does anyone know of a way to sort a list by the cell format or by the text format? I have a very long list where the 'good' cells have been colored in yellow....
September 16th, 2003 08:21 PM
by Richard O. Neville Go to last post
1 642
Post New Thread


Display Options
Showing threads 87661 to 87680 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 07:12 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.