Worksheet Functions - Page 1021

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
using if statement to subtract 24 hours from time still shows as a negative time from both responses under 24 hours by richard.littlewing	September 15th, 2008 08:05 AM by Roger Govier[_3_]	2	95
calculate cells over multiple worksheets by mrsjoan I have 4 worksheets in one book. Worksheet names are July, August, September, Total. In cell F9 of each worksheet I have a dollar value I would like to add...	September 15th, 2008 08:01 AM by Roger Govier[_3_]	4	165
How I find specific character?? by TotallyConfused How do I write a formula to find "," (comma). I want to say If there is a "," in B7 than B7. Thank you for any help you can provide.	September 15th, 2008 07:56 AM by Roger Govier[_3_]	2	80
Need help with function please by TotallyConfused How can I revise this formula to flag colum A with the following: If B3 is nontext (date) or "Blank" than "Blank" leave "blank" if not blank than enter a...	September 15th, 2008 07:55 AM by Roger Govier[_3_]	1	63
HEADER & FOOTER by James8309 Hi everyone! I have a header and footer for this excel document. Is it possible for me to insert horizontal line just under the header and just above...	September 15th, 2008 07:51 AM by Ashish Mathur[_2_]	1	98
Creating DDE link to DDE server in Excel 2007 by Gum[_2_] I would like to do the above mentioned action. I have loaded an excel file containing a DDE link into Excel 2007 and the links do work. When I type in a...	September 15th, 2008 06:35 AM by Gum[_2_]	0	99
Rank then sort then pastelink by SueQueen I have 9 topics (ColumnA) with a tallied numerical answer(ColumnB) in Excel. I have used the RANK function in Excel to Rank numerical responses from 1 to 9...	September 15th, 2008 05:26 AM by SueQueen	4	75
checkbox to work when emailed by Steved Hello from Steved Please when I send a spreasheet with a checkbox how can I get it to work on the other computer ( when emailed ) The objective off the...	September 15th, 2008 02:25 AM by Steved	0	56
Display File Name in Cell by Corey Is there a formula to display the File Name in a cell (Say O49) ? -- Corey .... The Silliest Question is generally the one i forgot to ask.	September 15th, 2008 01:16 AM by Dave Peterson	3	137
using if statement to subtract 24 hours from time by richard.littlewing Hi all I am trying to subtract 24 hours from a time if it is actually over 24 hours, if not then show 0 my formula works for everthing over 24 hours but...	September 15th, 2008 12:15 AM by Sheeloo	2	70
How do I get a "link-to" cell to appear in upper left (Excel) by Dadders In Excel, I would like to ensure that, if a link points to a cell in the middile of the target page, then that named cell should appear at the upper left...	September 14th, 2008 11:55 PM by Dadders	2	107
Milenko Kindl pulls out by [email protected] Milenko Kindl NEW YORK - The outlook for Lehman Brothers' future seemed dim Sunday after Barclays PLC withdrew its bid to buy the beleaguered investment bank...	September 14th, 2008 10:41 PM by [email protected]	0	95
Cells w/ user defined function do not auto update by John I have an excel 2007 file with worksheets for each month. The Feb-Dec sheets each have cells that contain the formula "=B25+PrevSheet(F25)" to accumulate...	September 14th, 2008 07:06 PM by John	2	76
Î¹Î·Æ’ÏƒÑÐ¼Î±Ñ‚Î¹Î½Ñ” Î±Î·âˆ‚ Î¹Î·Ñ‚Ñ”ÑÑ”Ñ•Ñ‚Î¹Î·g !!! by MaNi http://infopike.wordpress.com in that blog u will find * windows tricks * shortcut keys for internet explorer and windows * all run commands and dos...	September 14th, 2008 05:53 PM by MaNi	0	50
Please help with Column to row formatting by TotallyConfused I have columns instead of rows with data. Transpose does not work with this. Ad DT Dis DT Ap Dt 01/01/08 02/01/08 03/01/08	September 14th, 2008 04:32 PM by Roger Govier[_3_]	7	80
Top 10 Things To Look For In A Web Host by best_hosting Top 10 Things To Look For In A Web Host http://hosting-top10.blogspot.com/2008/07/top-10-things-to-look-for-in-web-host.html 5 Tips To Choose A Domain Name For...	September 14th, 2008 03:01 PM by best_hosting	0	105
Help need formula for working out date overlaps by liztownsend Hope someone can help, I'm looking for a formula to work out date overlaps. e.g. If my key dates are 1/11/08 to 30/11/08 I want to auto calculate how many... ( 1 2)	September 14th, 2008 01:07 PM by Bob Phillips[_2_]	15	120
Hard coded formula fix, VBA for column ordering by undrline via OfficeKB.com I set up Excel "templates" for some pretty standard database extracts. It has a summary sheet, and a data sheet. I paste new data in the data sheet, and voila,...	September 14th, 2008 08:53 AM by ShaneDevenshire	2	157
VBA Password by Tia[_3_] Hello I have an excel sheet protected with a password and a VBA code when i open the sheet i can only see it in print preview i dont have the password is there...	September 14th, 2008 08:46 AM by muddan madhu	1	62
Excel Formula Needed by Barb Manjarres I would like to know how to make excel check an entire column line by line for a particular name and if the name exists I want it to go to another row and...	September 14th, 2008 08:31 AM by MartinW[_2_]	2	70

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