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	385
A fixed field format needs fronting zeroes for each cells value. CommerceMary	by CommerceMary	8	482
maybe i need a prof.formula for complex sump... driller	by driller	0	398
Looking up prices BEH1230	by BEH1230	3	546
HLOOKUP with 2 values and choose 1 value Positive	by Toppers	2	593
Averaging data with errors John Mac	by John Mac	4	861
HLOOKUP and choose one value among 2 values Positive	by Toppers	1	757
lookup multiples need help	by need help	2	637
Another Quetion about lookups with errors JD	by JD	4	596
Cell reference to make a directory path Dan Deschambault	by Pete_UK	10	1,478
I too think I got lost in cyberspace: Formula Help Dan the Man[_2_]	by Toppers	4	353
Hidden Character Sandy	by Sandy	2	422
Change cell background based on multiple cells [email protected]	by [email protected]	2	401
Calculate Average on specific items terri	by Toppers	4	424
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	411
Calculating Mintues Wendy	by tomek gomek	3	428
Unit Forcast Larry[_4_]	by Bernie Deitrick	1	519
for Toppers and Barb yodochi	by Bob Phillips	3	402
How to connect to database? Eric	by Bob Phillips	3	545
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	954
Formula to count number of sequential days in a row andreas	by andreas	2	1,275
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	820
VLookUp Nabil	by Nabil	3	380
Importing Data Into Excel Martin[_3_]	by Martin[_3_]	0	436
what is the difference between a worksheet and a workbook? unbornsin	by NickHK	1	1,425
Calculated Values ssoerens	by ssoerens	2	368
Decimal place + - button use in protected worksheet Aaron	by Aaron	4	1,000
adding specifics columns and rows yodochi	by Teethless mama	1	579
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,531
Final day of month B	by Roger Govier[_2_]	3	461
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	757
Lookup or Reference function ignoring errors JD	by JD	2	739
How do I write a macro that will allow users to set thier own pass David A.	by David A.	6	511
negative log Ebotoks	by Jerry W. Lewis	2	1,891
find email address in a cell Frederique	by Ron Rosenfeld	1	1,287
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,503
how to pull out the last day data in an array? [email protected]	by T. Valko	2	605
reference the latest date's data in an array [email protected]	by Toppers	2	509
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	526
xml emi	by Gord Dibben	1	383
Formula help please Joe Gieder	by Joe Gieder	4	311
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,792
ID and/or filter rows with 'Fill Color' TOMB	by TOMB	2	554
When save as another file, EDATE and XIRR functions return #N/A nguyensea	by nguyensea	0	466
Formula Funkyfido	by Max	4	430
Formatting Rows of Data based on Column Data mwmasch	by Max	3	910
help with match? I don't know what formula use new_121	by Bob Phillips	1	375
match function? I don't know what I can apply new_121	by Ivanl	1	430
Excel List Generation jrthomas	by jrthomas	0	398
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	453
Pivot charts - data disappear after selecting or data are static Patricia Maklari	by Patricia Maklari	0	847
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	470
Cells only display formula waladd	by doddski	10	757
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	381
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