Excel Worksheet Functions - Page 433

Thread / Thread Starter	Last Post	Replies	Views
IF, AND, OR Function Pete_UK	by Pete_UK	0	377
auto-complete from a drop down list and from a different workbook [email protected]	by Gord Dibben	1	560
can windows vista edit shared document from windows xp sasa	by Gord Dibben	1	900
Using the CountIf function with multiple criteria? Jonathan	by Bob Phillips	11	1,151
Countif text in individual cells q3pd	by David Biddulph[_2_]	5	766
Automatically update spreadsheet from another spreadsheet Cindy	by Cindy	3	3,185
Opening an .mdb file in Excel lehigh46	by ryguy7272	2	3,116
IF, AND, OR Function talltom	by talltom	3	452
Days between dates including start day and weekends JessP27	by Pete_UK	7	1,198
Creating running clocks in multiple cells. MikeG	by CLR	9	546
filter dates by quarter Larry	by Larry	4	1,791
Stop excel rounding my 16/17 digit numbers E Halliday	by Pete_UK	2	2,802
Hyperlink to Named Range Based On Cell Contents TKS_Mark	by Dave Peterson	1	1,098
copy many sheets into one Annie_Ioceva	by Ron de Bruin	1	467
Calling AutoFit using macro in XLCALL.h [email protected]	by Dave Peterson	1	489
Dave Peterson Bob Myers	by Dave Peterson	2	483
What is the NNTP for this newsgroup? ExcelMonkey	by Dave Peterson	4	458
Extract everything to the right in cell when a number is encounter Matt	by Ron Rosenfeld	4	997
Copy Unique Entries TimJames	by TimJames	0	382
editing a query Texas Tonie[_2_]	by Texas Tonie[_2_]	4	461
calculating and coloring [email protected]	by Mike H	1	394
YEAR and IF PAL	by Pete_UK	2	388
link data to worksheets john	by john	6	546
Working with worksheets james	by David Biddulph[_2_]	7	543
#VALUE & #DIV0 tonyalt3	by tonyalt3	2	646
VBA to reattempt to open if file is read only Jive	by Jive	4	5,090
Formula displayd as text ??? Jock	by Jock	2	323
MAX formula? jane	by CLR	4	466
Equate numbers to text hpum	by Gary''s Student	1	421
Created IF functions - Need sum of results TMH0522	by Arvi Laanemets	4	602
If statement when two cells are the same q3pd	by q3pd	2	1,248
Function for visible cells only [email protected]	by Roger Govier[_3_]	1	413
vlookup on first occurrence of X after Y? jim	by Dave Peterson	3	898
IF, Then Uyen-Uyen	by Don Guillett	6	443
copying data to different worksheets in the same workbook Veronica Johnson	by Gord Dibben	1	657
Excel Formula Question pantherguy	by Roger Govier[_3_]	3	344
Running Sum question LisaK	by Roger Govier[_3_]	5	484
Figuring Late Payment on Mortgage Bzzygrl	by joeu2004	3	1,019
Opening a file stops a Macro Bob Myers	by Dave Peterson	2	1,313
DSUM Jed	by Jed	0	416
RANK without a tie jane	by jane	3	1,438
Index Function Carrie	by T. Valko	1	498
Excel 2003 C	by Max	1	350
Subtotal function not available Graeme	by jenn	3	1,788
Hyperlink Rooky228	by Rooky228	4	335
formula for counting the occurence of more than one condition Dr Carl	by T. Valko	2	513
Count all €œZ€ in a Range ryguy7272	by T. Valko	4	1,665
Column List to Multiple Columns TStirling	by Pete_UK	5	606
General Ledger Template Cyndi	by ryguy7272	1	2,079
How do I Hi- lite the max of last 20 entries Joe Goz	by Rick Rothstein \(MVP - VB\)	5	591
Extracting data from hyperlinked spreadsheets akfrumtarn	by ryguy7272	3	695
Merge problem Bird Byte	by Jim Cone	5	421
Some text won't print from my worksheet Carolyn	by Richard O. Neville	1	749
Where are the add-ins Sandy	by Tyro[_2_]	2	398
How do I change a file displayed in thousands to millions? DW	by CLR	3	2,765
ODBC AfterRefresh Event and Shared Workbook Paul	by Paul	0	568
Using INDEX and it Returns a #N/A Crazyhorse	by Pete_UK	2	546
Lock cell formats (conditional format) Saintsman	by ryguy7272	1	650
Pivot Table Source ryguy7272	by Ron Coderre	3	462
Percentage function Rachel Bixby	by Tyro[_2_]	6	547
Excel 2007 Vlookup Using New Table Syntax [email protected]	by [email protected]	2	1,371
First working day of the month Hedgie	by Ron Coderre	2	958
Macro to change time format.... neilcarden	by Bernie Deitrick	1	955
Can function be applied to range in sumif prior to criteria check? Cheese_whiz	by Cheese_whiz	4	396
Copying Worksheets Neil169	by ryguy7272	1	579
Auto Capital Letter in a cell Montu	by Bernie Deitrick	3	1,931
Obtain row number of active cell Jive	by papou[_4_]	4	821
SUMIF < Cooz	by Cooz	4	479
Tables in Excel Spreadsheets Jamesn Waters	by Jamesn Waters	2	394
Calculating quarterly investment returns---XIRR or another function?? Carl LaFong	by joeu2004	13	2,620
Making Cells Mandatory and Running Checks Bob Effendi	by Bob Effendi[_2_]	3	1,255
View Values Formula is using? Richhall[_2_]	by Richhall[_2_]	9	432
Count Products Jen[_6_]	by Fred Smith[_4_]	1	612
Identify the row with specific criteria Billy L[_2_]	by CLR	5	473
format a cell Ray	by Gord Dibben	2	423