Worksheet Functions - Page 458

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.

Thread / Thread Starter	Last Post	Replies	Views
Should I be using IF to find how many times a word occurs in a ran by ruthie_toothy Hi I have an area B3:AF78 and I need to know how many times the word "Ruth" appears within this range. Each cell only contains one name. I will need this...	July 15th, 2009 01:35 PM by ruthie_toothy[_2_]	4	185
Separate text and replace characters by NBVC[_95_] Try: =LEFT(SUBSTITUTE(A1,".","-"),7) and =RIGHT(SUBSTITUTE(A1,".","-"),7) --	July 15th, 2009 01:34 PM by NBVC[_95_]	0	155
Count records where date is within the last week by pmjb007 I need to count the number of records that have had a date set within the last week. For reporting other statistics in the same worksheet, i'm use DCOUNTA,...	July 15th, 2009 11:41 AM by Jacob Skaria	1	171
What is wrong with this nested function? by A little stuck I have entered the following nested function, but it says the formula contains an error. =IF(SUM(E55:E67)=3, "Red"), (SUM(D55:D67)=2, "Amber"),...	July 15th, 2009 08:38 AM by Lars-Åke Aspelin[_2_]	3	183
Comment in formula by Andrea When I have a formula like =VLOOKUP(E906,'COST SHEET'!A:Q,17,FALSE)I906W906 I would like to be able to put a comment like "Q17 equals sector 3 and...	July 15th, 2009 05:59 AM by Andrea	4	171
All functions that use commas aren't working! by brandon_05mn Please help, this is my problem. Some formulas don't work when I type them in. For example, when I type this formula, it will say there is an error....	July 15th, 2009 05:59 AM by Kassie	1	95
Conditional Formating by Kanmi Hello, I apply conditional formating by using formular to a cell and i want to apply it to all the cell without re-typing the same formular in conditional...	July 15th, 2009 04:33 AM by FloMM2	1	98
Running two formulas as one by Steved Hello from Steved This will save an extra lookup column G:G "converts Col C:C 0830 to 8:30:00 a.m." {=INDEX('Duties Mon-Fri...	July 15th, 2009 03:39 AM by Steved	0	147
AVERAGE by Keith - NRCS[_2_] I'm looking to create a formula that will do the following: I have a column that I would like to get the average of but my problem is that there are some...	July 15th, 2009 03:25 AM by Teethless mama	3	101
Oracle import by Steved Hello from Steved If I have a 4 Digit the below "Formula" works as it should. Excel shows "141" as 141 in Formula Bar but the Oracle Import shows it as 0141...	July 15th, 2009 03:00 AM by Steved	3	163
Copy Paste in Excel 2007 by NoviceAccessUser-Melanie[_2_] Up until today I was able to copy and paste a range of data from one worksheet to another worksheet in a different file. Now whenever I try to highlight a...	July 15th, 2009 02:12 AM by Liliana[_3_]	3	101
Rounding Negative Numbers to Zero by Robbie I've been searching around and can't seem to figure out how to write a formula that will round a negative number to 0 correctly. I used the (MAX(0,A1) and...	July 15th, 2009 02:05 AM by Ron Rosenfeld	4	124
Complex formula assistance please. by Colin Hayes HI In my helper column in K2 , I'm trying to construct a formula which combines and satisfies these arguments: If D2 is larger than 25 and J2 equals 1 or 11...	July 15th, 2009 01:59 AM by Colin Hayes	4	123
Formula result and displayed result are different by spindoctor When I open the Function Arguments window using the function button on the formula bar, it says that the formula result is $1,000.00. On the sheet, $0.00 is...	July 15th, 2009 12:53 AM by Shane Devenshire[_3_]	4	103
How can I use circular references that are allowed in Lotus 123? by DAVIDDON I try to write a formula that has a variable value in column F which is compared to column H. Column H should always contain highest value of the two...	July 14th, 2009 09:14 PM by Luke M	1	106
Template or Excel ? by drctest Hi All, I need to create three copies of a receipt, and obviously would like to enter the data only once and have the other two receipts print automatically...	July 14th, 2009 09:11 PM by Luke M	1	79
Searching for text by EBnLP01 a1=BR549 a2="" (empty space) a3="" (empty space) a4=BR549 what i'm looking for, is a formula that will search these cells for a TEXT value and then display...	July 14th, 2009 08:32 PM by EBnLP01	2	92
Lookup Across Multiple Columns - Return Category names by slf I'm trying to figure out a formula for this scenerio: col a col b col c col d col e col f col g name ...	July 14th, 2009 08:29 PM by Herbert Seidenberg	2	158
Adding Days and Hours by Basenji In an Excel 2003 spreadsheet, column D has the start date and time; D4= 4/1/09 0:01 (24 hour time). Column E has the discontinued date and time; E4= 4/7/09...	July 14th, 2009 08:20 PM by Basenji	8	115
change date from 20-Mar-1920 to 20/03/1920 format by Confused How do I change the date if it is written in general format as 20-Mar-1920 to the date format dd//mm/yyyy 20/03/1920	July 14th, 2009 07:36 PM by Confused	5	107

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed