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 Reverse Sort Order / Thread Starter Last Post Replies Views
### by acomputer4u
### appears when putting a number into a field. How do I get rid of this format?
November 20th, 2006 11:59 PM
by acomputer4u Go to last post
5 66
### Download Hot Babes Shooting Guns ### by Larry Bird[_2_]
Wet and Wild edition http://militarybodyarmor.blogspot.com/2008/10/law-enforcement-certifications.html
October 18th, 2008 06:37 PM
by Larry Bird[_2_] Go to last post
0 74
### in row & won't "auto fit" - how do I show all text? by lorrainef
I can't get my rows to "auto-fit" to correct height allowing all text to be seen. I select the row then go to FormatRowautofit, but this does not add to...
May 30th, 2007 01:40 AM
by Gord Dibben Go to last post
2 63
### when the number is NOT negative? by molly
using =SUM(G2:I2) it comes up at ## but there it shouldn't be a negative value??
March 30th, 2005 01:05 AM
by Gord Dibben Go to last post
5 81
####### ? by bill gras
please help I have a array formula as follows =INDEX(st5!$C$1:$C$1800,SMALL(IF(st5!$A$1:$A$1800=D4,ROW (st5!$A$1:$A$1800)),ROW(st5!$1:$1))) when there is no...
September 9th, 2004 03:05 AM
by bill gras Go to last post
3 69
####### return by C.[_3_]
Hi all, When I use the following...
December 5th, 2008 08:32 PM
by C.[_3_] Go to last post
6 57
########### error by tre
I have a fresh cell created (no formulas) - When i type in a line or two of text, it does not wrap the text, or increase the size of the cell. I can see...
August 2nd, 2007 04:16 PM
by Dynamite Go to last post
3 60
########? by bill gras
please help I have a array formula as follows =INDEX(st5!$C$1:$C$1800,SMALL(IF(st5!$A$1:$A$1800=D4,ROW (st5!$A$1:$A$1800)),ROW(st5!$1:$1))) when there is...
September 9th, 2004 07:04 AM
by Frank Kabel Go to last post
3 61
##name? in cells of spreadsheet by Shawn
I received a call from one of the users I support on the job yesterday, she has a spreadsheet displaying "##name?" in a few cells of spreadsheet. When the...
May 3rd, 2007 06:50 PM
by Dave Peterson Go to last post
4 47
##value error by Sue
Can someone please help me with an error message for the following...
(Multi-page thread 1 2)
November 15th, 2005 01:36 PM
by Roger Govier Go to last post
11 154
#2: VBA to Pick Range and letter by TomorrowsMan
Thanks for your help yesterday; today, it seems to complicate way past my VBA abilities. We now have 7 letters (1A-7G). What they'd like to do is: 1. ...
November 17th, 2006 07:57 PM
by TomorrowsMan Go to last post
2 74
#Adding new worksheet problem by Sandeep Lohchab
Sir, How to add new worksheet on right side of current selected worksheet? When I press Shift+F11, new worksheet comes on left side, but I want it to appear...
January 14th, 2010 02:26 PM
by ryguy7272 Go to last post
2 60
#DIV/0 error by Daniell
What I am working with is a simple divide statment using two worksheets. =('Product'!P20/'Product'!P21) If the answer comes out to zero I get the #DIV/0!, is...
May 25th, 2009 05:11 PM
by JoeU2004 Go to last post
6 62
#Div/0 error, can't get rid of it by John
Hi Everyone I use this array formula and it works well, =IF(COUNT(J5:J36)1,"",AVERAGE(IF(J5:J360,J5:J36,""))) But if I only have 0 in that column, I get...
December 19th, 2009 09:32 PM
by John Go to last post
8 87
#div/0 errors and blank cells by dinouk
Hi wondering if anyone can help me with this one... Have 31 cells in a row which i want to get the average value from, some of these 31 cellsmay or may not...
July 15th, 2007 10:39 PM
by T. Valko Go to last post
7 67
#DIV/0 ERRORS IN PIVOT TABLES by [email protected]
I am looking for a way to remove the #DIV/0 errors in pivot tables that have formulas - to neaten it up - and I am not sure how to do it in the new version...
September 23rd, 2009 01:13 AM
by [email protected] Go to last post
0 49
#DIV/0! by
I've got a YTD spreadsheet that will be fed each month from monthly spreadsheets... In some of the cells within the monthly spreadsheets it is #DIV/0!... As...
September 8th, 2004 07:02 PM
by Frank Kabel Go to last post
1 90
#DIV/0! by Kati[_2_]
I need to get rid of this error. My formula is as follows: =+(Data!X8+Data!X9+Data!X10)/((Data!G8+Data!G9+Data!G10)-(Data!AO8+Data!AO9+Data!AO10)) All of the...
October 25th, 2008 10:27 PM
by ShaneDevenshire Go to last post
4 67
#DIV/0! by KelD
I've read almost all of the threads. Now I'm REALLY confused. I need to get an average using data that is put in by the user. I'm adding a bunch of cells...
August 27th, 2009 04:56 PM
by Luke M Go to last post
1 36
#DIV/0! by PAL
I have a table that is performing a lot of calculations. Because there is no data yet to complete the formula I get the "#DIV/0!" error. Is there a way to...
December 26th, 2007 09:01 PM
by Teethless mama Go to last post
5 88
Post New Thread

Display Options
Showing threads 101 to 120 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 04:47 PM.

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