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
hlookup to propigate validation table by Gord Dibben
For creating dependent lists with Data Validation see Debra Dalgleish's site. http://www.contextures.on.ca/xlDataVal02.html Gord Dibben XL2002 On Mon, 10...
November 10th, 2003 09:35 AM
by Arvi Laanemets Go to last post
1 372
Calculating new dates by Chip Pearson
Talitha, You can add days to a date by simply adding that number to the date. For example, =A1+90 will add 90 days to the date in cell A1. If you want to...
November 10th, 2003 10:52 AM
by Go to last post
1 193
Summing multiple categories - Help!!! by Andy Brown
You could try a Pivot Table (Data menu). Step1 ; Data = Excel list, Report = Pivot Tbale. Click Next. Step 2 ; select your data on the sheet. Click...
November 10th, 2003 01:06 PM
by James D Go to last post
6 283
Use date document created in formula? by jamieuk
We have a template that requires the user to enter the date they started using the workbook. This date is used in many formulas within the template. Rather...
November 10th, 2003 02:20 PM
by Bernie Deitrick Go to last post
3 301
Comparing Two Text Based Lists by GB
"Paul Talkington" wrote in message ... Hello All I have...
November 10th, 2003 03:45 PM
by GB Go to last post
1 425
External References by Pinda
When one has external references in a workbook, a dialogue box pops up on opening the workbook saying... "The workbook you opened contains automatic links...
November 10th, 2003 03:52 PM
by Pinda Go to last post
2 133
Array Function - cell to remain blank by mare
I am a novice on Excel, however, I don't get easy projects. I have a spreadsheet where D6:D15 have values. In cell D17 is the Total, which is an average of...
November 10th, 2003 04:09 PM
by immanuel Go to last post
1 92
How to Convert Numeric Values into Text Values with a Formula by Vijay
Hello, I want to convert numeric values into text values. Is there any formula for it. example; $133,569.00 i want this number to be automatically displayed...
November 10th, 2003 04:12 PM
by Peo Sjoblom Go to last post
3 410
Assign a multiple commands by Steve Adler
Hi ; Is it possible to assign multiple commands to an excel button. If so , i'd like to create a custom button to paste the copied data as values . Normally...
November 10th, 2003 04:16 PM
by Steve Adler Go to last post
4 242
Change sign of entire column of numbers by mure
Just enter in one cell "-1" , "copy" this celle, then you select your column and make a "special paste" and click "multiply" : this will multiply your column...
November 10th, 2003 04:34 PM
by mure Go to last post
0 460
Dropdown Box to Select Data from Another Sheet by Annabelle
How might this be done? I have an accounting workbook with two sheets, Master and Data Entry. I want to be able to enter data on the Data Entry sheet for each...
November 10th, 2003 04:39 PM
by Annabelle Go to last post
2 506
Copy Data to Sheet2 if cell in Sheet1 is not blank by Max
One way? Assume you have the names in col A, A2 downward in both Sheets1 & 2 In Sheet2 Put in...
November 10th, 2003 04:53 PM
by Max Go to last post
0 478
Compounding by Mike
I would like to know how to compound cash flows now. How do I take a series of cash flows and reinvest them at a continuous factor. let us say 10%. If I have...
November 10th, 2003 05:22 PM
by Kevin Stecyk Go to last post
4 88
RANGE NAMES by BOB F
How can I printout a list of all the range names and cell references used in a workbook?
November 10th, 2003 05:36 PM
by MS Go to last post
1 237
Finding Last Contiguous Column Cell Entry by GBL
Hi: Sorry!! I lost the answered response to this problem (posted about a week ago), so must re-post it again. I have a column (A1:A100) that is only partially...
November 10th, 2003 06:39 PM
by Peo Sjoblom Go to last post
3 197
Locking formulas in cells by Zeina Dahdouh
Hello, I have a problem with locking a formula in a cell. For example: A1 and B1 contain numbers and C1 contains: "=A1*B2". I want to lock it so i make the...
November 10th, 2003 07:06 PM
by J.E. McGimpsey Go to last post
1 360
Paste Less Decimal Places by Niek Otten
You could ToolsOptionsCalculationPrecision as diplayed, but read Help to be aware of the implications -- Kind Regards, Niek Otten Microsoft MVP -...
November 10th, 2003 07:17 PM
by Niek Otten Go to last post
2 511
HELP! Return data if cell in row contains data by dee
Hi, Does anyone know how to do this? Example: If F5 contains data, return the content of cell a1 to a cell on another worksheet. If statements don't work...
(Multi-page thread 1 2)
November 10th, 2003 07:48 PM
by Ken Wright Go to last post
13 924
DATE by Geneva Sachs
Sorry! I'm new at this and tried to send the sample of what I'm working on. This is the formula I've got...
November 10th, 2003 08:36 PM
by Geneva Sachs Go to last post
4 151
Creating a Custom Excel Formula by Beth
Is it possible to create a formula in Excel which will identify a value within a range of cells and create a text base response if that value is located. For...
November 10th, 2003 08:39 PM
by Don Guillett Go to last post
3 234
Post New Thread


Display Options
Showing threads 1961 to 1980 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 12:34 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.