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
enter a null or "blank" value in a cell by
How do I get an Excel Function to place a NULL value in a cell vs. a blank or space. Here an example: Cell A1 contains the number 11, when I enter the formula...
October 16th, 2003 08:48 PM
by Harlan Grove Go to last post
1 148
serach multiple worksheets within a workbook by
Is it possible to search for information in multiple worksheets within a workbook at the same time rather going into the individual tabs and using...
July 12th, 2004 06:29 AM
by bigt Go to last post
2 109
Autosum by
What ever happened to the Autosum button? Is this no longer availl in excel 2000?
July 14th, 2004 08:26 PM
by Alan Go to last post
1 76
Excel hyperlink to jpg always opens with I-net Exployer by
I need to open a .jpg file pointed to by a hyperlink in a cell, with an application that will allow zooming. I have set the jpg to always open with "Paint" or...
July 18th, 2004 03:08 AM
by Go to last post
0 132
finding the difference in years between dates by
Hi I need a formula which will work out the difference in years between two dates to calculate age. For example if I type 8/8/1984 into A1 and 8/9/2004 into A2...
August 19th, 2004 10:58 PM
by Frank Kabel Go to last post
5 95
Average by
I'm trying to average a group of numbers. I do not want to include the blank or zeros. I used the following to exclude the zeros but it is still including...
August 20th, 2004 04:39 AM
by Harlan Grove Go to last post
4 84
PIVOT TABLE PROBLEM by
Hello everyone, I got a little problem with the pivot table report cause each time I do one, there some decimals that get add up some of my numbers like in my...
August 27th, 2004 07:14 PM
by dave Go to last post
3 68
Convert Number into Text by
In one column, I have numbers (120-1200). In another column, I would like corresponding Alphabetical representaion of the numbers. Eg A1 = 123.56 then B1...
September 13th, 2004 05:26 PM
by Frank Kabel Go to last post
3 72
Automaiticly move from one cell to the next by
Need to automatically move from one cell to the next after entering data in a cell. Using a worksheet to scan in receipts as the are being offloaded from a...
September 30th, 2004 02:03 PM
by Bob Lounsbury Go to last post
3 73
wrapping text in an if statement by
I want to force the text in an if statement to go to the next line... I tried to place a ALT Return at the appropriate place but I get a empty box instead of...
June 11th, 2004 02:03 PM
by Bernie Deitrick Go to last post
2 45
Excel formula - select cells based upon fill color and then sum by
-----Original Message----- I want to sum data baed upon the fill color. An existing spreadsheet has been manually shaded to show the "selected cells". ...
May 13th, 2004 07:45 PM
by Go to last post
0 710
Blanks vs. Null values in Functions by
How do I get an Excel Function to place a NULL value in a cell vs. a blank or space. An example: Cell A1 contains the number 11, when I enter the formula...
October 17th, 2003 12:02 PM
by Paul Go to last post
1 168
Solver by
When i ask solver to create a sensitivity report, solver only prints up half of the langrange multipliers. Does anyone know how to get the others printed up. I...
December 11th, 2003 12:12 AM
by Tushar Mehta Go to last post
1 66
How to lock one cell in formula? by
There are two types of cell references -- relative and absolute. When a relative cell address in a formula is copied, the actual address is modified to...
December 26th, 2003 01:22 PM
by orlando Go to last post
2 184
Changing date format to text only by
format the cell as mmmm dd"," yyyy will give the result, set it up as a custom format, Format Cells Custom (at the bottom of the drop down list box) set up...
January 1st, 2004 07:37 AM
by Go to last post
0 174
Formula to combine cells (A challenge!) by
Hi, tried my best to find the answer through the HELP menu and the knowlege base...but unsucessfull. I have an expense tracking Excel file, with worksheets...
January 12th, 2004 01:59 AM
by Norman Harker Go to last post
4 66
rounding formula by
Is there a way to round a number to the nearest .5 - ie .5, 1.0, 1.5, 2.0, 2.5, 3.0, 3.5 etc TIA
February 5th, 2004 11:05 PM
by Go to last post
3 50
Count specific information in a certain range by
What formula does this: I want to count how many of PA are between 20 & 40... How do you do that? State Units PA 21 PA 42 RI 10 RI 5 RI ...
March 17th, 2004 12:27 AM
by Aladin Akyurek Go to last post
1 62
Leading zero's in text join by
if it is formatted as text, it should not strip off the leading 0. -----Original Message----- I have 4 colums a,b,c,d I use A1&" "&B1&", "&C1 in colum d...
March 26th, 2004 09:35 PM
by Go to last post
0 164
September 29th, 2004 11:36 PM
by JMay Go to last post
4 62
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 12:36 PM.


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