Excel Worksheet Functions - Page 433

Thread / Thread Starter	Last Post	Replies	Views
IF, AND, OR Function Pete_UK	by Pete_UK	0	357
auto-complete from a drop down list and from a different workbook [email protected]	by Gord Dibben	1	535
can windows vista edit shared document from windows xp sasa	by Gord Dibben	1	817
Using the CountIf function with multiple criteria? Jonathan	by Bob Phillips	11	1,124
Countif text in individual cells q3pd	by David Biddulph[_2_]	5	729
Automatically update spreadsheet from another spreadsheet Cindy	by Cindy	3	3,142
Opening an .mdb file in Excel lehigh46	by ryguy7272	2	3,084
IF, AND, OR Function talltom	by talltom	3	433
Days between dates including start day and weekends JessP27	by Pete_UK	7	1,172
Creating running clocks in multiple cells. MikeG	by CLR	9	534
filter dates by quarter Larry	by Larry	4	1,769
Stop excel rounding my 16/17 digit numbers E Halliday	by Pete_UK	2	2,698
Hyperlink to Named Range Based On Cell Contents TKS_Mark	by Dave Peterson	1	1,070
copy many sheets into one Annie_Ioceva	by Ron de Bruin	1	446
Calling AutoFit using macro in XLCALL.h [email protected]	by Dave Peterson	1	468
Dave Peterson Bob Myers	by Dave Peterson	2	468
What is the NNTP for this newsgroup? ExcelMonkey	by Dave Peterson	4	428
Extract everything to the right in cell when a number is encounter Matt	by Ron Rosenfeld	4	981
Copy Unique Entries TimJames	by TimJames	0	366
editing a query Texas Tonie[_2_]	by Texas Tonie[_2_]	4	439
calculating and coloring [email protected]	by Mike H	1	361
YEAR and IF PAL	by Pete_UK	2	363
link data to worksheets john	by john	6	537
Working with worksheets james	by David Biddulph[_2_]	7	535
#VALUE & #DIV0 tonyalt3	by tonyalt3	2	625
VBA to reattempt to open if file is read only Jive	by Jive	4	4,978
Formula displayd as text ??? Jock	by Jock	2	306
MAX formula? jane	by CLR	4	450
Equate numbers to text hpum	by Gary''s Student	1	404
Created IF functions - Need sum of results TMH0522	by Arvi Laanemets	4	568
If statement when two cells are the same q3pd	by q3pd	2	1,225
Function for visible cells only [email protected]	by Roger Govier[_3_]	1	389
vlookup on first occurrence of X after Y? jim	by Dave Peterson	3	865
IF, Then Uyen-Uyen	by Don Guillett	6	427
copying data to different worksheets in the same workbook Veronica Johnson	by Gord Dibben	1	627
Excel Formula Question pantherguy	by Roger Govier[_3_]	3	322
Running Sum question LisaK	by Roger Govier[_3_]	5	471
Figuring Late Payment on Mortgage Bzzygrl	by joeu2004	3	1,015
Opening a file stops a Macro Bob Myers	by Dave Peterson	2	1,273
DSUM Jed	by Jed	0	400
RANK without a tie jane	by jane	3	1,433
Index Function Carrie	by T. Valko	1	474
Excel 2003 C	by Max	1	331
Subtotal function not available Graeme	by jenn	3	1,758
Hyperlink Rooky228	by Rooky228	4	318
formula for counting the occurence of more than one condition Dr Carl	by T. Valko	2	496
Count all €œZ€ in a Range ryguy7272	by T. Valko	4	1,647
Column List to Multiple Columns TStirling	by Pete_UK	5	582
General Ledger Template Cyndi	by ryguy7272	1	2,055
How do I Hi- lite the max of last 20 entries Joe Goz	by Rick Rothstein \(MVP - VB\)	5	569
Extracting data from hyperlinked spreadsheets akfrumtarn	by ryguy7272	3	660
Merge problem Bird Byte	by Jim Cone	5	384
Some text won't print from my worksheet Carolyn	by Richard O. Neville	1	713
Where are the add-ins Sandy	by Tyro[_2_]	2	380
How do I change a file displayed in thousands to millions? DW	by CLR	3	2,732
ODBC AfterRefresh Event and Shared Workbook Paul	by Paul	0	545
Using INDEX and it Returns a #N/A Crazyhorse	by Pete_UK	2	523
Lock cell formats (conditional format) Saintsman	by ryguy7272	1	629
Pivot Table Source ryguy7272	by Ron Coderre	3	423
Percentage function Rachel Bixby	by Tyro[_2_]	6	533
Excel 2007 Vlookup Using New Table Syntax [email protected]	by [email protected]	2	1,356
First working day of the month Hedgie	by Ron Coderre	2	943
Macro to change time format.... neilcarden	by Bernie Deitrick	1	931
Can function be applied to range in sumif prior to criteria check? Cheese_whiz	by Cheese_whiz	4	370
Copying Worksheets Neil169	by ryguy7272	1	566
Auto Capital Letter in a cell Montu	by Bernie Deitrick	3	1,907
Obtain row number of active cell Jive	by papou[_4_]	4	784
SUMIF < Cooz	by Cooz	4	457
Tables in Excel Spreadsheets Jamesn Waters	by Jamesn Waters	2	376
Calculating quarterly investment returns---XIRR or another function?? Carl LaFong	by joeu2004	13	2,488
Making Cells Mandatory and Running Checks Bob Effendi	by Bob Effendi[_2_]	3	1,217
View Values Formula is using? Richhall[_2_]	by Richhall[_2_]	9	410
Count Products Jen[_6_]	by Fred Smith[_4_]	1	581
Identify the row with specific criteria Billy L[_2_]	by CLR	5	453
format a cell Ray	by Gord Dibben	2	397