Worksheet Functions - Page 1509

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
DIAS.LAB function poblem by Gerardo Hi there, I have to calculate the days between two date. But between monday to saturday. The DIAS.LAB function calculate the total days between monday...	October 31st, 2005 06:22 PM by Ron Rosenfeld	1	116
repited numbers in columns by gerardo carranza how can i find a repited numbres between 2 columns	December 11th, 2007 04:51 AM by Mike Rogers[_2_]	1	63
Excel formula reference question by Gerben Dirksen Hi, I'm sure this has been asked somewhere but I couldn't find it on google. How do I make a large set of formulae that looks like this: Cell B1: =A5 Cell...	January 17th, 2008 04:38 PM by Pete_UK	4	155
Advanced sorting by Gerben Dirksen Hi, I'm sure someone has asked this before, but I can't find it. I'm looking for a function that sorts a set of data that contains references. Example, I have...	July 26th, 2008 07:16 PM by Ragdyer	4	65
Sorting / Numbering problem by Gerben Dirksen I have an Excel worksheet that lists the chapter of a document, i.e. the first column looks like this: 1 1.1 1.1.1 1.1.2 1.1.3 etc.	October 16th, 2007 01:25 PM by Pete_UK	2	53
Rolling over a Remainder by gerberdude Hello all, I am not sure which function to use to complete this worksheet. Basically, it needs to do the following: For example, cell A1 has the following...	January 26th, 2006 08:40 PM by gerberdude	2	65
Formula by Gerd I have column A with Prices; column B contains formula - Price x 0.05; column C contains formula - sum of Col A and Col B. When I drag these formulas down the...	February 25th, 2006 04:18 AM by dmexcel	3	85
Need help with formula by Gerd Hi. I would like help with the following problem. A1 contains the total job costs and is constantly being updated. At the end of the first invoice period...	August 2nd, 2008 07:06 PM by Gerd	2	167
Vlookup help with multiple results by Gerd I have a range of cells which has a master list of my inventory. Headers are Category, Vendor, Item, Price. This list is in Sheet 1. I have 12 different...	October 28th, 2008 07:06 PM by Gerd	2	48
setting fixed decimals in only one column of worksheet by gered i want to set 1-2 column's in worksheet to fixed decimals. The only way i have found is tools-options-edit and set decimal. this changes all future data...	March 20th, 2007 07:32 PM by Gord Dibben	2	55
Banding with Conditional Formatting with Multiple Conditions by Geremia Doan I can set up banding using Conditional Formatting fust fine. The problem I am having is that there are other conditions I need to have happen at the same...	February 2nd, 2005 03:14 PM by JulieD	7	460
character lookup in excel by gerg How can I determine the position of a certain character within a string in a cell in ms Excel ?	January 14th, 2009 09:16 PM by David Biddulph	2	60
Finding NEXT to last, non zero numeric value in a row by gergster trying to find a way to automatically return (via formula, not macro- I don't know squat about macros), automatically return the NEXT TO LAST, non zero,...	April 16th, 2010 01:58 PM by Steve Dunn	3	159
Conditional formatting of duplicates in a range by gerhard I went already through a lot of the threats in this discussion group but could not find an answer to my problem. I use Excel2007. Within a range of 4 columns...	April 16th, 2008 05:55 PM by gerhard	2	93
STPCScut STPCScopy macro missing?? by Gerhard Silbermann All Experts, since some days all my Excel worksheets show the same failu if I go to CUT or COPY I get the error STPCScut or STPCScopy macro missing. I...	August 29th, 2005 07:34 PM by Dave Peterson	3	106
Excel should have 300 columns, for use aluminium smelter industry by GerharddeBeer There are countless Aluminium smelters accross the world and most of these have 288 cells per potline, it would be excelent to be able to fit all of the...	July 20th, 2006 12:44 PM by Toppers	1	48
Excel row height v. printed page by Geri Rigger I have to use Excel to manage project updates with lots of text. Each row is set to the maximum 409 height, even though you can fit more test in there, it...	November 6th, 2009 05:29 AM by CellShocked	4	105
if 3 cells have data then add certain value to another cell by Gerigto I would like to make cell D1 be blacked out if cells A1, B1 and C1 have a Y in them. How do I accomplish this? Some people may enter data into D1 first and...	March 28th, 2007 02:51 AM by Max	2	67
multiply multiple cells by a specific value by german calvo i have office 2003. im trying to multiple a range of cells by a specific number dont know how to do it. im hoping anyone can help resolve this. i want all the...	August 3rd, 2004 03:43 PM by JE McGimpsey	3	586
Why isn't Excel dragging the right value? by germanyjessica Frank - Even our IT tech couldn't help me with this problem. Thanks so much! If anyone is still out there - can you tell me why it changed and how never,...	October 20th, 2006 08:41 PM by Sandy Mann	1	65

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