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
histogram by
Im trying to make a histogram, and i can't get it to work at all. I go to tools, data analysis, select histogram, and then i have no idea what to put into the...
September 17th, 2003 06:57 PM
by Tom Go to last post
1 177
Formula needed by
We are trying to workout a formula to do with weight loss. So far we have everything correct apart from one colum and thats column E Column B = Weight in Kgs...
November 25th, 2005 06:07 PM
by Go to last post
2 63
formula question by
Dear At this forumla " =ROUND(IF($I2="N",$F2*2,($F2*2)-$O2),2)" . I want the result as below. 1. Result = + is ok 2. Result = - show "o" Please advice how to...
November 22nd, 2005 09:26 AM
by Max Go to last post
1 64
formula QUESTION by
Dear We have a excel file two column, one is word , one is value. eg as below. Column 1 Column 2 A 1 A1 2 A2 3 A3 ...
November 10th, 2005 01:18 PM
by Ron Rosenfeld Go to last post
2 50
WORKSHEET CONCERNS by
MY WORKSHEET IS READING THE FILE SIZE AS BEING MUCH LARGER THAN IT ACTUALLY IS - THERE ARE ONLY 7 PAGES YET THE FILE LISTS 130 PAGES. ATTEMPS TO DELETE...
June 16th, 2004 03:31 PM
by Frank Kabel Go to last post
1 63
color tabs on excel worksheet by
I am interested in knowing about the excel spreadsheets where u can color code the tabs
May 28th, 2004 06:09 PM
by Harald Staff Go to last post
2 96
Sorting by
I have office xp. I'm new to excel and having trouble sorting a column of names. The sort tool is grayed out no mater what cell I select. If I start a new file...
May 28th, 2004 05:45 PM
by Frank Kabel Go to last post
3 57
Drop-down List by
Go to Data- Validation and then you will choose List (where you will hard code the values in the drop down). Hope this helps. -----Original...
May 8th, 2004 01:02 PM
by Debra Dalgleish Go to last post
1 69
Sumif over multiple pages with two criteria by
Try this Bill, =IF(AND(A1="BOOK",B1="YELLOW"),C1,"") Hope this helps. Jennifer -----Original Message----- I need help with a formula to give a total over...
March 17th, 2004 08:27 PM
by Go to last post
0 192
nested formula help needed by
My experience is Yes, you are limited to seven nested functions. But my question is, do the functions really need to be nested? I ask this because I received...
October 14th, 2003 04:17 PM
by Go to last post
0 167
Symbols or pictures in formulas by
Is there any way that I can make a picture or symbol the result of a formula? If so, how?
October 16th, 2003 10:55 AM
by Chip Pearson Go to last post
1 92
formulas by
I have a spreadsheet which tracks locations of parts. The location is in test format. I want to add up the total of each location to a numeric value. Any...
November 4th, 2003 06:23 AM
by macropod Go to last post
1 63
Calculating Ages by
I am trying to find a formula that will calculate ages in one column based on a birthdate entered into a previous column on a worksheet, that will update on a...
November 5th, 2003 10:28 AM
by Go to last post
2 88
Need Formula the yields same count as my multicolumn filter by
When I filter a multi column table, one column "Pledge" contains only "Y" or (blank). I filter this column to ="Y". The second column "Grades" contain 1 or...
February 14th, 2004 04:44 AM
by Peo Sjoblom Go to last post
2 81
formula not calculating correctly by
The formula in the third column is =L8/M8. I have the third column formatted as Percentage with no decimal positions. As you can see the cells with an...
March 9th, 2004 01:18 PM
by Jerry W. Lewis Go to last post
3 56
Formula Help!!! by
Dear We have a excel file. I want create a report . Our worksheet information as below. 1. A column as 20 field , a special field type "YES" ( NOT ALL...
February 27th, 2006 12:49 PM
by Go to last post
4 57
What does the ! stand for in formulas? by !
I am looking at a formula made by someone else and it has the ! in it. Please tell me what this means.
March 14th, 2005 09:15 PM
by Fredrik Wahlgren Go to last post
1 67
TAN different to a calculator? Please help would be appreciated lo by !!HELP!!
Hi, I am doing my GCSE at the moment and I have come up with a fomula to calculate the area of any polygon. My formula includes TAN but when I use the TAN...
December 15th, 2005 09:43 PM
by MrShorty Go to last post
5 63
December 23rd, 2005 12:06 AM
by JE McGimpsey Go to last post
1 65
Cell converts a date entry to "=" and displays "01/00/00 by ##
A spreadsheet previously created changes a date entry to "=date typed in" and displays "01/00/00" no matter what format has been applied to the cell.
April 8th, 2005 02:51 PM
by bj Go to last post
1 61
Post New Thread


Display Options
Showing threads 321 to 340 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 03:15 AM.


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