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,508
IF, but Not to Exceed dnamertz	by Shane Devenshire[_2_]	4	1,490
count entries that equal one criteria if another column meets anot ccKennedy	by Shane Devenshire[_2_]	9	1,417
Function to Change Font Jay	by Shane Devenshire[_2_]	1	451
IRR gotahavit	by Ron Rosenfeld	20	1,885
Find In Set Rod	by Teethless mama	4	331
Zero-Length string vs Zero (also a valid value) [email protected]	by [email protected]	2	644
UniquifyForUser error for Essbase AddIN John	by Charles Williams	1	2,148
Help Payroll calculation problem Tia[_3_]	by David Biddulph[_2_]	1	707
Subtracting partial hours Melissa F	by T. Valko	1	509
Use of the COUNTIF function JCameron	by Philip Mark Hunt	11	1,934
Some kind of Array-Sumproduct Function ryguy7272	by Max	18	1,008
Extract multiple results based on multiple criteria tara657	by Herbert Seidenberg	4	1,147
Age based on birthdate Squid	by Fred Smith[_4_]	2	761
got a tough on and I am confused were to start [email protected]	by smartin	4	375
function range robert	by Joel	1	334
data validation list form sheet [email protected]	by Debra Dalgleish	1	504
drop down function [email protected]	by [email protected]	2	306
Creating drop downs for part number configuration Peter	by Peter	2	3,107
Formulas change when macro adds new column Sandra	by Ken Johnson	3	487
Function Range Lookup AGAIN! robert	by Niek Otten	3	496
Change color of text if date is overdue Lynora	by Lynora	2	2,895
Count if BC	by BC	3	324
Function Range Lookup robert	by T. Valko	2	445
How do I create a FTP hyperlink in Excel Qman	by Gary''s Student	1	1,535
nested if statements using "AND" as well as "OR" ibbm	by David Biddulph[_2_]	3	432
If a cell is checked take words from a pivot table and place in a Brian	by Brian	4	490
How to change =SUM(R[-56]C:r[-1]c) to =SUM(D1:D2) ItsVegas_Baby	by Rick Rothstein	3	1,381
How can I search for a string of numeric digits within a text stri Eric_NY	by Rick Rothstein	9	503
Reference cells in seperate worksheet HR Gal	by Bernard Liengme	3	442
function range robert	by Rick Rothstein	2	333
MULTIPLE CONDITIONAL FORMATS Pattee	by Ron@Buy	5	383
sumif Neil	by Neil	2	357
Searching for strings in a column [email protected]	by Teethless mama	6	600
Maximum Characters in a cell Brosenberg7	by Dave Peterson	1	423
Present value of an annuity sleeplessinnewjersey	by sleeplessinnewjersey	4	1,238
Find Capital Letter Boogie	by Glenn	12	4,120
Date Format Problem Maperalia	by T. Valko	3	446
text match formula not working Belinda7237	by Belinda7237	2	1,792
Count function John Peterson[_2_]	by Steve	2	336
Insert rows but keep references in Excel RichterCa	by RichterCa	2	410
Function containing $ Dave	by Mike H	2	363
combining formulas benny29	by benny29	0	503
Cell Formatting Clare	by Gary''s Student	3	402
Multiple caculations using individual data jschlarb	by Pete_UK	1	365
Custom / Specilized Forms to enter data in Excel Gaylen	by Gaylen	2	448
SUMPRODUCT query Terry Bennett	by Terry Bennett	3	365
Highlighting Rows with VB. Xman	by Xman	12	846
Multiple entries last date Simo	by Mike H	1	505
compute date and time difference Neri	by Neri	5	1,919
return a text that is before "/" Piotr (Peter)[_2_]	by Max	3	535
Conditional format based on a different column ArcticWolf	by David Biddulph[_2_]	2	502
2009 Template for Attendance: How do I add multiple tabs of employ Ashleysquared	by Ron@Buy	1	689
countif with auto filter jwells2001	by T. Valko	1	544
Function for an array KatiJ	by T. Valko	3	447
range label works in VLOOKUP except if refenced in another cell brewmaker	by T. Valko	3	766
Moving average billregal	by smartin	1	606
I get the wrong answer when subtracting currency. Midwest	by Ron Rosenfeld	3	633
vlookup addition nt	by Pete_UK	6	436
SUMPRODUCT with multiple criteria [email protected]	by Pete_UK	11	1,047
Net should be zero but it is not; decimal values aroung the 12 dec frecar	by joeu2004	11	1,502
Next lower cell with number... Brad	by ryguy7272	2	511
Adding like cells from different workbooks Mr B[_2_]	by ryguy7272	1	443
Formula to add based on information from 2 different cells RennStempie2	by T. Valko	2	602
Hexadecimal to Decimal (and vice versa) Toria	by Toria	5	815
sorting multiple heather	by Joel	1	321
Sorting heather	by David Biddulph[_2_]	5	438
Sum a column correctly after more info is added by sorting Soulscream	by Pete_UK	9	509
A1=50, C1=50, E1=100(total of A1+C1) what % o f E1 is A1? DSSSS	by Gord Dibben	4	455
Excel 2003: Count how many times a date occurs lilhoot	by T. Valko	4	6,696
How do I create a multiselect drop down list Yve	by Gord Dibben	2	1,349
Lookup a reference, go to another worksheet, retrieve a block of d kiwi1962	by kiwi1962	2	448
How do I clear 'form' content from an unprotected cell without mac Casey M	by Gord Dibben	4	760
How to return a blank formula cell if the reference is blank? waybomb	by Bernard Liengme	2	1,909
Count function John Peterson	by JE McGimpsey	2	335