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,541
IF, but Not to Exceed dnamertz	by Shane Devenshire[_2_]	4	1,519
count entries that equal one criteria if another column meets anot ccKennedy	by Shane Devenshire[_2_]	9	1,447
Function to Change Font Jay	by Shane Devenshire[_2_]	1	474
IRR gotahavit	by Ron Rosenfeld	20	1,904
Find In Set Rod	by Teethless mama	4	351
Zero-Length string vs Zero (also a valid value) [email protected]	by [email protected]	2	673
UniquifyForUser error for Essbase AddIN John	by Charles Williams	1	2,173
Help Payroll calculation problem Tia[_3_]	by David Biddulph[_2_]	1	780
Subtracting partial hours Melissa F	by T. Valko	1	526
Use of the COUNTIF function JCameron	by Philip Mark Hunt	11	1,960
Some kind of Array-Sumproduct Function ryguy7272	by Max	18	1,028
Extract multiple results based on multiple criteria tara657	by Herbert Seidenberg	4	1,186
Age based on birthdate Squid	by Fred Smith[_4_]	2	774
got a tough on and I am confused were to start [email protected]	by smartin	4	389
function range robert	by Joel	1	355
data validation list form sheet [email protected]	by Debra Dalgleish	1	527
drop down function [email protected]	by [email protected]	2	321
Creating drop downs for part number configuration Peter	by Peter	2	3,139
Formulas change when macro adds new column Sandra	by Ken Johnson	3	511
Function Range Lookup AGAIN! robert	by Niek Otten	3	521
Change color of text if date is overdue Lynora	by Lynora	2	2,922
Count if BC	by BC	3	343
Function Range Lookup robert	by T. Valko	2	467
How do I create a FTP hyperlink in Excel Qman	by Gary''s Student	1	1,574
nested if statements using "AND" as well as "OR" ibbm	by David Biddulph[_2_]	3	474
If a cell is checked take words from a pivot table and place in a Brian	by Brian	4	513
How to change =SUM(R[-56]C:r[-1]c) to =SUM(D1:D2) ItsVegas_Baby	by Rick Rothstein	3	1,397
How can I search for a string of numeric digits within a text stri Eric_NY	by Rick Rothstein	9	518
Reference cells in seperate worksheet HR Gal	by Bernard Liengme	3	467
function range robert	by Rick Rothstein	2	353
MULTIPLE CONDITIONAL FORMATS Pattee	by Ron@Buy	5	410
sumif Neil	by Neil	2	380
Searching for strings in a column [email protected]	by Teethless mama	6	631
Maximum Characters in a cell Brosenberg7	by Dave Peterson	1	439
Present value of an annuity sleeplessinnewjersey	by sleeplessinnewjersey	4	1,250
Find Capital Letter Boogie	by Glenn	12	4,138
Date Format Problem Maperalia	by T. Valko	3	495
text match formula not working Belinda7237	by Belinda7237	2	1,822
Count function John Peterson[_2_]	by Steve	2	355
Insert rows but keep references in Excel RichterCa	by RichterCa	2	436
Function containing $ Dave	by Mike H	2	386
combining formulas benny29	by benny29	0	531
Cell Formatting Clare	by Gary''s Student	3	424
Multiple caculations using individual data jschlarb	by Pete_UK	1	388
Custom / Specilized Forms to enter data in Excel Gaylen	by Gaylen	2	472
SUMPRODUCT query Terry Bennett	by Terry Bennett	3	380
Highlighting Rows with VB. Xman	by Xman	12	867
Multiple entries last date Simo	by Mike H	1	519
compute date and time difference Neri	by Neri	5	1,957
return a text that is before "/" Piotr (Peter)[_2_]	by Max	3	555
Conditional format based on a different column ArcticWolf	by David Biddulph[_2_]	2	527
2009 Template for Attendance: How do I add multiple tabs of employ Ashleysquared	by Ron@Buy	1	714
countif with auto filter jwells2001	by T. Valko	1	571
Function for an array KatiJ	by T. Valko	3	470
range label works in VLOOKUP except if refenced in another cell brewmaker	by T. Valko	3	788
Moving average billregal	by smartin	1	636
I get the wrong answer when subtracting currency. Midwest	by Ron Rosenfeld	3	655
vlookup addition nt	by Pete_UK	6	456
SUMPRODUCT with multiple criteria [email protected]	by Pete_UK	11	1,088
Net should be zero but it is not; decimal values aroung the 12 dec frecar	by joeu2004	11	1,531
Next lower cell with number... Brad	by ryguy7272	2	530
Adding like cells from different workbooks Mr B[_2_]	by ryguy7272	1	469
Formula to add based on information from 2 different cells RennStempie2	by T. Valko	2	623
Hexadecimal to Decimal (and vice versa) Toria	by Toria	5	851
sorting multiple heather	by Joel	1	341
Sorting heather	by David Biddulph[_2_]	5	458
Sum a column correctly after more info is added by sorting Soulscream	by Pete_UK	9	534
A1=50, C1=50, E1=100(total of A1+C1) what % o f E1 is A1? DSSSS	by Gord Dibben	4	467
Excel 2003: Count how many times a date occurs lilhoot	by T. Valko	4	6,726
How do I create a multiselect drop down list Yve	by Gord Dibben	2	1,370
Lookup a reference, go to another worksheet, retrieve a block of d kiwi1962	by kiwi1962	2	476
How do I clear 'form' content from an unprotected cell without mac Casey M	by Gord Dibben	4	796
How to return a blank formula cell if the reference is blank? waybomb	by Bernard Liengme	2	1,954
Count function John Peterson	by JE McGimpsey	2	356