Excel Worksheet Functions - Page 518

Thread / Thread Starter	Last Post	Replies	Views
If then formula Libby	by bj	11	773
A formula to look for a value in a blok (eg E1:J10) data Dolflaas	by Dave Thomas	2	425
changing text values to a different string sparks	by Pete_UK	4	466
What may cause macro modules to be created by accident? herrdue	by herrdue	2	425
last non-blank cell definition for plain excel user... driller	by driller	0	1,122
Creating a macro to line up data in 2 worksheets. [email protected]	by [email protected]	0	415
Creating a macro to line up data in 2 worksheets. [email protected]	by [email protected]	0	423
Creating a macro to line up data in 2 worksheets. [email protected]	by [email protected]	0	471
Creating a macro to line up data in 2 worksheets. [email protected]	by [email protected]	0	429
maybe it's simple with macro for this one? driller	by driller	6	431
DATEDIF() The hidden function - You may find it useful. Dave Thomas	by Ron Coderre	1	583
test expression for empty cell in =SUMIF() fgrose	by fgrose	12	1,330
Finding Non-Duplicates calibansfolly	by Peo Sjoblom	2	961
Combo Box & Cell Colors MP	by MP	0	460
CHAR funtcion with double letter columns ellebelle	by MartinW	7	4,126
Synchronized combo box in excel form [email protected]	by [email protected]	2	707
Array functions that I wan to update only on command Lii Hadin[_2_]	by Lii Hadin[_2_]	2	334
OFFSET Roger H[_2_]	by Arvi Laanemets	2	380
How do I calculate a persn's age in years & months in Excel? Lmurraz	by Lmurraz	4	578
Dynamic List kevin	by bj	1	413
converting date to text TB	by Toppers	1	507
Excel Newbie...How To Re-Order Data Martin[_3_]	by Martin[_3_]	5	458
'name of spreadsheet' function... please help TB	by Bob Phillips	2	398
Excel Database function rosie36	by Bob Phillips	4	677
Break even points Paul Bond	by Toppers	3	416
Excel 2007: request for help newscientist	by newscientist	0	397
=WEEKNUM function Roger H	by Stefi	2	508
Filter Totals in a Pivot table? Matt D Francis	by Matt D Francis	2	1,402
very green at this formula stuff? [email protected]	by Toppers	1	373
Currency format Max	by Max	8	386
Forms with conditions & mandatory selections Bec[_3_]	by Bec[_3_]	0	428
Excel 2003 - setting the Comment font size default rickz	by NickHK	3	2,523
Find last cell in column then SUM in cell directly below Giggly4g	by Mike	11	2,598
Make it Simple! Dan the Man[_2_]	by Dave Thomas	8	420
Referencing between two Excel Workbook Objects Stephen Schroeder	by Stephen Schroeder	0	488
#N/A value is returned Sai	by Dave Thomas	7	670
#div/0 errors and blank cells dinouk	by T. Valko	7	734
formulat to convert base 32 to decimal? TMG005	by D Hilberg	5	5,488
# of days in month dipsy	by T. Valko	8	602
Condition depending on tab colour excel	by Bob Phillips	3	390
Extracting Data back and forth between Sheets Paul	by Paul	3	556
sum cells based on criteria in first set of cells summernight	by summernight	3	1,556
Merging Workbooks ANI	by ANI	0	387
SUM(ADDRESS(ROW(C2),COLUMN(C2),1,TRUE):ADDRESS(C14 +1,COLUMN(C2),1, Khoshravan	by T. Valko	5	1,624
Next number function excel	by Pete_UK	2	564
Procedure to change Column heading from R1C1 to A1? wmidlik	by Khoshravan	2	1,095
Matching a value, which does not exceed Min or Max. Assad	by Bob Phillips	3	922
Sound File Johno	by Johno	6	344
How can I compare and filter data in 2 spreadsheets director59	by director59	2	490
Excel database function rosie36	by Debra Dalgleish	9	590
how to use MS Excel 5.0 Dialog Damain	by Dave Peterson	1	4,243
automatically format cell based on content of another cell Blustreaker	by Blustreaker	2	1,201
how do I generate lists in worksheets based on a master list works Furlong	by Max	10	1,380
copy cell based on date Dreamstar_1961	by Rick Rothstein \(MVP - VB\)	4	420
Creating a Work place time sheet. Dags	by Rick Rothstein \(MVP - VB\)	1	514
Countif Larry Smith	by Rick Rothstein \(MVP - VB\)	14	916
Update Formula's based on drop down list value Steven Taylor	by Steven Taylor	3	2,353
Help - VBA Password Lost Sanjeev Unnikrishnan	by Stan Brown	6	509
how to sort a column of Randomly selected numbers? Khoshravan	by Khoshravan	8	659
Can I have a formula with inputs from multiple pages? Dan	by Khoshravan	4	518
Vlookup paulofqpr	by ShaneDevenshire	5	386
Sum many unconnected cells Pam M	by Toppers	5	1,088
auto save feature in excel Digvijay Kamal	by Gord Dibben	1	606
Easy Question Bob[_8_]	by Gord Dibben	9	557
Networkdays function jeanmac	by aehan	3	458
Updating a range automatecally Ninko	by Ninko	8	434
How many Standard Deviations above and below the mean each number is. [email protected]	by [email protected]	4	5,200
Hyperlinks and Email Addresses in Excel Robert	by Stan Brown	2	1,124
EXCEL Worksheet Rosie Bouquin	by Rick Rothstein \(MVP - VB\)	2	609
Macro that Fills Sequential numbers David A.	by JE McGimpsey	3	573
Looking for a template or help with a template using sheets. Red Guardian	by OssieMac	1	340
Auto-tab E. Hixson	by Peo Sjoblom	1	306
= or Arlene	by Pete_UK	2	375
Conditional Formating in Excel 2007 peter	by peter	0	566
Blank and 0's in Cells Klee	by JMB	5	412