Excel Worksheet Functions - Page 666

Thread / Thread Starter	Last Post	Replies	Views
Excel database function rosie36	by Debra Dalgleish	9	574
How can I compare and filter data in 2 spreadsheets director59	by director59	2	470
Sound File Johno	by Johno	6	327
Matching a value, which does not exceed Min or Max. Assad	by Bob Phillips	3	902
Procedure to change Column heading from R1C1 to A1? wmidlik	by Khoshravan	2	1,024
Next number function excel	by Pete_UK	2	540
SUM(ADDRESS(ROW(C2),COLUMN(C2),1,TRUE):ADDRESS(C14 +1,COLUMN(C2),1, Khoshravan	by T. Valko	5	1,605
Merging Workbooks ANI	by ANI	0	366
sum cells based on criteria in first set of cells summernight	by summernight	3	1,548
Extracting Data back and forth between Sheets Paul	by Paul	3	511
Condition depending on tab colour excel	by Bob Phillips	3	359
# of days in month dipsy	by T. Valko	8	519
formulat to convert base 32 to decimal? TMG005	by D Hilberg	5	5,345
#div/0 errors and blank cells dinouk	by T. Valko	7	670
#N/A value is returned Sai	by Dave Thomas	7	641
Referencing between two Excel Workbook Objects Stephen Schroeder	by Stephen Schroeder	0	460
Make it Simple! Dan the Man[_2_]	by Dave Thomas	8	402
Find last cell in column then SUM in cell directly below Giggly4g	by Mike	11	2,574
Excel 2003 - setting the Comment font size default rickz	by NickHK	3	2,498
Forms with conditions & mandatory selections Bec[_3_]	by Bec[_3_]	0	409
Currency format Max	by Max	8	371
very green at this formula stuff? [email protected]	by Toppers	1	363
Filter Totals in a Pivot table? Matt D Francis	by Matt D Francis	2	1,393
=WEEKNUM function Roger H	by Stefi	2	484
Excel 2007: request for help newscientist	by newscientist	0	366
Break even points Paul Bond	by Toppers	3	393
Excel Database function rosie36	by Bob Phillips	4	662
'name of spreadsheet' function... please help TB	by Bob Phillips	2	376
Excel Newbie...How To Re-Order Data Martin[_3_]	by Martin[_3_]	5	436
converting date to text TB	by Toppers	1	484
Dynamic List kevin	by bj	1	399
How do I calculate a persn's age in years & months in Excel? Lmurraz	by Lmurraz	4	564
OFFSET Roger H[_2_]	by Arvi Laanemets	2	366
Array functions that I wan to update only on command Lii Hadin[_2_]	by Lii Hadin[_2_]	2	316
Synchronized combo box in excel form [email protected]	by [email protected]	2	688
CHAR funtcion with double letter columns ellebelle	by MartinW	7	4,066
Combo Box & Cell Colors MP	by MP	0	452
Finding Non-Duplicates calibansfolly	by Peo Sjoblom	2	946
test expression for empty cell in =SUMIF() fgrose	by fgrose	12	1,304
DATEDIF() The hidden function - You may find it useful. Dave Thomas	by Ron Coderre	1	566
maybe it's simple with macro for this one? driller	by driller	6	417
Creating a macro to line up data in 2 worksheets. [email protected]	by [email protected]	0	405
Creating a macro to line up data in 2 worksheets. [email protected]	by [email protected]	0	450
Creating a macro to line up data in 2 worksheets. [email protected]	by [email protected]	0	401
Creating a macro to line up data in 2 worksheets. [email protected]	by [email protected]	0	380
last non-blank cell definition for plain excel user... driller	by driller	0	1,102
What may cause macro modules to be created by accident? herrdue	by herrdue	2	406
changing text values to a different string sparks	by Pete_UK	4	441
A formula to look for a value in a blok (eg E1:J10) data Dolflaas	by Dave Thomas	2	411
If then formula Libby	by bj	11	762
SUMIF Value error Margie	by bj	12	1,365
Correction to previous post Dave Thomas	by Dave Thomas	0	407
Problem with SUMPRODUCT....help please! Tasha	by Tasha	5	465
formula to track timeframe by automatically highlighting cells maijiuli	by maijiuli	6	504
IF FORMULAS NEEDED Kerri Olsen	by Dave Thomas	4	451
Using a dynamic pathname in VLOOKUP Mike D[_2_]	by T. Valko	7	1,372
sumif functions based on multiple data Lori	by Dave Peterson	2	381
Conditional Statement lbraddock	by lbraddock	0	423
How to set the value of a filter field in a Pivot Table? Iglesias	by Iglesias	0	485
Formula with color fill? Positive	by T. Valko	12	849
Excel 2007 - table style default fneiling	by Debra Dalgleish	5	2,666
Test for outline level of cell fgrose	by Vasant Nanavati	3	1,123
Problems with the Right & Find functions beginner here	by T. Valko	14	1,225
average in excle [email protected]	by Dave Thomas	10	867
How to automate datasheet stuffing? Karl	by Billy Liddel	1	460
I'm looking to add cells (that are formated in %) in them. j5b9721	by JMB	5	487
How to display empty text boxes abad351	by Max StenbÃ¤ck	2	395
selecting a row srikanth	by srikanth	6	546
"list unique" instructions fr xldynamic site doent work Khoshravan	by Max	4	483
offset and Sum function yshridhar	by yshridhar	8	897
what is reversed conditional formatting? swati	by swati	4	505
Data Validation Pricklyflower	by Pricklyflower	2	411
How do I press TAB and get Excel to move through certain grid ref Stephen	by MartinW	1	378
advance level of sorting data? by Ting Ting Li	by NickHK	1	434
Change :47:57 to 0:47:57 jeannie v	by jeannie v	2	346