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
how? by
September 22nd, 2003 03:13 PM
by Pierre Go to last post
2 93
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 69
Need simple macro by
Hi All In Excel 2002 Column A cells 1 to 20 has data in them, Column B1 has data in it, I would like to have a macro that would copy the data from B1 to all...
June 6th, 2004 06:04 PM
by Gord Dibben Go to last post
3 54
formula help by
i need help =if(K740,K7-40,0) now k7 is going to equal =sum(C7:J7) but if K5 .00 then K5 needs to be subtracted from K7 i need help righting this formula
June 18th, 2004 01:34 PM
by Go to last post
7 62
locking spreadsheets by
is it possible to lock my spreadsheet so that the formulas can only be changed by me with a password or something, so that if someone else is using my...
June 18th, 2004 06:11 PM
by Go to last post
2 73
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 80
look up a value in another sheet bases on vaues ound in another cell by
Does any one know how to get a value from one worksheet to put in another. for example on sheet 2 would be 3 columns. the values in the first 2 columns would...
July 14th, 2004 05:34 AM
by Go to last post
6 67
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 69
Status Bar Auto Sum by
In Excel 97 if select mutiple cells the sum of the cells selected would be displated at the bottom right in the status bar. Is this availible in Excel 2002 if...
September 3rd, 2004 04:43 PM
by Debra Dalgleish Go to last post
2 70
Round function - round to 5 by
-----Original Message----- I'm trying to round to 5 but can't figure it out. Decimals are clear, so is round(xx, -1)... but: 26 should be 25 27 should be...
May 18th, 2004 11:36 AM
by Go to last post
0 125
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 09:33 PM
by Frank Kabel Go to last post
1 76
I have macros setup in a worksheet with macro buttons set to run these macros. Everything was running fine until I saved this worksheet to a different name....
October 20th, 2003 02:48 PM
by Go to last post
0 141
function by
i am not sure how to do this. I have a narray of numbers in colum a (a4:a121) of either 1 or 2. In colum f (f4:f121) is the same array. I would like a formula...
October 23rd, 2003 12:29 PM
by Jason Morin Go to last post
4 71
excel print formula by
I cannot seem to print the formulas on a excel 2000 spreadsheet?
October 23rd, 2003 03:45 AM
by Michael Puk Go to last post
2 82
formulas by
can I get the cube root of a number? All I see available is the square root.
November 15th, 2003 08:16 PM
by Go to last post
2 78
Name conversion by
I have a spreadsheet that is updated by multiple users. When they enter their names they enter it in the format (first_name Last_name). Does anyone know how I...
November 18th, 2003 04:35 AM
by immanuel Go to last post
1 61
MSNStockQuote by
I have installed the add-in but the formula is bringing back the error message. As for more info...I am wondering if there is some way to determine if the...
January 17th, 2004 02:28 AM
by Ron Rosenfeld Go to last post
1 65
converting imported numbers by
I have imported a text file containing numbers that I need to change/move the decimal left 2 places i.e I need convert/change 123 to 1.23, 123456 to 1234.56...
January 30th, 2004 05:51 PM
by Go to last post
4 132
Normal Distribution by
Have you tried using the statistical analysis tools? Perform an analysis of variance (anova) Correlation analysis tool Covariance analysis tool Descriptive...
April 1st, 2004 01:34 PM
by Jerry W. Lewis Go to last post
4 245
$ function in a claculation by
PLease explain to me what the Symbol above does, thanks
September 3rd, 2004 07:09 PM
by Frank Kabel Go to last post
1 59
Post New Thread

Display Options
Showing threads 201 to 220 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 07:07 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 OfficeFrustration.
The comments are property of their posters.