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	384
A fixed field format needs fronting zeroes for each cells value. CommerceMary	by CommerceMary	8	475
maybe i need a prof.formula for complex sump... driller	by driller	0	391
Looking up prices BEH1230	by BEH1230	3	546
HLOOKUP with 2 values and choose 1 value Positive	by Toppers	2	588
Averaging data with errors John Mac	by John Mac	4	854
HLOOKUP and choose one value among 2 values Positive	by Toppers	1	754
lookup multiples need help	by need help	2	634
Another Quetion about lookups with errors JD	by JD	4	593
Cell reference to make a directory path Dan Deschambault	by Pete_UK	10	1,477
I too think I got lost in cyberspace: Formula Help Dan the Man[_2_]	by Toppers	4	353
Hidden Character Sandy	by Sandy	2	419
Change cell background based on multiple cells [email protected]	by [email protected]	2	391
Calculate Average on specific items terri	by Toppers	4	413
calculate backwards from agreed upon purchase price to SP inc tax rookie	by Toppers	2	1,222
column similarity Damian	by Ivanl	2	678
Link to SQL Database jgrebe	by jgrebe	0	401
Calculating Mintues Wendy	by tomek gomek	3	426
Unit Forcast Larry[_4_]	by Bernie Deitrick	1	514
for Toppers and Barb yodochi	by Bob Phillips	3	402
How to connect to database? Eric	by Bob Phillips	3	533
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	953
Formula to count number of sequential days in a row andreas	by andreas	2	1,265
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	819
VLookUp Nabil	by Nabil	3	379
Importing Data Into Excel Martin[_3_]	by Martin[_3_]	0	425
what is the difference between a worksheet and a workbook? unbornsin	by NickHK	1	1,424
Calculated Values ssoerens	by ssoerens	2	358
Decimal place + - button use in protected worksheet Aaron	by Aaron	4	989
adding specifics columns and rows yodochi	by Teethless mama	1	571
Averaging data and rounding up John Mac	by JLatham	3	392
Need a formula old coach	by Pete_UK	1	397
Displaying rolling data for a set time period JMK	by JMK	2	1,521
Final day of month B	by Roger Govier[_2_]	3	458
a second call for the goddezzez and godz of SUMPRODUCT [email protected]	by Elkar	2	426
Current Mortgage Balance JAH	by JAH	6	958
Counting unique dates based on selected criteria in a list orchid11652	by Peo Sjoblom	1	755
Lookup or Reference function ignoring errors JD	by JD	2	733
How do I write a macro that will allow users to set thier own pass David A.	by David A.	6	500
negative log Ebotoks	by Jerry W. Lewis	2	1,891
find email address in a cell Frederique	by Ron Rosenfeld	1	1,286
A change in my "Duplicate Names" formula please? Dan the Man[_2_]	by Dan the Man[_2_]	0	375
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	500
help with function Barb	by Ron Coderre	2	376
Find and Replace ClintG	by ClintG	2	340
finance functions not available Ivanl	by Gord Dibben	8	515
xml emi	by Gord Dibben	1	383
Formula help please Joe Gieder	by Joe Gieder	4	310
Excel formulas with text? scottydel	by Mike	1	296
Fill Series Suzanne	by Suzanne	8	479
change a spreadsheet from single spaced to double spaced? tud52	by Gord Dibben	3	1,781
ID and/or filter rows with 'Fill Color' TOMB	by TOMB	2	553
When save as another file, EDATE and XIRR functions return #N/A nguyensea	by nguyensea	0	457
Formula Funkyfido	by Max	4	430
Formatting Rows of Data based on Column Data mwmasch	by Max	3	907
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	423
Excel List Generation jrthomas	by jrthomas	0	391
How do I calculate total pay from [h]:mm times pay rate per hour? Rufus	by Rufus	2	2,896
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	443
Pivot charts - data disappear after selecting or data are static Patricia Maklari	by Patricia Maklari	0	840
worksheet amalgamation andrewbt	by JLatham	3	514
Payouts based on hours and rounding down if hour is not in list. The_Sleeper	by Bernie Deitrick	2	465
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	401
What is the formula that works for this dolson	by Billy Liddel	3	378
How do I get a calculated amount to round to the nearest nickel? Raina	by Bernd P	3	1,073
Look up text value [email protected]	by Max	1	458