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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
=NOW() from changing by Richard
I can't remember how I did it before but I add something to the now() formula to keep the date from changing, can anyone help? If(b2="","",Now()) or some...
February 28th, 2008 01:36 PM
by JE McGimpsey Go to last post
5 66
=PRODUCT by billy-bob
i'm trying to generate an automatic form (which will locked down) within the hiden E columm if have a list of numbers, so when i pick 'p' (this is a tick mark...
August 4th, 2008 12:10 PM
by billybob Go to last post
6 86
=PROPER by Snowcap
Using Excel 2003. Have downloaded info and it was downloaded in all caps. Have tried to use the =PROPER formulat but it doesn't work. If I go to a separate...
January 21st, 2005 02:46 PM
by Lady Layla Go to last post
1 126
=PROPER by Snowcap
Using Excel 2003. Have downloaded info and it was downloaded in all caps. Have tried to use the =PROPER formulat but it doesn't work. If I go to a separate...
January 21st, 2005 01:19 AM
by Snowcap Go to last post
2 81
=PROPER() by Mukesh
I want to , I tried using =proper(), but the result I get is , I want all the capitals to be small, is it possible? Please...
June 6th, 2009 06:45 AM
by Mukesh Go to last post
2 131
=RAND produces decimals not whole numbers by moosegate
I am a teacher making randomised equation sheets for young children in my school, along with simultaneous answer sheets for teachers to speed up marking,...
November 20th, 2006 10:33 PM
by Tushar Mehta Go to last post
9 87
=RATE(17,1,-5) returns #NUM! but the answer should be about 18.9 by hapster
Is there a way to get this function to generate the correct answer? Essentially, I am trying to get the IRR for a cash for of $1 per year for 17 years given a...
April 25th, 2006 03:29 AM
by Fred Smith Go to last post
2 80
=ROUND((ROW()-10)!G$66,L$3) ... what's the error? by tripflex
Okay so an older spreadsheet i have had the code as this: =ROUND('2'!G$66, L$3) Basically the 2 is referencing the sheets because they are numbered 1-100. ...
March 10th, 2009 03:03 AM
by Ron Rosenfeld Go to last post
3 108
=SF_Load!A2 by Jim
Hello, how would I change this formula (=SF_Load!A2) so it shows a nothing if the cell it's refeerencing is blank. It currently shows 0. Thanks
December 24th, 2009 12:31 AM
by Dave Peterson Go to last post
2 92
=Sheet!A1 formula alternative by RLD
I have 2 sheets. Sheet 1 contains text data from A1:A200 but not in consecutive order (for example): Sheet1 A 1 textone 2 texttwo 3 4 textmisc 5
March 18th, 2010 11:27 PM
by T. Valko Go to last post
2 126
=Sheet1!A1 - with a blank entry!!! by CP
Sheet1 A1 is transfered to a cell on Sheet 2 via =Sheet1!A1, I then print sheet 2 - however sometimes cell A1 is left blank which is returning a 0 value on...
May 26th, 2009 11:00 PM
by CP Go to last post
2 139
=Sheet2!G60 (Enter) Box appears "Update Values" by Gatsby
I want a cell in sheet 3 to update when I input data into cell G60 in sheet 2. In the cell in sheet 3 I've typed : =Sheet2!G60 When I press enter, a box...
February 10th, 2007 01:25 AM
by Gatsby Go to last post
0 73
=SIMILAR by Andrew Mackenzie
Is there a way to compare text in two cells to see if they are similar (the pairs of cells may be similar in different ways e.g. to...
September 30th, 2004 01:06 PM
by Jim Rech Go to last post
1 102
=SMALL(A1:A10;6) returns #NUM error by CWatters
I'm trying to use =SMALL(A1:A10;6) to find the 6th smallest number in A1:A10 but it returns a #NUM error if there are only 5 fields in the array containing...
July 14th, 2004 02:35 AM
by Ron Rosenfeld Go to last post
2 97
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE.... max. limit 8 :( by [email protected]
I'm having a problem while using excel 2002. I have an estimated amount of 3500 cells containing text. I also have 450 words and for all of them I have...
May 22nd, 2008 05:33 PM
by T. Valko Go to last post
6 106
=sum #value! error by TanaMary
I did a spread sheet to track payments and the percentages of those payments bi-monthly over a 12 month period. There are 6 percentage columns total for...
August 12th, 2008 07:05 PM
by Peo Sjoblom[_2_] Go to last post
9 95
=sum not working by SLP
Hello. I am trying to do an =sum for 205 rows. The result is 0. I checked Tools | Otpions -- Automatic is set. The cells leading into the =sum are...
November 28th, 2007 10:26 PM
by SLP Go to last post
8 89
=SUM problems in totalling figures by the-chosen-one
Hi There, Im new here and wonder if u guys can help.....I have excel from office 97 and have found a problem when doing a simple column...
January 25th, 2009 11:09 PM
by Dave Peterson Go to last post
2 101
=SUM Ranges Do Not Update by Country
I have a Excel 2000 spread sheet, with the following macro to insert a new row. Sub InsertRow() ' ' Macro1 Macro ' Macro recorded 4/27/2004 ' 'GoTo label,...
August 24th, 2004 01:27 AM
by Country Go to last post
2 74
=SUM('Wkly stats'!$E6) How do i unfreeze the 6 when i drag cell by AP1927
I have place a string infront of E because thats the column i require. I want to unlock the 6 so the number changes 7,8,9 as i drag the formula across..
April 5th, 2006 05:17 PM
by Dave O Go to last post
1 85
Post New Thread


Display Options
Showing threads 2001 to 2020 of 139764
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 04:23 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.