Excel Worksheet Functions - Page 613

Thread / Thread Starter	Last Post	Replies	Views
replacing text within a formula jimswinder	by Roger Govier	5	520
detecting duplicate input in a cell leo	by Roger Govier	1	387
why a excel file,one sheet only, take 23 Mb ? MCortes	by Joerg	1	936
detecting duplicate input in a cell leo	by leo	0	347
detecting duplicate input in a cell leo	by leo	0	398
Show Null As %0 Ardy	by Ardy	6	470
Check dates in spreadsheet against expiry years column and change colour [email protected]	by trasha	4	639
How to return 1 with #VALUE!? Eric	by Eric	4	440
Buttons rio	by Corey	1	411
Count unique if text Mike Fogleman	by Epinn	16	1,246
description of countif criteria? Jakobshavn Isbrae	by Jakobshavn Isbrae	8	543
Cut and paste options [email protected]	by Roger Govier	1	417
What is the problem with this formula? Teethless mama	by [email protected]	1	423
Same dates in Sheet1 put as one date in Sheet2 inta251 via OfficeKB.com	by inta251 via OfficeKB.com	6	555
How do I add up time and minutes in a spreadsheet? Todd B.	by Lynne	3	2,814
formula that works in a different workbook Jude Reason	by Teethless mama	5	545
Does anyone see this .xls]sheetname? Eric	by Dave Peterson	2	584
MACRO AND MULTIPLE WORKSHEETS Mel	by Richard Buttrey	8	1,020
LOOKUP and #N/A Error Poody	by Poody	1	517
How do I highlight data differences in workbook tweacle	by bridgesmj	4	664
apply different prices to different quantities (variable pricing?) Raymond Ray	by Roger Govier	3	984
Automatic Quote Number Creator Nitza	by paul	4	1,080
Vlookup on partially sorthed lists Sean	by Sean	3	385
Return Unique Duplicate Numeric Values across Single Row Sam via OfficeKB.com	by T. Valko	7	923
Cells Slide Under Fred Atkinson	by T. Valko	3	2,343
Formula problems Lago2004	by Gord Dibben	7	884
Pivot Table - Problems when using Calculated Item sg	by Debra Dalgleish	1	518
Can I compute the eigenvectors of a matrix in excel? risotto	by risotto	0	1,661
COUNTIF cannot count decimal number occurences Ignorasmus	by Dave Peterson	2	2,189
How does one make data in a cell blink Vern	by Vern	0	783
Need formula to add a set amount to a balance on a specific date Sam	by Don Guillett	1	567
Labor costs for estimates CIL	by Roger Govier	5	661
use a worksheet as a form to collect data Paul Kinnear	by Dave Peterson	4	2,486
Find max Row() number for a value in column Vlado Sveda	by Teethless mama	12	1,808
Rows not formatting all the way down Angie	by Don Guillett	3	604
SUMPRODUCT returns 0, when I know it shouldn't Tim Bridle	by VBANoob	5	850
Function to detect type of cell contents Mark	by Bernard Liengme	3	474
need help with a formula Rhonda Edwards	by Pete_UK	18	1,423
Most recent price per item KatV	by KatV	0	558
Need Help about vlook vlook fomula	by Pete_UK	1	404
NA Pete_UK	by Pete_UK	0	365
conditional Formatting based on cell formatting Totom	by VBANoob	3	2,248
How do I hide a divide by zero error from an average formula? Julia	by daddylonglegs	2	5,706
how do I paste range name list? Adesso	by Mike	2	1,760
Converting a formula to a date tom	by FSt1	2	340
Find the top Scores per School Max	by Max	0	460
NA T. Valko	by T. Valko	0	339
NA Chip Pearson	by Chip Pearson	0	300
Array formula for unique values Dan Hatola	by T. Valko	1	543
How to return to a cell after sorting a spreadsheet. Givvie	by Chip Pearson	1	564
Complex Look Up Problem CJLuke	by T. Valko	5	486
Array formula for unique values Dan Hatola	by Dan Hatola	0	631
another array question Robert Dieckmann	by Epinn	5	516
Get Macro warning, but can't find Macro Stilla	by Stilla	1	833
saving filters CLR	by CLR	0	348
Excel Function - Please help Neil Hindry	by daddylonglegs	6	461
[=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2') Lawrence C H Tan	by Lawrence C H Tan	0	1,669
counting check boxes mini MP	by mini MP	0	904
My SUM function is totalling to 0 Caroline	by Caroline	0	587
LOOKUP with 2 or more criteria Tomas	by Mike	1	434
replace results from list with corresponding list Sean McDonald	by Sean McDonald	0	553
coloured fonts in cells tom	by tom	0	511
Conditional formatting date ranges arkmpr	by arkmpr	1	819
counting check boxes mini MP	by mini MP	0	406
remove links when pasteing formulas from one workbook to anoth Roger	by Roger	1	1,280
Calling cell values from random sheets from a base sheet [email protected]	by Gary Brown	2	553
adding data to existing data cell Curious	by Teethless mama	2	611
Data Validation Problem Mark S	by Mark S	0	416
My SUM function is totalling to 0 tom	by daddylonglegs	1	1,141
columns like in word jenn	by Dave F	1	366
= in cell does not upadate Karlos	by Karlos	0	453
Dynamic Rolling Average Lancer940	by Lancer940	5	1,349
Conditional IF statements sike11 via OfficeKB.com	by Mike	9	752
LOOKUP and #N/A Error Mike	by Poody	1	666
hiding zero values on all sheets & by default on new sheets WiFiMike2006	by vttanker	4	1,370