Excel Worksheet Functions - Page 613

Thread / Thread Starter	Last Post	Replies	Views
replacing text within a formula jimswinder	by Roger Govier	5	499
detecting duplicate input in a cell leo	by Roger Govier	1	373
why a excel file,one sheet only, take 23 Mb ? MCortes	by Joerg	1	934
detecting duplicate input in a cell leo	by leo	0	336
detecting duplicate input in a cell leo	by leo	0	385
Show Null As %0 Ardy	by Ardy	6	458
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	425
Buttons rio	by Corey	1	406
Count unique if text Mike Fogleman	by Epinn	16	1,227
description of countif criteria? Jakobshavn Isbrae	by Jakobshavn Isbrae	8	540
Cut and paste options [email protected]	by Roger Govier	1	410
What is the problem with this formula? Teethless mama	by [email protected]	1	414
Same dates in Sheet1 put as one date in Sheet2 inta251 via OfficeKB.com	by inta251 via OfficeKB.com	6	541
How do I add up time and minutes in a spreadsheet? Todd B.	by Lynne	3	2,802
formula that works in a different workbook Jude Reason	by Teethless mama	5	542
Does anyone see this .xls]sheetname? Eric	by Dave Peterson	2	578
MACRO AND MULTIPLE WORKSHEETS Mel	by Richard Buttrey	8	991
LOOKUP and #N/A Error Poody	by Poody	1	514
How do I highlight data differences in workbook tweacle	by bridgesmj	4	653
apply different prices to different quantities (variable pricing?) Raymond Ray	by Roger Govier	3	968
Automatic Quote Number Creator Nitza	by paul	4	1,076
Vlookup on partially sorthed lists Sean	by Sean	3	372
Return Unique Duplicate Numeric Values across Single Row Sam via OfficeKB.com	by T. Valko	7	906
Cells Slide Under Fred Atkinson	by T. Valko	3	2,340
Formula problems Lago2004	by Gord Dibben	7	882
Pivot Table - Problems when using Calculated Item sg	by Debra Dalgleish	1	510
Can I compute the eigenvectors of a matrix in excel? risotto	by risotto	0	1,653
COUNTIF cannot count decimal number occurences Ignorasmus	by Dave Peterson	2	2,177
How does one make data in a cell blink Vern	by Vern	0	770
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	651
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,794
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	845
Function to detect type of cell contents Mark	by Bernard Liengme	3	458
need help with a formula Rhonda Edwards	by Pete_UK	18	1,422
Most recent price per item KatV	by KatV	0	555
Need Help about vlook vlook fomula	by Pete_UK	1	397
NA Pete_UK	by Pete_UK	0	361
conditional Formatting based on cell formatting Totom	by VBANoob	3	2,190
How do I hide a divide by zero error from an average formula? Julia	by daddylonglegs	2	5,690
how do I paste range name list? Adesso	by Mike	2	1,750
Converting a formula to a date tom	by FSt1	2	326
Find the top Scores per School Max	by Max	0	457
NA T. Valko	by T. Valko	0	337
NA Chip Pearson	by Chip Pearson	0	298
Array formula for unique values Dan Hatola	by T. Valko	1	532
How to return to a cell after sorting a spreadsheet. Givvie	by Chip Pearson	1	548
Complex Look Up Problem CJLuke	by T. Valko	5	474
Array formula for unique values Dan Hatola	by Dan Hatola	0	618
another array question Robert Dieckmann	by Epinn	5	499
Get Macro warning, but can't find Macro Stilla	by Stilla	1	817
saving filters CLR	by CLR	0	336
Excel Function - Please help Neil Hindry	by daddylonglegs	6	447
[=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2') Lawrence C H Tan	by Lawrence C H Tan	0	1,604
counting check boxes mini MP	by mini MP	0	891
My SUM function is totalling to 0 Caroline	by Caroline	0	576
LOOKUP with 2 or more criteria Tomas	by Mike	1	433
replace results from list with corresponding list Sean McDonald	by Sean McDonald	0	543
coloured fonts in cells tom	by tom	0	508
Conditional formatting date ranges arkmpr	by arkmpr	1	804
counting check boxes mini MP	by mini MP	0	404
remove links when pasteing formulas from one workbook to anoth Roger	by Roger	1	1,271
Calling cell values from random sheets from a base sheet [email protected]	by Gary Brown	2	541
adding data to existing data cell Curious	by Teethless mama	2	585
Data Validation Problem Mark S	by Mark S	0	407
My SUM function is totalling to 0 tom	by daddylonglegs	1	1,127
columns like in word jenn	by Dave F	1	351
= in cell does not upadate Karlos	by Karlos	0	449
Dynamic Rolling Average Lancer940	by Lancer940	5	1,348
Conditional IF statements sike11 via OfficeKB.com	by Mike	9	747
LOOKUP and #N/A Error Mike	by Poody	1	663
hiding zero values on all sheets & by default on new sheets WiFiMike2006	by vttanker	4	1,351