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
Worksheet updates by cherri isbell
Is it possible to have one worksheet automatically update a master worksheet?? I have 8 worksheets, and I have one master worksheet. When I make changes to...
September 16th, 2003 07:35 PM
by Sandi Go to last post
1 461
Bullet Points by Sean
How do you add bulet points in a cell?
September 16th, 2003 07:47 PM
by Peo Sjoblom Go to last post
1 473
date f(x) by briank
I am trying to automate an average function. At the present I am trying to average six columns. Next month there will be new data and thus the average range...
September 16th, 2003 07:51 PM
by Ken Wright Go to last post
2 298
View problems by Lynn
I have a worksheet created by another user that I am working with. My view of the file is in black and white only and none of the cell colors are displaying. ...
September 16th, 2003 07:51 PM
by Ken Wright Go to last post
2 370
Formulas not automatic by Jessica
I have some formulas that I have dragged down from other cells and they do not automatically calculate. What I mean by that is the formula is based on the...
September 16th, 2003 08:11 PM
by Ken Wright Go to last post
1 289
Macro to add cell value to refering cells formula by Todd
Hi, I am trying to build a macro that adds 1 months depreciation to a cell everytime it runs. = 7.85 + 7.85 + 7.85 is how the result should look. Something...
September 16th, 2003 08:14 PM
by Todd Go to last post
1 489
spreadsheet question by koxo12
I have conected 3 sheets but if I change something in one sheet other two will change only if I open them. Can I update other sheets without opening them?
September 16th, 2003 08:18 PM
by Richard O. Neville Go to last post
1 338
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
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
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
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
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
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
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 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
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
"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
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
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
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
Post New Thread


Display Options
Showing threads 101 to 120 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 05:43 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.