Excel Worksheet Functions - Page 103

Thread / Thread Starter	Last Post	Replies	Views
Evaluate 5 columns and return right-most name JulesMacD	by T. Valko	7	632
If And using dates Newbie and Lost	by Rick Rothstein	7	547
concatenate and multiply problem tipoo	by tipoo	7	2,811
Two Criteria = 1 Jazz	by Jazz	7	530
Nesting more than 7 IF statements (Excel 2003) Dee	by Pete_UK	7	1,075
Sum Fareez	by Jacob Skaria	7	560
use a function for filtered data debl	by T. Valko	7	708
Changing part of cell reference in INDEX - MATCH formula HebbeLille	by Max	7	749
Conditional Formatting RMartin	by T. Valko	7	670
formula mon732	by T. Valko	7	424
Formula in CF dlamarche	by Dana DeLouis[_3_]	7	466
formula required to return data from one column Rich Hayes	by T. Valko	7	580
set up macro to goto cell with "today" in Stuart WJG	by Bernie Deitrick	7	884
a formula that returns the previous fridays date diggyroo	by Ron Rosenfeld	7	576
Date function - need help Ann	by pai	7	425
remove hyperlinks in a worksheet all in the same time Kent	by Kent	7	564
DAYS360---How come the days do not add up to be 360? butterscotch	by butterscotch	7	1,347
Remove dashes between letters and between letters and digits [email protected]	by Bernie Deitrick	7	1,211
Count IF Function Manos	by Manos	7	555
Percentage Calculation Chris	by Chris	7	775
Two Criteria COUNTIF Mike	by Mike	7	565
Cell reference in VBA Tami	by JLatham	7	478
Looking up first and last DRC	by T. Valko	7	404
Possibly Too Many Arguments Karen	by Karen	7	714
Sum Column above current cell dynamically using function call TopSlice	by TopSlice	7	690
Weekending Date w/Less Than 3 days Assoc. with Prior Month MoneyMan	by T. Valko	7	525
Is it possible to change the normal excell icon on an excell file? Romileyrunner1	by Gord Dibben	7	684
If Statement with Wildcards not Working cr0375	by Ashish Mathur[_2_]	7	1,162
Nested IFs and multiples Karl	by Shane Devenshire[_2_]	7	549
how to get a function to return a null value that passes the ISBL. Hawk	by dougcsdp	7	622
Maximum value within a time range Somnifer	by Pete_UK	7	803
Finding last used column ken	by ken	7	416
FIND 2nd character in a string Fuzzy	by Fuzzy	7	4,029
Copying a formula containing the INDIRECT function Pelham[_2_]	by T. Valko	7	1,256
Conditional Formatting color doesn't show up: 90% Stu	by Shane Devenshire[_2_]	7	724
Extracting data SMD	by SMD	7	682
how to check for days of the week Gary	by Rajesh Mehmi	7	1,042
concatenate dynamic ranges RD Wirr	by Bernie Deitrick	7	1,520
How to calculate a pay-back period by the accumulated cash-flow automatically? Dmitry Kopnichev	by Dima	7	1,475
Returning the last modified date to a cell in excel 2003 Dunc	by Rick Rothstein	7	1,938
BETTER SPACING - If Then Date Range Mark B	by vezerid	7	353
x and x+1 stephenlewin	by stephenlewin	7	346
Please help me with a formula Smeeg	by Smeeg	7	397
Auto color-shading of rows Fitz	by Adrian	7	423
Automatically Enter Data Derek Y via OfficeKB.com	by Trevor Shuttleworth	7	341
Totalling formulas Steved	by Steved	7	392
How do I filter names using only the first letter? Mr_Sparkly	by Mangus Pyke	7	1,150
Bonus Calculation problem JRinDallas	by srinivasan	7	380
if then function Pam	by Pete_UK	7	329
A SIMPLER FORMULA TO GET A REFERENCE OF WHICH COLUMN IS POPULATED Ravi	by Krishnakumar	7	611
List of repeating names johnT	by Aladin Akyurek	7	1,710
HELP....Is there a way to automate copy/paste special/transpose - Mel	by Max	7	1,645
Look up of data in a different Sheet Pester	by Pester	7	640
Function/macro to relocate RxC to CxR? J.Kearney	by Don Cameron	7	407
Simplify Vlookup function in Excel Budman	by Ernst Guckel	7	1,886
Formula Trouble JS	by JulieD	7	632
ACCRINT formula yields incorrect result Onurali_k	by Onurali_k	7	967
SumProduct making things work slow Adam Graham	by Charles Williams	7	656
How to read workbook (not worksheet) properties with OLEDB 4everDad	by Bob Barrows [MVP]	7	736
How do you use a If/then statement? JBG	by Pete_UK	7	543
Stop zero on cell Amnon Wilensky	by Amnon Wilensky	7	394
Vlookup does not return approx match djd	by T. Valko	7	976
moving the refrence to the 5th cell while dragging. Gary	by Bob Phillips	7	485
Conditional Formatting based on entire column mike	by Bob Phillips	7	949
Ranking on several fields Michael Chappell	by Rupert	7	379
locking vlookup formulas Jane	by JLatham	7	831
Wildcards with SumProduct pomalley	by pomalley	7	1,025
copying formula without scrolling 9000 rows chiechka	by Harlan Grove	7	946
If Date Null Show Nothing Ardy	by Ardy	7	2,071
sheet protection - only selected range to be able to select/input data Corey	by Gord Dibben	7	920
Defined name Relative to sheets Sige	by Sige	7	490
How to return a value between date ranges Mary-Lou	by Marcelo	7	1,182
Count non consecutive columns [email protected]	by [email protected]	7	528
transferring formats jonas.ornborg	by Pete_UK	7	431
Conditional formatting works, is there a better way? James E Middleton	by James E Middleton	7	531