Worksheet Functions - Page 151

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
formula to delete duplicate part numbers by Louis i have a column with over 2000 part numbers. I need a formula to delete the rows that have duplicate part numbers, for example: A B 1589 10.50 1596 ...	December 24th, 2003 05:44 PM by Louis	3	453
Sumif question by Travis I have a user that is having a problem with a workbook. It has 5 sheets with a pretty significant amount of data in them and the speed sucks, it is terribly...	December 24th, 2003 08:35 PM by Jim	2	243
How to produce a consolidated list based on selection criteria? by CRS I could use some help on this one ... In column A I have a long list of alphanumeric entries (they happen to be record titles), and in column B I have a...	December 24th, 2003 09:15 PM by CRS	3	451
If a cell is not null, insert a formula into another cell by Michelle Hillard Hi guys I need to put a formula into a cell E2 =DATEDIF(B2,C2,"d") but only activate this formula if B2 is not null. If B2 is null, then E2 is null.	December 24th, 2003 10:53 PM by Dave Peterson	3	201
Cubic Root by Jean I don't know how to do it!!!! Also any other Root but, Square... RUSH..... Thanks	December 24th, 2003 10:54 PM by Scott	3	103
Placing a formula into a cell through VBA code by Michelle Hillard Hi guys, I have one worksheet with 5 columns Starting at rowA2, if cell A2 has text/a value, I would like the cell E2 to auto enter =DATEDIF(B2,C2,"d). If A2...	December 24th, 2003 11:41 PM by Max	1	415
countif by not so bright joe i have a column with 1200 values, some of them repeat. i want to count the number of different(unique) values. what is the command to count values within a...	December 25th, 2003 09:16 AM by Harlan Grove	3	146
Time Function? by DaveSlinger Does Excel have a way to keep time? If I enter a start time in a cell, can it tell me by conditional formatting, when 11 hours are up? Is there an add-in...	December 25th, 2003 05:30 PM by Jim	1	125
date conversion by web_time Is there an easy way to build a two-column table with gregorian dates in one column and Hebrew dates in the other? And then for each year, have it... ( 1 2)	December 25th, 2003 06:51 PM by Ron Rosenfeld	10	1,315
trace precendants vs undo feature by NancyF Has anyone experienced losing the "undo" feature immediately after using "trace precendants" in their worksheets? This problem is repeatable using the...	December 26th, 2003 01:18 PM by Dana DeLouis	5	445
How to lock one cell in formula? by There are two types of cell references -- relative and absolute. When a relative cell address in a formula is copied, the actual address is modified to...	December 26th, 2003 01:22 PM by orlando	2	545
Calculated Items in Pivot Tables by Chris I am using a calculated item in a pivot table. I have a field, Acct Type, which contains Rev & Exp as field items. I created a calculated item to subtract Exp...	December 26th, 2003 01:31 PM by Debra Dalgleish	1	199
auto format 5 worksheets out of 6 when opening excel spreadsheet. by mike to all: I'm trying to auto format 5 worksheets that are in my workbook, but don't want the sixth worksheet formated. So, I want worksheet1 to remain static...	December 26th, 2003 08:37 PM by J.E. McGimpsey	1	652
COUNTIF? by Chuck Davis Using Excel 2003 on Window XP Pro. I have a workbood containg two sheets of data and one that will be a summary page. The worksheet that contains the data...	December 26th, 2003 11:25 PM by Max	8	207
comparing data and return more than result by victorwill ..I need help really bad. I made a default column with a list of names(say A1:A10, these are names) and i use a macro to import a text file with 3 columns...	December 27th, 2003 12:12 AM by victorwill	1	312
comparing data and return only data that exsist in the 2 columns by victorwill 1. I need help really bad. I made a default column with a list of names(say A1:A10, these are names) and i use a macro to import a text file with 3 columns...	December 27th, 2003 12:13 AM by victorwill	2	852
Laurent Longre's MOREFUNC.XLL add-in by Lara Is there any reason for me to think that this add-in could possibly cause a computer to crash? I had one crash shortly after I installed the add-in (when...	December 27th, 2003 01:21 AM by Lara	2	845
#NAME? by Harlan Grove "Comcast News Reader" wrote... The function below returns the #NAME? error, and I'm not sure why. Any help on this will be...	December 27th, 2003 04:14 AM by Comcast News Reader	2	102
excel by [email protected] Why is it that i cannot open an excel file in my windows xp. ex. my co. sends me a spreadsheet in my windows xp. I cannot open it. it is directing me to...	December 27th, 2003 05:15 AM by Gord Dibben	6	149
calculating a mean using sumproduct by Harlan Grove "skweetis" wrote... .... What I have so far is: =(SUMPRODUCT(('Dec Resi'!$A$2:$A$2000=BI7)*('Dec...	December 27th, 2003 05:38 AM by Harlan Grove	7	138

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