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	455
What may cause macro modules to be created by accident? herrdue	by herrdue	2	424
last non-blank cell definition for plain excel user... driller	by driller	0	1,115
Creating a macro to line up data in 2 worksheets. [email protected]	by [email protected]	0	404
Creating a macro to line up data in 2 worksheets. [email protected]	by [email protected]	0	413
Creating a macro to line up data in 2 worksheets. [email protected]	by [email protected]	0	463
Creating a macro to line up data in 2 worksheets. [email protected]	by [email protected]	0	421
maybe it's simple with macro for this one? driller	by driller	6	429
DATEDIF() The hidden function - You may find it useful. Dave Thomas	by Ron Coderre	1	576
test expression for empty cell in =SUMIF() fgrose	by fgrose	12	1,320
Finding Non-Duplicates calibansfolly	by Peo Sjoblom	2	960
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	699
Array functions that I wan to update only on command Lii Hadin[_2_]	by Lii Hadin[_2_]	2	324
OFFSET Roger H[_2_]	by Arvi Laanemets	2	374
How do I calculate a persn's age in years & months in Excel? Lmurraz	by Lmurraz	4	577
Dynamic List kevin	by bj	1	413
converting date to text TB	by Toppers	1	496
Excel Newbie...How To Re-Order Data Martin[_3_]	by Martin[_3_]	5	451
'name of spreadsheet' function... please help TB	by Bob Phillips	2	395
Excel Database function rosie36	by Bob Phillips	4	675
Break even points Paul Bond	by Toppers	3	406
Excel 2007: request for help newscientist	by newscientist	0	385
=WEEKNUM function Roger H	by Stefi	2	498
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	381
Forms with conditions & mandatory selections Bec[_3_]	by Bec[_3_]	0	419
Excel 2003 - setting the Comment font size default rickz	by NickHK	3	2,522
Find last cell in column then SUM in cell directly below Giggly4g	by Mike	11	2,588
Make it Simple! Dan the Man[_2_]	by Dave Thomas	8	410
Referencing between two Excel Workbook Objects Stephen Schroeder	by Stephen Schroeder	0	477
#N/A value is returned Sai	by Dave Thomas	7	661
#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,478
# of days in month dipsy	by T. Valko	8	602
Condition depending on tab colour excel	by Bob Phillips	3	378
Extracting Data back and forth between Sheets Paul	by Paul	3	549
sum cells based on criteria in first set of cells summernight	by summernight	3	1,556
Merging Workbooks ANI	by ANI	0	379
SUM(ADDRESS(ROW(C2),COLUMN(C2),1,TRUE):ADDRESS(C14 +1,COLUMN(C2),1, Khoshravan	by T. Valko	5	1,623
Next number function excel	by Pete_UK	2	554
Procedure to change Column heading from R1C1 to A1? wmidlik	by Khoshravan	2	1,083
Matching a value, which does not exceed Min or Max. Assad	by Bob Phillips	3	914
Sound File Johno	by Johno	6	338
How can I compare and filter data in 2 spreadsheets director59	by director59	2	487
Excel database function rosie36	by Debra Dalgleish	9	590
how to use MS Excel 5.0 Dialog Damain	by Dave Peterson	1	4,236
automatically format cell based on content of another cell Blustreaker	by Blustreaker	2	1,190
how do I generate lists in worksheets based on a master list works Furlong	by Max	10	1,369
copy cell based on date Dreamstar_1961	by Rick Rothstein \(MVP - VB\)	4	413
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,342
Help - VBA Password Lost Sanjeev Unnikrishnan	by Stan Brown	6	501
how to sort a column of Randomly selected numbers? Khoshravan	by Khoshravan	8	650
Can I have a formula with inputs from multiple pages? Dan	by Khoshravan	4	511
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	596
Easy Question Bob[_8_]	by Gord Dibben	9	549
Networkdays function jeanmac	by aehan	3	451
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,190
Hyperlinks and Email Addresses in Excel Robert	by Stan Brown	2	1,114
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	305
= or Arlene	by Pete_UK	2	375
Conditional Formating in Excel 2007 peter	by peter	0	565
Blank and 0's in Cells Klee	by JMB	5	412