Worksheet Functions - Page 1143

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
How do I create macro to add 8 rows at a time? by GM I have a worksheet with data that I need to insert 8 rows inbetween the other rows in a spreadsheet. I tried creating a Macro but it records the cell...	July 16th, 2008 05:57 PM by Gary Brown[_4_]	4	61
Paste Special by MichaelRobert I want to make sure that users cannot change the formatting of a cell if they accidentally do a 'Paste SpecialValues' on the original cell. Is there a way...	July 16th, 2008 05:54 PM by MichaelRobert	3	44
Spreadsheet by Kimmy I have a spread sheet that is only 3 columns wide, but very small columns, but I have lots of rows that make my spreadsheet consume over 7-8 pages. So, when...	July 16th, 2008 05:26 PM by Niek Otten	1	55
CHANGE THE HEADER NAME by Lady at the lake How do I change the header name on excel spreadsheets and the footer dates.	July 16th, 2008 05:11 PM by Gary Brown[_4_]	1	77
Chronological Numbering by Chronological Numbering[_2_] I have 30 spreadsheets in one file, and would like to chronologicaly number them (have a certain cell display the number of that spreadsheet). I don't want...	July 16th, 2008 04:58 PM by Bernie Deitrick	4	65
Inserting Function blanks adjoioning cell by Dave Occasionally, when I want to insert a cell address for a cell that is immediately to the left of the one I am trying to put a formula in, inserting the '='...	July 16th, 2008 04:28 PM by Spiky	4	80
Sum the amount of times a number appears in a column in Excel? by SEMonroe I am using Excel 2003. I have a spreadsheet of Soccer orders. One column has player numbers entered. I would like to sum the number of times each number...	July 16th, 2008 04:17 PM by Glenn[_6_]	2	76
multi-if then formula i think by Ann i have 3 columns of data. basically i want to query column A and B, for a particular range, and if it meets that range/criteria, sum the totals in column...	July 16th, 2008 04:05 PM by Ann	4	48
text in mm:ss to time by P Boric _I have times in text format as mm:ss (eg. 03:45) and want to convert them to time numbers in the same format.	July 16th, 2008 03:57 PM by David Biddulph	5	79
Non-table look ups by Rich Mogy I have the following data in cells a1 to k10 Currency Code1 Amount1 Code2 Amount2 Code3 Amount3 Code4 Amount4 Code5 Amount5 CNY COST 17.37 DIREXP 192.17...	July 16th, 2008 03:16 PM by Rich Mogy	0	49
keep track of phone numbers by Eamon First off I posted this question yesterday, but for some reason with my internet server provider I was unable to see my post or any replies if there were any,...	July 16th, 2008 02:51 PM by Eamon	4	84
Macro To Make Workbook Demonstrate Itself by robzrob I want to set up a macro which will perform various actions - mostly simple, like typing this, that or the other into cells, deleting cell entries, etc. I'm a...	July 16th, 2008 01:13 PM by robzrob	2	78
How to set the enter key to move every 2 rows instead of one row by PhyllisTheCat Would appreciate if someone can help. I want to have the cursor skip one row after hitting the enter key. Thanks.	July 16th, 2008 01:06 PM by Bernie Deitrick	1	65
Count Function by Astro I would like to use excel to count the number of cells containing year 2008. 23-Apr-07 15-May-08 21-Jan-08 05-Feb-07 Please advice on the function to do...	July 16th, 2008 11:09 AM by Gary''s Student	2	59
Excel still not recognising equal values by pecan I have a list of users with unique ID numbers, and I've used vlookup to get some more information about them on to one worksheet (sheet 1). I now want to...	July 16th, 2008 10:40 AM by Niek Otten	1	95
How can I recover the previous data after save change by due how can i recover the previous data after save change.	July 16th, 2008 09:11 AM by [email protected]	3	69
I have a text cell and I want to inport a value into the cell by gtf1949 I have a cell with text and want to import a value from elsewhere in the spreadsheet to make it part of the cell. --	July 16th, 2008 08:47 AM by David Biddulph	1	79
Multiple Criteria Lookup Results by Forgone I have used the three tier lookup formula done by using the "Bob Ulmas" technique that I found on the http://www.mvps.org/dmcritchie/excel/vlookup.htm website...	July 16th, 2008 08:26 AM by Bob Phillips	3	84
Combination...SumProduct, Index, Match? by Monte Hello! Life was simple, then we offered multiple rates for the same paper. Your assistance with the following scenario is greatly appreciated. -Monte Rate...	July 16th, 2008 08:07 AM by John C[_2_]	4	45
Sum up all up changes and down changes by Tetsuya Oguma Hi all, Suppose I have a data series like below A B Data Chg 46.1250 47.1250 1.0000 46.4375 -0.6875 46.9375 0.5000 44.9375 ...	July 16th, 2008 06:48 AM by Max	3	131

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