Excel Worksheet Functions - Page 613

Thread / Thread Starter	Last Post	Replies	Views
replacing text within a formula jimswinder	by Roger Govier	5	505
detecting duplicate input in a cell leo	by Roger Govier	1	374
why a excel file,one sheet only, take 23 Mb ? MCortes	by Joerg	1	935
detecting duplicate input in a cell leo	by leo	0	337
detecting duplicate input in a cell leo	by leo	0	386
Show Null As %0 Ardy	by Ardy	6	459
Check dates in spreadsheet against expiry years column and change colour [email protected]	by trasha	4	634
How to return 1 with #VALUE!? Eric	by Eric	4	426
Buttons rio	by Corey	1	411
Count unique if text Mike Fogleman	by Epinn	16	1,230
description of countif criteria? Jakobshavn Isbrae	by Jakobshavn Isbrae	8	542
Cut and paste options [email protected]	by Roger Govier	1	413
What is the problem with this formula? Teethless mama	by [email protected]	1	417
Same dates in Sheet1 put as one date in Sheet2 inta251 via OfficeKB.com	by inta251 via OfficeKB.com	6	542
How do I add up time and minutes in a spreadsheet? Todd B.	by Lynne	3	2,803
formula that works in a different workbook Jude Reason	by Teethless mama	5	543
Does anyone see this .xls]sheetname? Eric	by Dave Peterson	2	582
MACRO AND MULTIPLE WORKSHEETS Mel	by Richard Buttrey	8	1,018
LOOKUP and #N/A Error Poody	by Poody	1	515
How do I highlight data differences in workbook tweacle	by bridgesmj	4	654
apply different prices to different quantities (variable pricing?) Raymond Ray	by Roger Govier	3	970
Automatic Quote Number Creator Nitza	by paul	4	1,077
Vlookup on partially sorthed lists Sean	by Sean	3	373
Return Unique Duplicate Numeric Values across Single Row Sam via OfficeKB.com	by T. Valko	7	909
Cells Slide Under Fred Atkinson	by T. Valko	3	2,342
Formula problems Lago2004	by Gord Dibben	7	883
Pivot Table - Problems when using Calculated Item sg	by Debra Dalgleish	1	511
Can I compute the eigenvectors of a matrix in excel? risotto	by risotto	0	1,654
COUNTIF cannot count decimal number occurences Ignorasmus	by Dave Peterson	2	2,178
How does one make data in a cell blink Vern	by Vern	0	772
Need formula to add a set amount to a balance on a specific date Sam	by Don Guillett	1	556
Labor costs for estimates CIL	by Roger Govier	5	659
use a worksheet as a form to collect data Paul Kinnear	by Dave Peterson	4	2,481
Find max Row() number for a value in column Vlado Sveda	by Teethless mama	12	1,797
Rows not formatting all the way down Angie	by Don Guillett	3	589
SUMPRODUCT returns 0, when I know it shouldn't Tim Bridle	by VBANoob	5	846
Function to detect type of cell contents Mark	by Bernard Liengme	3	460
need help with a formula Rhonda Edwards	by Pete_UK	18	1,423
Most recent price per item KatV	by KatV	0	557
Need Help about vlook vlook fomula	by Pete_UK	1	398
NA Pete_UK	by Pete_UK	0	364
conditional Formatting based on cell formatting Totom	by VBANoob	3	2,240
How do I hide a divide by zero error from an average formula? Julia	by daddylonglegs	2	5,694
how do I paste range name list? Adesso	by Mike	2	1,752
Converting a formula to a date tom	by FSt1	2	327
Find the top Scores per School Max	by Max	0	458
NA T. Valko	by T. Valko	0	338
NA Chip Pearson	by Chip Pearson	0	299
Array formula for unique values Dan Hatola	by T. Valko	1	533
How to return to a cell after sorting a spreadsheet. Givvie	by Chip Pearson	1	549
Complex Look Up Problem CJLuke	by T. Valko	5	475
Array formula for unique values Dan Hatola	by Dan Hatola	0	619
another array question Robert Dieckmann	by Epinn	5	502
Get Macro warning, but can't find Macro Stilla	by Stilla	1	819
saving filters CLR	by CLR	0	337
Excel Function - Please help Neil Hindry	by daddylonglegs	6	448
[=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2') Lawrence C H Tan	by Lawrence C H Tan	0	1,665
counting check boxes mini MP	by mini MP	0	892
My SUM function is totalling to 0 Caroline	by Caroline	0	579
LOOKUP with 2 or more criteria Tomas	by Mike	1	433
replace results from list with corresponding list Sean McDonald	by Sean McDonald	0	544
coloured fonts in cells tom	by tom	0	510
Conditional formatting date ranges arkmpr	by arkmpr	1	807
counting check boxes mini MP	by mini MP	0	405
remove links when pasteing formulas from one workbook to anoth Roger	by Roger	1	1,272
Calling cell values from random sheets from a base sheet [email protected]	by Gary Brown	2	542
adding data to existing data cell Curious	by Teethless mama	2	595
Data Validation Problem Mark S	by Mark S	0	408
My SUM function is totalling to 0 tom	by daddylonglegs	1	1,128
columns like in word jenn	by Dave F	1	353
= in cell does not upadate Karlos	by Karlos	0	452
Dynamic Rolling Average Lancer940	by Lancer940	5	1,349
Conditional IF statements sike11 via OfficeKB.com	by Mike	9	751
LOOKUP and #N/A Error Mike	by Poody	1	665
hiding zero values on all sheets & by default on new sheets WiFiMike2006	by vttanker	4	1,358