Worksheet Functions - Page 1152

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
Minutes/seconds not right ( 24 ??? %$@#$%$) by Steve Column A is total time in seconds Column B is A/60 - for minutes Column C is B/60 - for minutes/seconds ?? In Column D, I'm running the total with these...	July 11th, 2008 06:41 PM by Pete_UK	4	57
Push updates from one workbook to others? by ChrisP I have a master workbook and 5 different workbooks that have links to the master workbook. I have to password protect my master workbook as it has salaries...	July 11th, 2008 05:25 PM by Pete_UK	1	77
IF and dates by PAL I have a multi row, multi column spreadsheet. Column E has a blank or a date in each row. I am trying to write a formula that says IF there is a date AND...	July 11th, 2008 05:19 PM by PCLIVE	7	76
IF function question by hispeaches I have 2 functions on my spreadsheet as follows: In a column I have...	July 11th, 2008 05:11 PM by Pete_UK	1	78
Validation in Field Lists by TXDalessandros I have a spreadsheet that I need to click choice either yes or no in column E to populate based upon the field they choose in Column H (example...	July 11th, 2008 04:37 PM by John C[_2_]	1	81
Copy worksheet with named ranges to new workbook and keep names by Sandy Hello - I have a worksheet in one work book with a large number of named ranges. I want to use these named ranges in another workbook. How do I copy a...	July 11th, 2008 04:37 PM by Sandy	0	79
Refer to a sheet using a cell value by bony_tony Hi, on "Sheet1" in cell A1 I have the string "Tony". I also have a sheet named "Tony" I want to display the value of cell A1 in the sheet "Tony"...	July 11th, 2008 04:27 PM by bony_tony	2	109
????????????????????? by Eamon	July 11th, 2008 04:04 PM by bony_tony	1	61
how do I convert English (Canadian) dates to English (US) dates by dinertx downloaded from network report Canadian dates dd/mm/yyyy format and need to convert to US dates mm/dd/yy....	July 11th, 2008 03:59 PM by Mike H	1	76
Look Up two cells by Kim I have the following table I want to set up in Excel. My question is if a user keys a Spec and a Spec Gravity number, how do I get Excel to look up the...	July 11th, 2008 03:52 PM by John C[_2_]	2	75
TESTING by Eamon	July 11th, 2008 03:41 PM by Eamon	0	62
Vlookup in data validation??? by ChrisP I have 2 workbooks, Masterlist and Report. The Masterlist has all the employees names and what type of expense they work on (COGS or SGA). The Report has a...	July 11th, 2008 03:36 PM by John C[_2_]	1	64
spreadsheet to keep track of phone numbers by Eamon I am setting up a spreadsheet to keep track of phone numbers. The workbook has worksheets named "A", "B", "C", "D" etc! The first worksheet is named...	July 11th, 2008 03:24 PM by John C[_2_]	1	71
Finding Links by revdec I need to update a workbook that has about 40 worksheets each containing 170 rows. The changes will increase the number of rows per sheet and the additional...	July 11th, 2008 03:17 PM by revdec	0	58
Quday-Conditional Formatting by Udayan I have a column containing dates (A1:A100) in date format. Colour of all the cells in that column (A1:A100) is yellow. Highilighted the required cells...	July 11th, 2008 03:04 PM by Udayan	5	51
Spreadsheet to keep track of phone numbers by Eamon I am setting up a spreadsheet to keep track of phone numbers. The workbook has worksheets named "A", "B", "C", "D" etc! The first worksheet is named...	July 11th, 2008 02:46 PM by Eamon	0	74
"in" function??? by ChrisP I have a cell that could be one of 2 values, if it's one value I want to do a vlookup and get the associated info from another tab (this I can do). My...	July 11th, 2008 02:33 PM by PCLIVE	2	72
HOW CAN I FLAG A CELL IN EXCEL WHEN IT HITS A REORDER LEVEL? by PENNY I WANT TO ENTER A FORMULA WHERE IT WILL FLAG/HIGHLIGHT OR SIMILAR WHEN A LEVEL REACHES A REORDER POINT - HOW CAN I DO THIS. I.E. WHEN THE GAS OIL TANK...	July 11th, 2008 01:56 PM by Meebers	2	96
Hide tab sheet in webpage (Excel) by Tat Fatt Hi, I've hidden my sheet tabs via the tools - options - view, but when published in web view or saved as web page they appear, how can I hide? Thank you.	July 11th, 2008 01:55 PM by Hansn	7	138
=SLOPE(OFFSET(INDEX .... Help please by Mark K[_3_] I think I'm on the right track, but I can't quite figure out how to get this to work. I have 3000 rows and 800 columns of data. Working with slope...	July 11th, 2008 01:49 PM by Bernd P	9	94

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