Worksheet Functions - Page 559

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
unwanted number to date conversion while pasting data from web by Jacek I am trying to get correct date from information copied from html file from WEB excel spreadsheet. The text is: MANDURAH (CD) Race 1, NEW YEAR SALE (GRADE P5)...	February 24th, 2005 02:59 PM by Peo Sjoblom	1	166
how do i set up a formulas with an if date? by Thunley I need help. I am trying to set up several worksheets in excel to draw information from my main worksheet. I need to set up an IF formula if the date is...	February 24th, 2005 03:36 PM by Peo Sjoblom	3	84
What does a "plus" cursor mean (in lieu of the pointer?)? thanks by S. Hegge What does a "plus" cursor mean (in lieu of the pointer?)? thanks	February 24th, 2005 03:38 PM by Peo Sjoblom	4	195
Can I put Pop up menus on Excel by Ricardo Munoz I want to make an information system on an inventory. Is there any way to put a pop up menu like the ones found on internet to do this?	February 24th, 2005 03:47 PM by Bob Phillips	2	117
How can I write a formula or an argument to highlight a date when. by saffield it is past the current date	February 24th, 2005 04:01 PM by Jason Morin	1	101
Formula presumes cells have data by Pat The following formula presumes there is data in N75 and J75 =IF(ISNUMBER($R75)*($R750),"",IF(AND($N75-$J750,$Q75=1),0,$N75-$J75)) When no data can be...	February 24th, 2005 04:13 PM by Peo Sjoblom	1	195
Worksheet Function - Find? by DAA Hi, Please help me figure this out. On worksheet 1, I would like to use a formula on Column C that if on worksheet 1 column B = Yes, it would copy the value...	February 24th, 2005 04:15 PM by DAA	2	289
Excel should support DAYOFYEAR(year,month,day) returns julian dat. by Neil And the reverse function JULDATE. This is easier than writing the equation: =DATE(2005,4,15)-DATE(2005,1,1)+1	February 24th, 2005 04:29 PM by Jason Morin	1	82
Check for errors by Pat The following formula presumes there is data in N75 and J75 =IF(ISNUMBER($R75)*($R750),"",IF(AND($N75-$J750,$Q75=1),0,$N75-$J75)) When no data can be...	February 24th, 2005 06:08 PM by Peo Sjoblom	3	76
I entered 11/22/2004 in excel workbook and it keeps changing to ## by Firefly I was working on my mileage work sheet in excel for some reason when I entered 11/22/04 it keeps changing to #######. What's this. If I click on it the...	February 24th, 2005 06:11 PM by Peo Sjoblom	1	65
why do my spreadsheet gridlines only prints half way on the page?. by gardnere I am trying to print out a report in excel on legal paper. The spreadsheet gridlines will only print half way the page, but the text prints across the whole...	February 24th, 2005 06:24 PM by BobT	2	288
"count if" function based on value of another cell by Anauna Hello, (Excel 2003) Column A contains list of buildings (25+ building names, 1000+ rows) Column D contains a letter indicating if work done ("c") Column E...	February 24th, 2005 06:33 PM by Bernie Deitrick	3	184
How I show, automatically, the tab name on a cell, in Excel? by CPortilloTroconis I need to have a column of cells showing the tab name of the sheet where they are; now the question is, is there any way to do it rather than copy &...	February 24th, 2005 06:36 PM by Sarah	4	214
is there a more efficient formula than... by Wazooli If I have the following data: 0.630301621 0.735538614 1.112178958 1.075829421 1.794418509 1.661534827 0.723790191 0.736495518 0.808701582	February 24th, 2005 06:39 PM by Ken Wright	6	118
opening worksheet is "packing list" by usrofc Hello: in excel 2000 (wXP) the template "packing list" opens whenever I open Excel. I also get window messages that excel "cannot access read-only document...	February 24th, 2005 07:19 PM by Gord Dibben	1	323
Concatenating Dates by jadams-bellevue How do I concatendate dates from several cells into one cell, while maintaining the date format? When I have tried, it converts the dates to serial numbers...	February 24th, 2005 07:27 PM by jadams-bellevue	2	79
Excel should allow a number formats of HEX, OCT and BIN. by Neil Many users are programmers or other IT professionals.	February 24th, 2005 07:33 PM by Harlan Grove	3	147
SUM a column with errors by Joe Gieder I need to sum several columns that due to formulas within the cells have a result of #N/A. Is there a way to sum this column? example...	February 24th, 2005 07:57 PM by Joe Gieder	3	72
how do i open a 2003 file into an xp spreadsheet by windylyndy My works computer uses excel spreadsheets - my home one is in microsoft xp spreadsheet format. I tried to email a document from work to home using...	February 24th, 2005 08:01 PM by Ken Wright	2	212
Excel shifts to wrong worksheet automatically by Tom77 I am copying data from one excel file to another. When I attempt to paste the data to worksheet 3 of the 2nd file, the 2nd file automatically shifts...	February 24th, 2005 08:10 PM by dave	1	219

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