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
Can you keep column (field) names visible while scrolling downwar. by MichaelG1947
Is there a way to keep the column (field) headings ("name", "address", "status", etc.) visible when scrolling through your spreadsheet? I am using Windows XP...
January 13th, 2005 03:50 AM
by Jason Morin Go to last post
4 185
Break a link/formula but keep the data? by Trang
I receive a file where the sender used a link to his own source, but he does not send me his source. When I open the file I can see the value of the linked...
January 13th, 2005 04:12 AM
by Dave Peterson Go to last post
4 153
SUBTOTAL and then count with criteria by Jane
Afte auto-filtering specific categories, I then need to count values =1200, =3600, etc. I'm familiar with SUBTOTAL but basically need a SUBTOTALIF type of...
January 13th, 2005 08:04 AM
by Aladin Akyurek Go to last post
3 115
Fourier Analysis by Bruce
How does one use the Fourier Analysis in the Data Analysis Tools? Are there any examples available?
January 13th, 2005 08:30 AM
by Harlan Grove Go to last post
1 238
Q: compare and replace in a workbook by Arnfinn Hakkebo
I have data like this: A B C D E F G 121102 MENY...
January 13th, 2005 12:08 PM
by Max Go to last post
1 65
Compound interest calculation by Ira Hayes
I think my bank is underpaying me interest on a 5 year certificate of deposit. How can I calculate the interest I should get on, say, $2,500 for a five year...
January 13th, 2005 01:20 PM
by Ira Hayes Go to last post
2 197
Average by Hague2
Column A1:A10 has a 0 or 1 in each cell, Column B1:B10 has numbers. I want to be able to select the 0 (zero's) in Column A and AVERAGE only those numbers at...
January 13th, 2005 02:36 PM
by Jerry W. Lewis Go to last post
2 104
Statistical Functions by Beth
Is it possible to calculate CV% (Co-efficient Variation)? Thank you
January 13th, 2005 02:57 PM
by David Go to last post
7 162
Formula needed by Edgar Thoemmes
I need to be able to work out the percentage of certain orders placed by certain groups. In column A I have numbers which determines what kind of order it is,...
January 13th, 2005 03:07 PM
by Jason Morin Go to last post
3 87
VLOOKUP is not sufficient by ASHISH SRIVASTAVA
How to map items of different columns and to get result in different column when exactly matched?
January 13th, 2005 03:45 PM
by JulieD Go to last post
1 95
Should Merging workbooks pick up new data or only edited data? by Peggy L.
When I merge shared workbooks, I seem to pick up "edited" data but not newly added data (for instance additional rows of data)? What is the fix for this?
January 13th, 2005 06:31 PM
by Peggy L. Go to last post
0 220
excel by Blessingspoint
What is the formula for dividing a number by 4 in excel
January 13th, 2005 07:25 PM
by Peo Sjoblom Go to last post
1 77
multiple vlookups by inthestands
I need to compare matches for different months for customers and the products that they purchase. So I need to match three items; the customer, the item, and...
January 13th, 2005 07:35 PM
by inthestands Go to last post
0 248
in excel - i have a row of cells i need to make 'unique' and do n. by gtoffice
i have records that i do not want duplicated on the worksheet, how do i set excel spreadsheet up so that 2 of the same numbers cannot be inputted?
January 13th, 2005 07:54 PM
by Niek Otten Go to last post
1 149
=SUMPRODUCT and =IF by Jim
I currently use the following to count the number of occurrences that time shows on my report. This is a great...
January 13th, 2005 08:25 PM
by Jim Go to last post
3 92
Nested if, sum & vlookup Function by Trying to excel in life but need help
I will try to explain clearly what I am trying to accomplish. I hope this makes sense. I work in the transportation iindustry and have the dubious pleasure...
January 13th, 2005 08:29 PM
by Trying to excel in life but need help Go to last post
4 256
excel by Blessingspoint
What is the formula for dividing a number by 4 in excel
January 13th, 2005 09:29 PM
by Myrna Larson Go to last post
5 89
How to convert a decimal number to a non-decimal number? by snickers22
I'm looking to convert a decimal number(3.75) to a non-decimal number(375) using a formulas. as I have hundreds of these to do.
January 13th, 2005 11:04 PM
by Ken Wright Go to last post
4 345
How do I view the actual numeric value of a formula in Excel 2002. by Excel Function Help
In MS Excel 2002 I am unable to see the numeic formula in the worksheet. (i.e. if you add "2" to cell ref A1 and "2" to cell ref A2 and sum the figures you...
January 13th, 2005 11:07 PM
by Excel Function Help Go to last post
0 429
% of Schedule Calculation by Mike Pandher
Hi all!! Unique problem here - at least I have not found the answer yet. I am certain one of you can help. I have the following 3 columns: Report...
January 13th, 2005 11:21 PM
by Myrna Larson Go to last post
1 112
Post New Thread


Display Options
Showing threads 9941 to 9960 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 02:15 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.