Excel Worksheet Functions - Page 671

Thread / Thread Starter	Last Post	Replies	Views
Find and Replace ClintG	by ClintG	2	332
help with function Barb	by Ron Coderre	2	370
reference the latest date's data in an array [email protected]	by Toppers	2	481
how to pull out the last day data in an array? [email protected]	by T. Valko	2	589
Conditional Formatting on Null Value Ember	by Ember	4	2,483
A change in my "Duplicate Names" formula please? Dan the Man[_2_]	by Dan the Man[_2_]	0	366
find email address in a cell Frederique	by Ron Rosenfeld	1	1,267
negative log Ebotoks	by Jerry W. Lewis	2	1,883
How do I write a macro that will allow users to set thier own pass David A.	by David A.	6	477
Lookup or Reference function ignoring errors JD	by JD	2	721
Counting unique dates based on selected criteria in a list orchid11652	by Peo Sjoblom	1	729
Current Mortgage Balance JAH	by JAH	6	942
a second call for the goddezzez and godz of SUMPRODUCT [email protected]	by Elkar	2	415
Final day of month B	by Roger Govier[_2_]	3	442
Displaying rolling data for a set time period JMK	by JMK	2	1,504
Need a formula old coach	by Pete_UK	1	394
Averaging data and rounding up John Mac	by JLatham	3	382
adding specifics columns and rows yodochi	by Teethless mama	1	530
Decimal place + - button use in protected worksheet Aaron	by Aaron	4	962
Calculated Values ssoerens	by ssoerens	2	345
what is the difference between a worksheet and a workbook? unbornsin	by NickHK	1	1,413
Importing Data Into Excel Martin[_3_]	by Martin[_3_]	0	410
VLookUp Nabil	by Nabil	3	363
Sum multiple arrays of data according to criteria [email protected]	by [email protected]	7	794
Array Amul	by vezerid	2	278
Change to day format Blue Fish	by Toppers	2	361
Formula to count number of sequential days in a row andreas	by andreas	2	1,236
How can I handle duplicates in an Index function? investor9987	by Max	1	943
Conditional Formatting for alternate client refs Sarah (OGI)	by Sarah (OGI)	4	528
How to connect to database? Eric	by Bob Phillips	3	516
for Toppers and Barb yodochi	by Bob Phillips	3	388
Unit Forcast Larry[_4_]	by Bernie Deitrick	1	496
Calculating Mintues Wendy	by tomek gomek	3	400
Link to SQL Database jgrebe	by jgrebe	0	392
column similarity Damian	by Ivanl	2	644
calculate backwards from agreed upon purchase price to SP inc tax rookie	by Toppers	2	1,199
Calculate Average on specific items terri	by Toppers	4	398
Change cell background based on multiple cells [email protected]	by [email protected]	2	365
Hidden Character Sandy	by Sandy	2	397
I too think I got lost in cyberspace: Formula Help Dan the Man[_2_]	by Toppers	4	346
Cell reference to make a directory path Dan Deschambault	by Pete_UK	10	1,461
Another Quetion about lookups with errors JD	by JD	4	579
lookup multiples need help	by need help	2	618
HLOOKUP and choose one value among 2 values Positive	by Toppers	1	736
Averaging data with errors John Mac	by John Mac	4	837
HLOOKUP with 2 values and choose 1 value Positive	by Toppers	2	576
Looking up prices BEH1230	by BEH1230	3	526
maybe i need a prof.formula for complex sump... driller	by driller	0	373
A fixed field format needs fronting zeroes for each cells value. CommerceMary	by CommerceMary	8	462
take the green pill or take the SUMPRODUCT? [email protected]	by bj	3	374
sum question Rebecca1	by Harlan Grove	2	412
Finding The MAX Value carl	by Jim Thomlinson	6	780
Counting unique items based on date DKS	by Ron Coderre	19	1,406
plus 1 alex	by Gord Dibben	10	810
Graphs not updating MLK	by MLK	2	775
Sorting dates Old Keith	by Old Keith	6	488
Function in objects. Anderflash	by Anderflash	5	509
Can excel list combinations BOJO	by Max	1	2,101
Extracting Rows to Make A Totals Sheet Savage	by Max	5	589
LOOKUP Formula Kimo	by T. Valko	15	1,126
STDEV function on selected values Tetsuya Oguma	by Jerry W. Lewis	1	591
Sheet Background does not print Corey	by Corey	3	290
Average nesting within Sumproduct? Twishlist	by T. Valko	3	525
How to run a macro with the IF command deancarpenter	by deancarpenter	4	606
Difference of two dates Zafar	by David Biddulph[_2_]	3	624
Need a formula, please! JessB	by Arvi Laanemets	3	398
assigning values to one cell which will change the formula in anot Darren	by Stephane Quenson	1	533
How to calculate the Date occurs Blue Fish	by Blue Fish	2	493
DATE Jamal A M	by Toppers	2	339
how do i separate 2 strings of a cell in different cells? Bona	by Toppers	1	712
Need to creat dependent drop down list manu	by papou	2	661
How to format cell to display "NIL" if value of cell is zero in Ex Suyog	by tomek gomek	3	1,495
Letters to represent numbers AlexG	by CLR	3	777
TREND function for a polynomial fit results in a linear fit chenke01	by chenke01	2	1,140
Rounding problems Ste101	by Pete_UK	6	508