Excel Worksheet Functions - Page 513

Thread / Thread Starter	Last Post	Replies	Views
take the green pill or take the SUMPRODUCT? [email protected]	by bj	3	382
A fixed field format needs fronting zeroes for each cells value. CommerceMary	by CommerceMary	8	474
maybe i need a prof.formula for complex sump... driller	by driller	0	388
Looking up prices BEH1230	by BEH1230	3	546
HLOOKUP with 2 values and choose 1 value Positive	by Toppers	2	586
Averaging data with errors John Mac	by John Mac	4	853
HLOOKUP and choose one value among 2 values Positive	by Toppers	1	752
lookup multiples need help	by need help	2	629
Another Quetion about lookups with errors JD	by JD	4	592
Cell reference to make a directory path Dan Deschambault	by Pete_UK	10	1,467
I too think I got lost in cyberspace: Formula Help Dan the Man[_2_]	by Toppers	4	353
Hidden Character Sandy	by Sandy	2	413
Change cell background based on multiple cells [email protected]	by [email protected]	2	383
Calculate Average on specific items terri	by Toppers	4	412
calculate backwards from agreed upon purchase price to SP inc tax rookie	by Toppers	2	1,220
column similarity Damian	by Ivanl	2	654
Link to SQL Database jgrebe	by jgrebe	0	401
Calculating Mintues Wendy	by tomek gomek	3	425
Unit Forcast Larry[_4_]	by Bernie Deitrick	1	511
for Toppers and Barb yodochi	by Bob Phillips	3	400
How to connect to database? Eric	by Bob Phillips	3	529
Conditional Formatting for alternate client refs Sarah (OGI)	by Sarah (OGI)	4	537
How can I handle duplicates in an Index function? investor9987	by Max	1	952
Formula to count number of sequential days in a row andreas	by andreas	2	1,263
Change to day format Blue Fish	by Toppers	2	368
Array Amul	by vezerid	2	285
Sum multiple arrays of data according to criteria [email protected]	by [email protected]	7	814
VLookUp Nabil	by Nabil	3	379
Importing Data Into Excel Martin[_3_]	by Martin[_3_]	0	421
what is the difference between a worksheet and a workbook? unbornsin	by NickHK	1	1,421
Calculated Values ssoerens	by ssoerens	2	357
Decimal place + - button use in protected worksheet Aaron	by Aaron	4	987
adding specifics columns and rows yodochi	by Teethless mama	1	540
Averaging data and rounding up John Mac	by JLatham	3	390
Need a formula old coach	by Pete_UK	1	397
Displaying rolling data for a set time period JMK	by JMK	2	1,520
Final day of month B	by Roger Govier[_2_]	3	457
a second call for the goddezzez and godz of SUMPRODUCT [email protected]	by Elkar	2	421
Current Mortgage Balance JAH	by JAH	6	949
Counting unique dates based on selected criteria in a list orchid11652	by Peo Sjoblom	1	743
Lookup or Reference function ignoring errors JD	by JD	2	730
How do I write a macro that will allow users to set thier own pass David A.	by David A.	6	499
negative log Ebotoks	by Jerry W. Lewis	2	1,890
find email address in a cell Frederique	by Ron Rosenfeld	1	1,281
A change in my "Duplicate Names" formula please? Dan the Man[_2_]	by Dan the Man[_2_]	0	373
Conditional Formatting on Null Value Ember	by Ember	4	2,494
how to pull out the last day data in an array? [email protected]	by T. Valko	2	598
reference the latest date's data in an array [email protected]	by Toppers	2	496
help with function Barb	by Ron Coderre	2	375
Find and Replace ClintG	by ClintG	2	337
finance functions not available Ivanl	by Gord Dibben	8	511
xml emi	by Gord Dibben	1	381
Formula help please Joe Gieder	by Joe Gieder	4	308
Excel formulas with text? scottydel	by Mike	1	293
Fill Series Suzanne	by Suzanne	8	479
change a spreadsheet from single spaced to double spaced? tud52	by Gord Dibben	3	1,780
ID and/or filter rows with 'Fill Color' TOMB	by TOMB	2	551
When save as another file, EDATE and XIRR functions return #N/A nguyensea	by nguyensea	0	457
Formula Funkyfido	by Max	4	428
Formatting Rows of Data based on Column Data mwmasch	by Max	3	903
help with match? I don't know what formula use new_121	by Bob Phillips	1	374
match function? I don't know what I can apply new_121	by Ivanl	1	421
Excel List Generation jrthomas	by jrthomas	0	390
How do I calculate total pay from [h]:mm times pay rate per hour? Rufus	by Rufus	2	2,894
what exactly prevents INDIRECT from accessing closed worksheets? z.entropic	by z.entropic	3	964
Using a cell value in its own calculation [email protected]	by [email protected]	5	442
Pivot charts - data disappear after selecting or data are static Patricia Maklari	by Patricia Maklari	0	834
worksheet amalgamation andrewbt	by JLatham	3	512
Payouts based on hours and rounding down if hour is not in list. The_Sleeper	by Bernie Deitrick	2	462
Cells only display formula waladd	by doddski	10	747
How can I do this Formula??? dee24298	by Ron Rosenfeld	2	356
Sum If Alex	by Alex	3	399
What is the formula that works for this dolson	by Billy Liddel	3	377
How do I get a calculated amount to round to the nearest nickel? Raina	by Bernd P	3	1,071
Look up text value [email protected]	by Max	1	458