Excel Worksheet Functions - Page 518

Thread / Thread Starter	Last Post	Replies	Views
If then formula Libby	by bj	11	761
A formula to look for a value in a blok (eg E1:J10) data Dolflaas	by Dave Thomas	2	410
changing text values to a different string sparks	by Pete_UK	4	435
What may cause macro modules to be created by accident? herrdue	by herrdue	2	398
last non-blank cell definition for plain excel user... driller	by driller	0	1,098
Creating a macro to line up data in 2 worksheets. [email protected]	by [email protected]	0	379
Creating a macro to line up data in 2 worksheets. [email protected]	by [email protected]	0	400
Creating a macro to line up data in 2 worksheets. [email protected]	by [email protected]	0	446
Creating a macro to line up data in 2 worksheets. [email protected]	by [email protected]	0	403
maybe it's simple with macro for this one? driller	by driller	6	415
DATEDIF() The hidden function - You may find it useful. Dave Thomas	by Ron Coderre	1	564
test expression for empty cell in =SUMIF() fgrose	by fgrose	12	1,295
Finding Non-Duplicates calibansfolly	by Peo Sjoblom	2	945
Combo Box & Cell Colors MP	by MP	0	425
CHAR funtcion with double letter columns ellebelle	by MartinW	7	3,925
Synchronized combo box in excel form [email protected]	by [email protected]	2	660
Array functions that I wan to update only on command Lii Hadin[_2_]	by Lii Hadin[_2_]	2	310
OFFSET Roger H[_2_]	by Arvi Laanemets	2	362
How do I calculate a persn's age in years & months in Excel? Lmurraz	by Lmurraz	4	562
Dynamic List kevin	by bj	1	394
converting date to text TB	by Toppers	1	482
Excel Newbie...How To Re-Order Data Martin[_3_]	by Martin[_3_]	5	430
'name of spreadsheet' function... please help TB	by Bob Phillips	2	372
Excel Database function rosie36	by Bob Phillips	4	657
Break even points Paul Bond	by Toppers	3	392
Excel 2007: request for help newscientist	by newscientist	0	365
=WEEKNUM function Roger H	by Stefi	2	474
Filter Totals in a Pivot table? Matt D Francis	by Matt D Francis	2	1,393
very green at this formula stuff? [email protected]	by Toppers	1	362
Currency format Max	by Max	8	366
Forms with conditions & mandatory selections Bec[_3_]	by Bec[_3_]	0	403
Excel 2003 - setting the Comment font size default rickz	by NickHK	3	2,476
Find last cell in column then SUM in cell directly below Giggly4g	by Mike	11	2,573
Make it Simple! Dan the Man[_2_]	by Dave Thomas	8	397
Referencing between two Excel Workbook Objects Stephen Schroeder	by Stephen Schroeder	0	453
#N/A value is returned Sai	by Dave Thomas	7	641
#div/0 errors and blank cells dinouk	by T. Valko	7	664
formulat to convert base 32 to decimal? TMG005	by D Hilberg	5	5,337
# of days in month dipsy	by T. Valko	8	514
Condition depending on tab colour excel	by Bob Phillips	3	352
Extracting Data back and forth between Sheets Paul	by Paul	3	504
sum cells based on criteria in first set of cells summernight	by summernight	3	1,548
Merging Workbooks ANI	by ANI	0	360
SUM(ADDRESS(ROW(C2),COLUMN(C2),1,TRUE):ADDRESS(C14 +1,COLUMN(C2),1, Khoshravan	by T. Valko	5	1,594
Next number function excel	by Pete_UK	2	539
Procedure to change Column heading from R1C1 to A1? wmidlik	by Khoshravan	2	1,013
Matching a value, which does not exceed Min or Max. Assad	by Bob Phillips	3	896
Sound File Johno	by Johno	6	326
How can I compare and filter data in 2 spreadsheets director59	by director59	2	468
Excel database function rosie36	by Debra Dalgleish	9	574
how to use MS Excel 5.0 Dialog Damain	by Dave Peterson	1	4,204
automatically format cell based on content of another cell Blustreaker	by Blustreaker	2	1,164
how do I generate lists in worksheets based on a master list works Furlong	by Max	10	1,345
copy cell based on date Dreamstar_1961	by Rick Rothstein \(MVP - VB\)	4	359
Creating a Work place time sheet. Dags	by Rick Rothstein \(MVP - VB\)	1	495
Countif Larry Smith	by Rick Rothstein \(MVP - VB\)	14	901
Update Formula's based on drop down list value Steven Taylor	by Steven Taylor	3	2,326
Help - VBA Password Lost Sanjeev Unnikrishnan	by Stan Brown	6	478
how to sort a column of Randomly selected numbers? Khoshravan	by Khoshravan	8	623
Can I have a formula with inputs from multiple pages? Dan	by Khoshravan	4	496
Vlookup paulofqpr	by ShaneDevenshire	5	379
Sum many unconnected cells Pam M	by Toppers	5	1,076
auto save feature in excel Digvijay Kamal	by Gord Dibben	1	579
Easy Question Bob[_8_]	by Gord Dibben	9	521
Networkdays function jeanmac	by aehan	3	436
Updating a range automatecally Ninko	by Ninko	8	416
How many Standard Deviations above and below the mean each number is. [email protected]	by [email protected]	4	5,124
Hyperlinks and Email Addresses in Excel Robert	by Stan Brown	2	1,100
EXCEL Worksheet Rosie Bouquin	by Rick Rothstein \(MVP - VB\)	2	599
Macro that Fills Sequential numbers David A.	by JE McGimpsey	3	561
Looking for a template or help with a template using sheets. Red Guardian	by OssieMac	1	330
Auto-tab E. Hixson	by Peo Sjoblom	1	296
= or Arlene	by Pete_UK	2	361
Conditional Formating in Excel 2007 peter	by peter	0	539
Blank and 0's in Cells Klee	by JMB	5	401