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
Using formula to calculate a number. by VTM
How do a write the formula or function to satisfy: Y to the x power. In the equation Y= 2 and x power = 3 the answer would be 8.
February 21st, 2005 11:46 PM
by Steve Go to last post
2 191
range and cells syntax by mango
dear all, can help me to clear my doubt. thanks alot 1) all data in bracket for cells and range must be string? cells 2) i do not understand if the row data...
February 22nd, 2005 12:03 AM
by mango Go to last post
0 164
Consolidating entries from multiple worksheets by Al
I am using Excel XP. I have a spreadsheet with 5 worksheets, named Monday to Friday that I use to record details of visits that I make. Within each of these...
February 22nd, 2005 12:14 AM
by Debra Dalgleish Go to last post
1 132
Add "FIND LINKS" to EXCEL Audit function by JN
How do I add this in the Excel workbook? I am trying to find this link in the workbook and want to delete it. Thanks. "Ridgerunner_2" wrote: Sometimes...
February 22nd, 2005 12:19 AM
by Dave Peterson Go to last post
1 343
copy and fuze for MOUS by Jamie
I was hoping someone who has taken the MOUS test for Excel knows how to do the copy and fuze thing, if i spelling it right.
February 22nd, 2005 12:37 AM
by Jamie Go to last post
0 72
Using "IF" statements by Steven
If a returned value=true, how can I change the background color and font? Can I also add a audio alarm if value=true?
February 22nd, 2005 01:20 AM
by Steve Go to last post
1 72
Reading a text file ? by WTG
Help! :( Is there a way to automate the importation of a text file in to Excel, with out having to use the import text wizard every time? Below is a sample...
February 22nd, 2005 01:29 AM
by WTG Go to last post
2 107
Matching an Array in one Tab with an Array with another Tab by LanceMSU
I am trying to match to arrays in two different Excel tabs I will make a sample of each tab. Tabl A B C 12 150 Class 10 150 No...
February 22nd, 2005 02:16 AM
by Myrna Larson Go to last post
4 100
Adding the sum of figures in one column if they meet 2 criteria by Justine Burn via OfficeKB.com
Please help! I have a column of 500 figures. I want to calculate the total value of all figurews between 10000 and 12000 in the column at the bottom of the...
February 22nd, 2005 02:36 AM
by Justine Burn via OfficeKB.com Go to last post
4 127
How do I copy a function for comparison but keep first cell value. by N'wester
I want to run a regression comparing various columns to a single column. I want to be able to drag copy the format while keeping the first column the same. I...
February 22nd, 2005 03:53 AM
by N'wester Go to last post
0 73
Add Function to String by Ronbo
I am looking for a function or (way) to add characters to a text string. It would be like the replace function in that, I know the position of the text to be...
February 22nd, 2005 05:33 AM
by Steve Go to last post
2 79
Multifunction for one cell by JeanC
I need to calculate based on "if "scenarios for the purpose of commission calculations. i.e. if b3 (commission to be split) = 0-$5000. then c3 =b3*50%, if...
February 22nd, 2005 06:11 AM
by Arvi Laanemets Go to last post
1 98
compound interest by David
How can I calculate the amount I would receive in compound interest on a fixed amount at a fixed interest rate for a fixed peirod. Should be easy !
February 22nd, 2005 08:16 AM
by R.VENKATARAMAN Go to last post
2 197
My workbook is slow. by Josh UK
My Workbook is 5 sheets, Ranging Between 100 to 600 rows and max of 13 columns each. It is 87 MB!
February 22nd, 2005 11:05 AM
by Josh UK Go to last post
0 70
Paste Special values only by AJPendragon
I have a spreadsheet - users enter data in the sheet and need to copy to other similar cells. However I want them to only Copy - Paste Special (Values) so that...
February 22nd, 2005 11:05 AM
by WendyUK Go to last post
1 337
Value of the actual Auto Filter by Hans Engen
When I have a coloumn with text and one with number I can make a cell with with the subtotal under the number coloumn - but how do I make a cell with the...
February 22nd, 2005 12:17 PM
by Jason Morin Go to last post
1 155
Need Zeros by Hday
Hi I need leading zeros to be displayed - can anybody help please. Thankyou
February 22nd, 2005 12:34 PM
by Go to last post
2 83
Deletion of rows where a value is satisfied by Larry Wallis
I have a spreadsheet with 3 colums. Columns are headed Part Number, Description and Qty. What I would like to do is delete all rows where the qty value is...
February 22nd, 2005 12:41 PM
by Jason Morin Go to last post
1 82
Sum values according to category (text) by Oscar
I wish to sum cells in a column according to category in an adjacent column
February 22nd, 2005 12:43 PM
by Oscar Go to last post
6 111
I want to send data from one sheet to another by Naguib
Hi Does anyone know how to send data from a sheet in one workbook to another workbook containing the same information? I have a project that I'm doing and I...
February 22nd, 2005 12:43 PM
by Go to last post
1 81
Post New Thread


Display Options
Showing threads 11021 to 11040 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 01:58 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.