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 Reverse Sort Order Last Post Replies Views
Compounded Annual Growth Rate by
What is the function for calculating the componded annual growth rate?
October 8th, 2003 03:26 PM
by Bernard Liengme Go to last post
1 249
Excel by
I have a column with six numbers. I made them to be text. Now I want to separate the whole column into 2 columns one with the first three numbers & one with...
May 24th, 2004 09:49 PM
by Frank Kabel Go to last post
1 103
multiple sheets by
is it possible to copy a section (example A5:M9)of sheet 1 that each cell has a different formula and paste the cell values to a spreadsheet on sheet 2?
July 13th, 2004 01:50 AM
by Nimit Mehta Go to last post
4 115
email? by
Can i email someone a small section of my spread sheet that im having trouble getting to compute correctly. i don't think i could do a good enough job...
July 13th, 2004 08:23 AM
by Frank Kabel Go to last post
3 135
Tally matches?? by
Would like to have a worksheet that keeps a running tally of the number of times a specific value occurs in several other worksheets. Is there a way to count...
July 14th, 2004 04:31 PM
by Go to last post
2 179
Help please by
when working with decimals the below formula works, but sometimes in c5:j5 i have whole numbers too like 8.15, 6.30 wich should equal to 14.45 but i am not...
July 21st, 2004 09:46 PM
by Go to last post
7 105
Watermarks by
Does anyone know how to make watermarks? By this, I mean, if I have a template already made up, and I want to put it into a binder of other documents, I want...
July 21st, 2004 04:46 PM
by Ron de Bruin Go to last post
1 253
help adding to my formula by
the following formula is what i need help with it has most of the properties of the formula below it but im trying to add this part of the formula...
August 4th, 2004 07:15 AM
by Go to last post
5 127
Copying Data Horizontally from Vertical List by
On Sheet1 I have a Column of data, call it ColA. On Sheet2 I'd like to transfer Sheet1!A1 to Sheet2! A1...simple enough. =Sheet1!A1 entered in...
August 27th, 2004 01:42 PM
by Go to last post
2 91
Dynamic Ranking by
I have 8 columns that need to be "re-sorted" everytime there is a real-time stocl price change. I am using the Large function to sort the price change, then...
May 20th, 2004 08:51 PM
by Peo Sjoblom Go to last post
1 107
variable reference in hlookup array by
Hi, I have many Hlookup functions in which the array is in one of many sheets, all named with a number (say 1000). Since there are many of these numbered...
May 10th, 2004 10:13 AM
by Harlan Grove Go to last post
4 269
FORMULAS by
I NEED A QUICK AND EASY WAY TO HAVE DATA I'VE ENTERED INTO MY INVOICES ( WOOKBOOK 1 ), ALSO ENTER INTO ( WOOKBOOK 2's) SPREADSHEET. THE PROBLEM I CANT SOLVE IS...
October 14th, 2003 01:25 PM
by David McRitchie Go to last post
3 147
Excell worksheets by
Iam using office 95 for my work and have just bought a new computer with windows xp. I have loaded my office 95 with no problem but it will not open my excell...
October 18th, 2003 09:54 AM
by Ken Wright Go to last post
2 244
Excel 2002 cell format by
How do I format a cell to display a number range like 7- 11? No matter how I format it the cell is displayed as a date or a number 37813.
October 26th, 2003 07:18 PM
by J.E. McGimpsey Go to last post
1 400
excel auto save settings not retained by
I'm running XP Home and Excel 2000. My auto save settings (interval and not requiring a prompt to save) are not be retained after closing and reopening...
February 15th, 2004 08:33 PM
by Peo Sjoblom Go to last post
3 359
date format by
any ideas as to why when I trim a date column I lose the mm/dd/yy format. The cells go to excel date code. If I go to check the format in properties it tells...
February 16th, 2004 08:23 PM
by Gord Dibben Go to last post
1 358
custom format by
hi! I am not sure if this is possible. i want to custom format a cell in the form of "R1 SB-1 1" when "1B11" is entered. this is because the letter 'B' will...
March 12th, 2004 10:33 PM
by Frank Kabel Go to last post
1 201
SUMIF cells in column contain specific month by
Assume that column A (rows 2-7)has dates in it and Column B (rows 2-6)has $ amounts. I want to sum the amounts in Column B for those rwos where the month in...
April 8th, 2004 12:49 AM
by Go to last post
3 232
Questions about IF Function by
My workbook contains two worksheets. One of the sheets is used to query a database and return select columns of data. The other worksheet is used to organize...
April 29th, 2004 04:46 PM
by Charlie Go to last post
1 153
PIVOT TABLE PROBLEM by
Hello everyone, I got a little problem with the pivot table report cause each time I do one, there some decimals that get add up some of my numbers like in my...
August 27th, 2004 07:14 PM
by dave Go to last post
3 190
Post New Thread


Display Options
Showing threads 281 to 300 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 11:57 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.