Excel Worksheet Functions - Page 613

Thread / Thread Starter	Last Post	Replies	Views
replacing text within a formula jimswinder	by Roger Govier	5	478
detecting duplicate input in a cell leo	by Roger Govier	1	360
why a excel file,one sheet only, take 23 Mb ? MCortes	by Joerg	1	922
detecting duplicate input in a cell leo	by leo	0	323
detecting duplicate input in a cell leo	by leo	0	370
Show Null As %0 Ardy	by Ardy	6	446
Check dates in spreadsheet against expiry years column and change colour [email protected]	by trasha	4	611
How to return 1 with #VALUE!? Eric	by Eric	4	418
Buttons rio	by Corey	1	394
Count unique if text Mike Fogleman	by Epinn	16	1,194
description of countif criteria? Jakobshavn Isbrae	by Jakobshavn Isbrae	8	534
Cut and paste options [email protected]	by Roger Govier	1	362
What is the problem with this formula? Teethless mama	by [email protected]	1	387
Same dates in Sheet1 put as one date in Sheet2 inta251 via OfficeKB.com	by inta251 via OfficeKB.com	6	533
How do I add up time and minutes in a spreadsheet? Todd B.	by Lynne	3	2,791
formula that works in a different workbook Jude Reason	by Teethless mama	5	536
Does anyone see this .xls]sheetname? Eric	by Dave Peterson	2	555
MACRO AND MULTIPLE WORKSHEETS Mel	by Richard Buttrey	8	967
LOOKUP and #N/A Error Poody	by Poody	1	507
How do I highlight data differences in workbook tweacle	by bridgesmj	4	637
apply different prices to different quantities (variable pricing?) Raymond Ray	by Roger Govier	3	956
Automatic Quote Number Creator Nitza	by paul	4	1,065
Vlookup on partially sorthed lists Sean	by Sean	3	364
Return Unique Duplicate Numeric Values across Single Row Sam via OfficeKB.com	by T. Valko	7	882
Cells Slide Under Fred Atkinson	by T. Valko	3	2,330
Formula problems Lago2004	by Gord Dibben	7	864
Pivot Table - Problems when using Calculated Item sg	by Debra Dalgleish	1	505
Can I compute the eigenvectors of a matrix in excel? risotto	by risotto	0	1,640
COUNTIF cannot count decimal number occurences Ignorasmus	by Dave Peterson	2	2,160
How does one make data in a cell blink Vern	by Vern	0	749
Need formula to add a set amount to a balance on a specific date Sam	by Don Guillett	1	546
Labor costs for estimates CIL	by Roger Govier	5	628
use a worksheet as a form to collect data Paul Kinnear	by Dave Peterson	4	2,468
Find max Row() number for a value in column Vlado Sveda	by Teethless mama	12	1,751
Rows not formatting all the way down Angie	by Don Guillett	3	575
SUMPRODUCT returns 0, when I know it shouldn't Tim Bridle	by VBANoob	5	830
Function to detect type of cell contents Mark	by Bernard Liengme	3	426
need help with a formula Rhonda Edwards	by Pete_UK	18	1,415
Most recent price per item KatV	by KatV	0	538
Need Help about vlook vlook fomula	by Pete_UK	1	387
NA Pete_UK	by Pete_UK	0	355
conditional Formatting based on cell formatting Totom	by VBANoob	3	2,113
How do I hide a divide by zero error from an average formula? Julia	by daddylonglegs	2	5,673
how do I paste range name list? Adesso	by Mike	2	1,731
Converting a formula to a date tom	by FSt1	2	313
Find the top Scores per School Max	by Max	0	449
NA T. Valko	by T. Valko	0	322
NA Chip Pearson	by Chip Pearson	0	293
Array formula for unique values Dan Hatola	by T. Valko	1	507
How to return to a cell after sorting a spreadsheet. Givvie	by Chip Pearson	1	541
Complex Look Up Problem CJLuke	by T. Valko	5	451
Array formula for unique values Dan Hatola	by Dan Hatola	0	591
another array question Robert Dieckmann	by Epinn	5	484
Get Macro warning, but can't find Macro Stilla	by Stilla	1	794
saving filters CLR	by CLR	0	332
Excel Function - Please help Neil Hindry	by daddylonglegs	6	439
[=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2') Lawrence C H Tan	by Lawrence C H Tan	0	1,566
counting check boxes mini MP	by mini MP	0	886
My SUM function is totalling to 0 Caroline	by Caroline	0	572
LOOKUP with 2 or more criteria Tomas	by Mike	1	423
replace results from list with corresponding list Sean McDonald	by Sean McDonald	0	531
coloured fonts in cells tom	by tom	0	481
Conditional formatting date ranges arkmpr	by arkmpr	1	781
counting check boxes mini MP	by mini MP	0	394
remove links when pasteing formulas from one workbook to anoth Roger	by Roger	1	1,260
Calling cell values from random sheets from a base sheet [email protected]	by Gary Brown	2	526
adding data to existing data cell Curious	by Teethless mama	2	560
Data Validation Problem Mark S	by Mark S	0	397
My SUM function is totalling to 0 tom	by daddylonglegs	1	1,104
columns like in word jenn	by Dave F	1	345
= in cell does not upadate Karlos	by Karlos	0	441
Dynamic Rolling Average Lancer940	by Lancer940	5	1,333
Conditional IF statements sike11 via OfficeKB.com	by Mike	9	717
LOOKUP and #N/A Error Mike	by Poody	1	651
hiding zero values on all sheets & by default on new sheets WiFiMike2006	by vttanker	4	1,323