Excel Worksheet Functions - Page 152

Thread / Thread Starter	Last Post	Replies	Views
create a dymamic range for printing Jeff	by Don Guillett	6	637
Firstname Lastname Field, Split two cells Anthony Smith	by Max	6	888
Same text in column as one inta251 via OfficeKB.com	by Joel	6	565
Trim Leading Spaces Steven	by daddylonglegs	6	757
How do I count the number of even weeks in the current month. dd	by Hans Terkelsen	6	1,587
SUMPRODUCT Formula Dan	by bj	6	459
IF function and DATES Excel_Oz	by Excel_Oz	6	514
AND/OR in Array Formula Rif	by Rif	6	650
If formula Chris	by Duke Carey	6	474
Counting using OR? [email protected]	by Bernd	6	378
Can this be done in Excel? Zilla[_2_]	by Debra Dalgleish	6	511
Conditionally retain rows wal50	by Don Guillett	6	406
Produce the most recent date Julie	by David Biddulph	6	507
Formula True False help Lisa	by bj	6	474
Change number format with IF statement Time Bandit	by Lori	6	929
Count Unique Numbers Averitt Engineer	by Harlan Grove	6	594
Count numbers in list Arne Hegefors	by Ron Coderre	6	542
Condit Format? Make date change colors tkg	by David Biddulph	6	1,047
How do I copy a formula all the way down a column........ lucdol	by Mike Rogers	6	2,172
Formula for Repeating the Same Date Each Year Dickie Worton	by Dana DeLouis	6	1,646
SELECT Query TJ[_2_]	by Harlan Grove[_2_]	6	467
CONCATENATE problem Mark Dullingham	by Mark Dullingham	6	950
Need help with pulling out data between brackets Bob Smith	by Teethless mama	6	1,083
how to formulate this easily??? driller	by driller	6	496
combining LOOKUP and IF functions ntnnj26	by Joel	6	632
Help me understand Transpose S Davis	by S Davis	6	574
Copying absolute VLOOKUP Martha	by driller	6	1,058
date() function error [email protected]	by JE McGimpsey	6	349
array match Mike S	by Max	6	880
Converting Test Scores to somewhat of a Linear Transformation [email protected]	by MartinW	6	2,064
Creating a strange list :S Phil(tech)	by Gord Dibben	6	335
how do I remove leading spaces and leave the remianing spaces w Debi	by Dave Peterson	6	1,409
Tab name in specific cell Steve	by Steve	6	429
Retrieve the Nth element in a dataset Epinn	by T. Valko	6	1,240
change first 2 digit ignore the other 2. Steved	by Steved	6	534
COUNTIF(LEFT('SpreadSheet1!A1:A25, 1), "A") Dorian C. Chalom	by ShaneDevenshire	6	3,630
Conditional formatting - Highlighting a row Coco	by Coco	6	1,409
Count dynamic range S Davis	by Harlan Grove	6	947
Hide #VALUE! in result of array formula Ron Weaver	by Ron Weaver	6	1,294
Count in two columns [email protected]	by [email protected]	6	481
Date format error in Excel Richy Rich	by Teethless mama	6	1,894
VLOOKUP Looking In Different Workbook Confusion leaning_forward	by Marc	6	520
subtotal functions Louise	by Dave Peterson	6	452
Sumproduct - Pulling info based on lenght of time between dates watchtower	by watchtower	6	637
FIFI Method Naina	by Naina	6	766
keep the results as positive numbers Raza	by Ron Coderre	6	616
excell worksheets BillyBob	by Don Guillett	6	573
IF statement to calculate time usage in specific time bands Daren	by Daren	6	1,971
automatic formatting phone numbers in excel ApyoTech	by Teethless mama	6	1,269
3 nested IFs causes error Bob	by Bob	6	994
Time Calculation Sam	by David Biddulph	6	387
Checking if information in a cell is within a column Andrew M.	by Andrew M.	6	530
Unique draws "Football" Michael	by Michael	6	478
Conditional sums for adjacent cells Eric	by Eric	6	631
formulas from tab to tab KMH	by shail	6	325
SUM conditioned to range Pedro AM	by Don Guillett	6	573
MAX figure within a date range as a function of today()'s date irvine79	by Max	6	1,326
Match & combine rows from 2 worksheets Doug	by Doug	6	641
Expiry date Martina	by Martina	6	1,220
If Statement Help Ben	by Ben	6	351
isBlank() alex	by JE McGimpsey	6	953
Calculating birthday - yet another newcomer!! Alberte	by Stefi	6	751
Help with Lookup(), VLookup phil	by driller	6	612
ranking Blade370	by Blade370	6	663
Times in Excel Annie	by Epinn	6	375
converting military time JT	by JT	6	2,626
extracting numbers from alphanumeric cells Mary	by Johnny	6	840
Formula to determine number of current records by week Keith	by Lori	6	656
The IF function but with 3 values [email protected]	by JE McGimpsey	6	467
Extract value from Specific Cell Dinesh	by Herbert Seidenberg	6	608
Beginning of Pay Period for Bi-Weekly Timesheet Don	by Don	6	1,541
Finding last column in non-contiguous range Bob	by Bob	6	686
need help please..... fiur	by Bernd	6	401
Sumproduct based which also weights data based on date ExcelMonkey	by Bernd	6	861
Extract data from a table shnim1	by Max	6	631