Excel Worksheet Functions - Page 97

Thread / Thread Starter	Last Post	Replies	Views
Formula for searching spreadsheet Lozza65	by Pete_UK	7	548
Sumproduct with filters Andy	by Mike H	7	516
Excel Formula Help sibboo	by sibboo	7	502
Need Text columns to pull into subtotal lines Denise	by Ashish Mathur[_2_]	7	575
slecting all entries to appear once Resi	by Resi	7	386
Month Christine[_3_]	by Ashish Mathur[_2_]	7	357
Mod Function Diogo	by Dana DeLouis	7	4,063
Excel Formula Newfie809	by David Biddulph[_2_]	7	314
How do I fill every other line with a color? deann	by JMB	7	529
#DIV/0! - how to get rid of it Douglas @ Helpdesk	by Dana DeLouis	7	786
Trouble with a Formula I need help with??? MUmfleet	by Fred Smith[_4_]	7	545
Conditional formula tsterople	by T. Valko	7	365
WANT TO MAKE A FORMULA RETURN A BLANK CELL (VS 0) GEORGE ZEIGLER, SAN DIEGO	by GEORGE ZEIGLER, SAN DIEGO[_2_]	7	1,828
Count duplicate cell values per month Derek	by T. Valko	7	1,222
How can I creat userdefine function Montu	by Montu	7	496
replace error with blank chegel	by chegel	7	794
=CELL("color",a1) Fris	by Niek Otten	7	490
Help needed with a function CP	by Pete_UK	7	344
Subtracting Dates Terry Bennett	by Terry Bennett	7	405
file name in a formula MAANI	by Dave Peterson	7	440
Excel Functions LNS	by T. Valko	7	473
Help with INDIRECT GoBucks[_2_]	by Ashish Mathur[_2_]	7	525
Strip Out Four Characters, then Average ryguy7272	by Ashish Mathur[_2_]	7	508
IF Formulas and Summing Results WilliamsDeLisle	by Ashish Mathur[_2_]	7	641
Countif & Sumif fx ref data in multiple columns hal1011	by Domenic[_2_]	7	750
Sumif by month and year Josh Hendrickson[_2_]	by T. Valko	7	1,610
Grouping above in Excel 2007 SJKM	by Sheeloo[_4_]	7	1,261
Still stumped LarryK	by Ashish Mathur[_2_]	7	516
Nest 3 SUMPRODUCT formulas - Possible? Bert T	by Bert T	7	439
Formating Question carl	by Ron Rosenfeld	7	421
What does =#N/A do in excel? Rick	by Rick Rothstein	7	816
Result not greater than ............. Donna	by Donna	7	311
SUM/COUNTIF across multiple worksheets Brandy	by Lori Miller	7	742
Formula to identify text into columns Forgone	by Jarek Kujawa[_2_]	7	516
Pivot Table Percentage of Sub-Total Michelle	by Herbert Seidenberg	7	3,350
SumProduct ColleenK	by ColleenK	7	475
Filling down text in increments of three Josh W	by Dave Curtis[_2_]	7	558
Map of used names? Michael.Tarnowski	by Michael.Tarnowski	7	344
I NEED A FLEXIBLE FORMULA QC Coug	by Cutter	7	482
Some sort of lookup formula required Syndrome	by driller	7	606
referencing to a sheet that it`s name is stored on a cell [email protected]	by [email protected]	7	595
Data Validation Help kaci	by Max	7	377
IF Function and a formula Fred Atkinson	by Fred Atkinson	7	489
if statements with multiple returns Batman	by Aladin Akyurek	7	459
Vlookup problem... boousaf	by T. Valko	7	536
Counting dates, within a list of dates jrheinschm	by Bob Phillips	7	731
Switching Subcategories into Categories and Vice Versa [email protected]	by Ron Coderre	7	956
ranking with some blank spaces LRR via OfficeKB.com	by Aladin Akyurek	7	756
using vlookup within an if statement Sweetetc	by Sweetetc	7	601
To get values into an array Darren1o1	by Harlan Grove	7	541
"IF" function - 7 nested limit Ed	by Harlan Grove	7	673
Need to Sum Mon-Sat each seven days; Average Sunday Robert Moore	by Robert Moore	7	761
How to lookup row # based on content of another column's cell Mr. Jan Park	by RagDyer	7	791
return array result in cell based on comparing dates Ruthki	by Max	7	940
Vlookup or If statement Help JPriest	by NaturalLogZero	7	590
How do I import from Quickbooks and create a link. weclean	by Fredrik Wahlgren	7	909
In Excel, I want to have all telephone numbers display in the sam. Fluffy from Wisconsin	by Ron Rosenfeld	7	708
Array Lookup to Find Closest Date and Next Closest Date [email protected]	by RagDyer	7	2,256
How do you make Conditional Formating work? Stupac09	by JP[_3_]	7	570
Identifying text to split into columns Cynthia	by Cynthia	7	679
Left worksheet function Fiona	by MartinW	7	464
mad cows disease? Meebers	by Pete_UK	7	490
INDIRECT Formula with an IF Then issue Eden397	by T. Valko	7	610
Check Box Brian Smith	by JW[_2_]	7	484
sumproduct Formula PLEASE HELP cdw	by cdw	7	509
SUMIF with two conditions (or) [email protected]	by [email protected]	7	352
Macro to delete data in 'green' cells only Steve	by JulieD	7	1,131
Comparing figures across 2 columns. bollard	by MartinW	7	426
Question re Vlookup function within Excel. 007juk	by Niek Otten	7	596
TABLE function - not recalculating correctly Jacob	by ED2	7	535
Formula Noelline	by Jerry W. Lewis	7	368
remove time stamp from date in excel Nmeyer	by Ron Coderre	7	3,719
Subtotal Formula Pat[_2_]	by Peo Sjoblom	7	570
IF and LOOKUP formulas Sue	by shail	7	628
Opening Excel file on a specific worksheet sdhaight	by Dave Peterson	7	776