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 Last Post Reverse Sort Order Replies Views
Seperating information in a cell by andyK
What formula can be used to sepearte information in a cell and put into several cells? I exported infromation contained in a pdf file into Excel. In one of...
August 5th, 2008 06:15 PM
by Rick Rothstein \(MVP - VB\)[_1034_] Go to last post
9 39
FIND function does not return ZERO when text is not found by DOUG01A
Why does the FIND("search text", "within text") function return "#VALUE" instead of ZERO (0) when the search text is not in the 'within' string? #VALUE does...
August 5th, 2008 05:56 PM
by Peo Sjoblom[_2_] Go to last post
5 68
Complex formula by steve
Hi I need some help,please. I need a formula to claculate a value when input A and B are inserted. The table below details the values I am working with and...
August 5th, 2008 05:55 PM
by John C[_2_] Go to last post
5 63
Summing differences with multpile criteria by TT
I want to sum the difference between each row in 2 columns of data for each case where row(i) in column A 0 and row(i) in column B is less than column A
August 5th, 2008 05:53 PM
by T. Valko Go to last post
1 64
August 5th, 2008 05:42 PM
by Gina[_3_] Go to last post
3 99
Dropdown box display only data dependent on another dropdown box? by Chris
I would like to create on dropdown box with the state and then a second drop down box display only the counties for the state that was chosen in the first...
August 5th, 2008 05:01 PM
by Chris Go to last post
8 57
Copying formulas between sheets and keeping original ref by Walter
Hi all I have been trying to copy some formulas from a tab to another in the same worksheet. what i want to do is to keep the original references of the...
August 5th, 2008 04:40 PM
by Gord Dibben Go to last post
8 58
Merge & Sort Dynamic Lists w/ Data Validation by retailmessiah
First off, let me say thanks to the Excel Usenet community that has helped me over and over through these newsgroups. You are phenomenal. Question 1: I need...
August 5th, 2008 04:20 PM
by Ken Johnson Go to last post
3 77
How do I add (say 13) working days to an existing date? by ship
Hi How do I add (say 13) working days to an existing date? With thanks Ship Shiperton Henethe
August 5th, 2008 04:20 PM
by John C[_2_] Go to last post
3 59
Formula using worksheet names 2 by E
My original question dates from 31st July, and was helpfully answered. Unfortunately I am now stuck on a similar problem, which I thought would be easier. I...
August 5th, 2008 04:05 PM
by Pete_UK Go to last post
5 56
How to pull in rows based on Column A data? by Chris Lukowski
I have a need to dump data into a main worksheet and have multiple supplementary worksheets populate their data based on the value in column A. Example:...
August 5th, 2008 03:59 PM
by Chris Lukowski Go to last post
2 53
Formula using worksheet names by E
I have several sheets, called say Code 1, Code 2 . . . Code 10, each with a table culminating in a total budget figure, which is in the same cell on each...
August 5th, 2008 02:54 PM
by David Biddulph Go to last post
8 67
How can I format a cell to have the same text with a number by kpt
I need to format a cell to have deg/sec follow when ever a number is entered. I found where in custom formatting there is a +/- sign that is automatically...
August 5th, 2008 12:55 PM
by macropod[_2_] Go to last post
2 67
Countif - shown blank cell by Marie
im trying to count the amount of times 'Red', blue, black etc is mentioned in colounm K in worksheet 1, as i am entering the formula on a summary sheet. the...
August 5th, 2008 12:20 PM
by Wigi Go to last post
1 56
how do i send an automated email from excel using an if statement by Daniel
I have a spreadsheet that has a function that manages the maintenance of equipment. when an item goes past a certain date, a box in the same row goes from...
August 5th, 2008 11:07 AM
by Daniel Go to last post
0 51
Logical IF statements by Matt
When using the IF statement: IF(logical_test,value_if_true,value_if_false) Is it possible to reverse the syntax? For example, can =IF(A1=1,"very low") be...
August 5th, 2008 10:39 AM
by David Biddulph Go to last post
3 44
How to protect a cell with conditional format? by Ruby
Hi I have a work sheet with 20rows and few hundred columns.All the cells has different values and so has different conditional format.the worksheet is...
August 5th, 2008 10:32 AM
by Gary''s Student Go to last post
1 62
Summing a variable range by Ram B
I need to create a formula for summing cells say B2 through J2 with results in A2 so I use the formula =sum(B2:J2) As you see I am summing 9 cells. What I...
August 5th, 2008 08:50 AM
by Stefi Go to last post
6 57
Excel 2007 lookup problem continuing ... by Trish
Hi, I posted a question last week and M Kan was helpful. However, I asked further questions and this person has not responded. Can anyone else help me?...
August 5th, 2008 05:46 AM
by Trish Go to last post
3 70
how do i use symbol of degree in excell work sheet using key board by amitwills
to use symbol of degree " ° " I have to go to start+programs+accessories+systom tools+character Map+search for degree U+00B0:DEGREE SIGN KEY...
August 5th, 2008 05:14 AM
by Gord Dibben Go to last post
2 81
Post New Thread


Display Options
Showing threads 22041 to 22060 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:06 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.