Excel Worksheet Functions - Page 613

Thread / Thread Starter	Last Post	Replies	Views
replacing text within a formula jimswinder	by Roger Govier	5	483
detecting duplicate input in a cell leo	by Roger Govier	1	363
why a excel file,one sheet only, take 23 Mb ? MCortes	by Joerg	1	924
detecting duplicate input in a cell leo	by leo	0	326
detecting duplicate input in a cell leo	by leo	0	373
Show Null As %0 Ardy	by Ardy	6	448
Check dates in spreadsheet against expiry years column and change colour [email protected]	by trasha	4	618
How to return 1 with #VALUE!? Eric	by Eric	4	419
Buttons rio	by Corey	1	396
Count unique if text Mike Fogleman	by Epinn	16	1,199
description of countif criteria? Jakobshavn Isbrae	by Jakobshavn Isbrae	8	536
Cut and paste options [email protected]	by Roger Govier	1	379
What is the problem with this formula? Teethless mama	by [email protected]	1	393
Same dates in Sheet1 put as one date in Sheet2 inta251 via OfficeKB.com	by inta251 via OfficeKB.com	6	535
How do I add up time and minutes in a spreadsheet? Todd B.	by Lynne	3	2,792
formula that works in a different workbook Jude Reason	by Teethless mama	5	539
Does anyone see this .xls]sheetname? Eric	by Dave Peterson	2	561
MACRO AND MULTIPLE WORKSHEETS Mel	by Richard Buttrey	8	979
LOOKUP and #N/A Error Poody	by Poody	1	510
How do I highlight data differences in workbook tweacle	by bridgesmj	4	642
apply different prices to different quantities (variable pricing?) Raymond Ray	by Roger Govier	3	959
Automatic Quote Number Creator Nitza	by paul	4	1,068
Vlookup on partially sorthed lists Sean	by Sean	3	367
Return Unique Duplicate Numeric Values across Single Row Sam via OfficeKB.com	by T. Valko	7	889
Cells Slide Under Fred Atkinson	by T. Valko	3	2,332
Formula problems Lago2004	by Gord Dibben	7	866
Pivot Table - Problems when using Calculated Item sg	by Debra Dalgleish	1	507
Can I compute the eigenvectors of a matrix in excel? risotto	by risotto	0	1,643
COUNTIF cannot count decimal number occurences Ignorasmus	by Dave Peterson	2	2,165
How does one make data in a cell blink Vern	by Vern	0	766
Need formula to add a set amount to a balance on a specific date Sam	by Don Guillett	1	549
Labor costs for estimates CIL	by Roger Govier	5	631
use a worksheet as a form to collect data Paul Kinnear	by Dave Peterson	4	2,471
Find max Row() number for a value in column Vlado Sveda	by Teethless mama	12	1,754
Rows not formatting all the way down Angie	by Don Guillett	3	577
SUMPRODUCT returns 0, when I know it shouldn't Tim Bridle	by VBANoob	5	835
Function to detect type of cell contents Mark	by Bernard Liengme	3	432
need help with a formula Rhonda Edwards	by Pete_UK	18	1,418
Most recent price per item KatV	by KatV	0	548
Need Help about vlook vlook fomula	by Pete_UK	1	389
NA Pete_UK	by Pete_UK	0	357
conditional Formatting based on cell formatting Totom	by VBANoob	3	2,146
How do I hide a divide by zero error from an average formula? Julia	by daddylonglegs	2	5,680
how do I paste range name list? Adesso	by Mike	2	1,738
Converting a formula to a date tom	by FSt1	2	318
Find the top Scores per School Max	by Max	0	450
NA T. Valko	by T. Valko	0	324
NA Chip Pearson	by Chip Pearson	0	297
Array formula for unique values Dan Hatola	by T. Valko	1	511
How to return to a cell after sorting a spreadsheet. Givvie	by Chip Pearson	1	543
Complex Look Up Problem CJLuke	by T. Valko	5	457
Array formula for unique values Dan Hatola	by Dan Hatola	0	595
another array question Robert Dieckmann	by Epinn	5	487
Get Macro warning, but can't find Macro Stilla	by Stilla	1	803
saving filters CLR	by CLR	0	335
Excel Function - Please help Neil Hindry	by daddylonglegs	6	442
[=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2') Lawrence C H Tan	by Lawrence C H Tan	0	1,578
counting check boxes mini MP	by mini MP	0	889
My SUM function is totalling to 0 Caroline	by Caroline	0	574
LOOKUP with 2 or more criteria Tomas	by Mike	1	425
replace results from list with corresponding list Sean McDonald	by Sean McDonald	0	533
coloured fonts in cells tom	by tom	0	486
Conditional formatting date ranges arkmpr	by arkmpr	1	785
counting check boxes mini MP	by mini MP	0	400
remove links when pasteing formulas from one workbook to anoth Roger	by Roger	1	1,263
Calling cell values from random sheets from a base sheet [email protected]	by Gary Brown	2	528
adding data to existing data cell Curious	by Teethless mama	2	564
Data Validation Problem Mark S	by Mark S	0	399
My SUM function is totalling to 0 tom	by daddylonglegs	1	1,106
columns like in word jenn	by Dave F	1	347
= in cell does not upadate Karlos	by Karlos	0	443
Dynamic Rolling Average Lancer940	by Lancer940	5	1,335
Conditional IF statements sike11 via OfficeKB.com	by Mike	9	724
LOOKUP and #N/A Error Mike	by Poody	1	653
hiding zero values on all sheets & by default on new sheets WiFiMike2006	by vttanker	4	1,330