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	453
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	400
Creating a macro to line up data in 2 worksheets. [email protected]	by [email protected]	0	411
Creating a macro to line up data in 2 worksheets. [email protected]	by [email protected]	0	461
Creating a macro to line up data in 2 worksheets. [email protected]	by [email protected]	0	418
maybe it's simple with macro for this one? driller	by driller	6	426
DATEDIF() The hidden function - You may find it useful. Dave Thomas	by Ron Coderre	1	575
test expression for empty cell in =SUMIF() fgrose	by fgrose	12	1,320
Finding Non-Duplicates calibansfolly	by Peo Sjoblom	2	956
Combo Box & Cell Colors MP	by MP	0	459
CHAR funtcion with double letter columns ellebelle	by MartinW	7	4,121
Synchronized combo box in excel form [email protected]	by [email protected]	2	696
Array functions that I wan to update only on command Lii Hadin[_2_]	by Lii Hadin[_2_]	2	323
OFFSET Roger H[_2_]	by Arvi Laanemets	2	373
How do I calculate a persn's age in years & months in Excel? Lmurraz	by Lmurraz	4	575
Dynamic List kevin	by bj	1	410
converting date to text TB	by Toppers	1	495
Excel Newbie...How To Re-Order Data Martin[_3_]	by Martin[_3_]	5	446
'name of spreadsheet' function... please help TB	by Bob Phillips	2	391
Excel Database function rosie36	by Bob Phillips	4	673
Break even points Paul Bond	by Toppers	3	405
Excel 2007: request for help newscientist	by newscientist	0	382
=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	418
Excel 2003 - setting the Comment font size default rickz	by NickHK	3	2,516
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	409
Referencing between two Excel Workbook Objects Stephen Schroeder	by Stephen Schroeder	0	474
#N/A value is returned Sai	by Dave Thomas	7	657
#div/0 errors and blank cells dinouk	by T. Valko	7	683
formulat to convert base 32 to decimal? TMG005	by D Hilberg	5	5,414
# of days in month dipsy	by T. Valko	8	545
Condition depending on tab colour excel	by Bob Phillips	3	376
Extracting Data back and forth between Sheets Paul	by Paul	3	548
sum cells based on criteria in first set of cells summernight	by summernight	3	1,555
Merging Workbooks ANI	by ANI	0	377
SUM(ADDRESS(ROW(C2),COLUMN(C2),1,TRUE):ADDRESS(C14 +1,COLUMN(C2),1, Khoshravan	by T. Valko	5	1,621
Next number function excel	by Pete_UK	2	553
Procedure to change Column heading from R1C1 to A1? wmidlik	by Khoshravan	2	1,048
Matching a value, which does not exceed Min or Max. Assad	by Bob Phillips	3	914
Sound File Johno	by Johno	6	337
How can I compare and filter data in 2 spreadsheets director59	by director59	2	487
Excel database function rosie36	by Debra Dalgleish	9	586
how to use MS Excel 5.0 Dialog Damain	by Dave Peterson	1	4,235
automatically format cell based on content of another cell Blustreaker	by Blustreaker	2	1,188
how do I generate lists in worksheets based on a master list works Furlong	by Max	10	1,367
copy cell based on date Dreamstar_1961	by Rick Rothstein \(MVP - VB\)	4	409
Creating a Work place time sheet. Dags	by Rick Rothstein \(MVP - VB\)	1	514
Countif Larry Smith	by Rick Rothstein \(MVP - VB\)	14	915
Update Formula's based on drop down list value Steven Taylor	by Steven Taylor	3	2,338
Help - VBA Password Lost Sanjeev Unnikrishnan	by Stan Brown	6	499
how to sort a column of Randomly selected numbers? Khoshravan	by Khoshravan	8	648
Can I have a formula with inputs from multiple pages? Dan	by Khoshravan	4	509
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	545
Networkdays function jeanmac	by aehan	3	450
Updating a range automatecally Ninko	by Ninko	8	427
How many Standard Deviations above and below the mean each number is. [email protected]	by [email protected]	4	5,182
Hyperlinks and Email Addresses in Excel Robert	by Stan Brown	2	1,113
EXCEL Worksheet Rosie Bouquin	by Rick Rothstein \(MVP - VB\)	2	607
Macro that Fills Sequential numbers David A.	by JE McGimpsey	3	572
Looking for a template or help with a template using sheets. Red Guardian	by OssieMac	1	339
Auto-tab E. Hixson	by Peo Sjoblom	1	305
= or Arlene	by Pete_UK	2	373
Conditional Formating in Excel 2007 peter	by peter	0	554
Blank and 0's in Cells Klee	by JMB	5	411