Excel Worksheet Functions - Page 242

Thread / Thread Starter	Last Post	Replies	Views
How to write a function for column A = product of two columns, B a wlfoote	by T. Valko	5	1,530
IF, but Not to Exceed dnamertz	by Shane Devenshire[_2_]	4	1,504
count entries that equal one criteria if another column meets anot ccKennedy	by Shane Devenshire[_2_]	9	1,443
Function to Change Font Jay	by Shane Devenshire[_2_]	1	463
IRR gotahavit	by Ron Rosenfeld	20	1,899
Find In Set Rod	by Teethless mama	4	338
Zero-Length string vs Zero (also a valid value) [email protected]	by [email protected]	2	664
UniquifyForUser error for Essbase AddIN John	by Charles Williams	1	2,163
Help Payroll calculation problem Tia[_3_]	by David Biddulph[_2_]	1	770
Subtracting partial hours Melissa F	by T. Valko	1	513
Use of the COUNTIF function JCameron	by Philip Mark Hunt	11	1,951
Some kind of Array-Sumproduct Function ryguy7272	by Max	18	1,016
Extract multiple results based on multiple criteria tara657	by Herbert Seidenberg	4	1,178
Age based on birthdate Squid	by Fred Smith[_4_]	2	771
got a tough on and I am confused were to start [email protected]	by smartin	4	387
function range robert	by Joel	1	343
data validation list form sheet [email protected]	by Debra Dalgleish	1	523
drop down function [email protected]	by [email protected]	2	315
Creating drop downs for part number configuration Peter	by Peter	2	3,128
Formulas change when macro adds new column Sandra	by Ken Johnson	3	498
Function Range Lookup AGAIN! robert	by Niek Otten	3	507
Change color of text if date is overdue Lynora	by Lynora	2	2,910
Count if BC	by BC	3	333
Function Range Lookup robert	by T. Valko	2	455
How do I create a FTP hyperlink in Excel Qman	by Gary''s Student	1	1,562
nested if statements using "AND" as well as "OR" ibbm	by David Biddulph[_2_]	3	461
If a cell is checked take words from a pivot table and place in a Brian	by Brian	4	509
How to change =SUM(R[-56]C:r[-1]c) to =SUM(D1:D2) ItsVegas_Baby	by Rick Rothstein	3	1,385
How can I search for a string of numeric digits within a text stri Eric_NY	by Rick Rothstein	9	516
Reference cells in seperate worksheet HR Gal	by Bernard Liengme	3	463
function range robert	by Rick Rothstein	2	343
MULTIPLE CONDITIONAL FORMATS Pattee	by Ron@Buy	5	398
sumif Neil	by Neil	2	371
Searching for strings in a column [email protected]	by Teethless mama	6	616
Maximum Characters in a cell Brosenberg7	by Dave Peterson	1	432
Present value of an annuity sleeplessinnewjersey	by sleeplessinnewjersey	4	1,247
Find Capital Letter Boogie	by Glenn	12	4,137
Date Format Problem Maperalia	by T. Valko	3	493
text match formula not working Belinda7237	by Belinda7237	2	1,806
Count function John Peterson[_2_]	by Steve	2	343
Insert rows but keep references in Excel RichterCa	by RichterCa	2	432
Function containing $ Dave	by Mike H	2	374
combining formulas benny29	by benny29	0	524
Cell Formatting Clare	by Gary''s Student	3	414
Multiple caculations using individual data jschlarb	by Pete_UK	1	377
Custom / Specilized Forms to enter data in Excel Gaylen	by Gaylen	2	460
SUMPRODUCT query Terry Bennett	by Terry Bennett	3	369
Highlighting Rows with VB. Xman	by Xman	12	857
Multiple entries last date Simo	by Mike H	1	512
compute date and time difference Neri	by Neri	5	1,948
return a text that is before "/" Piotr (Peter)[_2_]	by Max	3	540
Conditional format based on a different column ArcticWolf	by David Biddulph[_2_]	2	516
2009 Template for Attendance: How do I add multiple tabs of employ Ashleysquared	by Ron@Buy	1	705
countif with auto filter jwells2001	by T. Valko	1	558
Function for an array KatiJ	by T. Valko	3	458
range label works in VLOOKUP except if refenced in another cell brewmaker	by T. Valko	3	776
Moving average billregal	by smartin	1	626
I get the wrong answer when subtracting currency. Midwest	by Ron Rosenfeld	3	644
vlookup addition nt	by Pete_UK	6	441
SUMPRODUCT with multiple criteria [email protected]	by Pete_UK	11	1,076
Net should be zero but it is not; decimal values aroung the 12 dec frecar	by joeu2004	11	1,522
Next lower cell with number... Brad	by ryguy7272	2	522
Adding like cells from different workbooks Mr B[_2_]	by ryguy7272	1	459
Formula to add based on information from 2 different cells RennStempie2	by T. Valko	2	611
Hexadecimal to Decimal (and vice versa) Toria	by Toria	5	841
sorting multiple heather	by Joel	1	332
Sorting heather	by David Biddulph[_2_]	5	445
Sum a column correctly after more info is added by sorting Soulscream	by Pete_UK	9	522
A1=50, C1=50, E1=100(total of A1+C1) what % o f E1 is A1? DSSSS	by Gord Dibben	4	466
Excel 2003: Count how many times a date occurs lilhoot	by T. Valko	4	6,711
How do I create a multiselect drop down list Yve	by Gord Dibben	2	1,358
Lookup a reference, go to another worksheet, retrieve a block of d kiwi1962	by kiwi1962	2	463
How do I clear 'form' content from an unprotected cell without mac Casey M	by Gord Dibben	4	785
How to return a blank formula cell if the reference is blank? waybomb	by Bernard Liengme	2	1,942
Count function John Peterson	by JE McGimpsey	2	343