Excel Worksheet Functions - Page 671

Thread / Thread Starter	Last Post	Replies	Views
covert 72.8 to 72:48 Rosemary	by Bernie Deitrick	2	455
Returning text using a formula AJL	by JLatham	1	400
replace - by blank, keep 0 in phonenumber sofie	by SteveW	8	470
Calculating a sum with running total and replacement Mouse	by Mouse	3	572
remove -, keep 0 in phonenumber sofie	by sofie	2	333
COUNTIF in a range (and parts of cells) Phrank	by Phrank	3	636
Extracting information from large worksheet Louise	by Louise	6	585
combining data from two worksheets David	by Max	1	379
I need to recover a spreadsheet. Winneyfred	by David Biddulph	1	386
Disgusting cross-post Kevryl	by Kevryl	0	433
formulas cachegirl68	by Leo Heuser	1	304
Trying to MATCH a value out of a cell on an ARRAY - help pls goofy-duck	by Biff	2	714
hide values and display a decimal point that fills the cell Sally	by Epinn	2	868
Retrun "" (blank) Jay	by Biff	1	364
Macros inside Excel Mark	by TOT	4	540
CTRL+SPACEBAR Henk	by Henk	0	689
How do you save an excel file to be read as IBM-type text file ? Dee Franklin	by JLatham	2	855
Tournament Template? DTTODGG	by Gord Dibben	2	1,882
Removing a hyperlink when right click doesn't open shortcuts? [email protected]	by [email protected]	3	449
compare and combine data with in one workbook Kelly	by Pete_UK	1	477
Sum Color coded cells taxmom	by MarkN	1	860
Sending information from one worksheet to another Kevin	by Paul B	3	587
IF Function Suz	by Elkar	6	458
How do I display text in the data field of a pivot table? Allan	by Debra Dalgleish	1	1,420
IF then statements-Tiered PRicing Jackiec21	by Epinn	16	2,097
Countif Bobt	by daddylonglegs	1	426
Putting columns back in alpha order CLytle	by Roger Govier	9	702
Counting occurances in one column if another col. meets a certain Robert	by Elkar	1	379
Page numbering dilemma Rioh	by MyVeryOwnSelf	1	398
Can I make array position A(12) into a variable A(12*n) ? Paul	by Elkar	1	455
date format EdJack	by Bob Phillips	2	375
My discovery on adding months and days to a date! Epinn	by Bob Phillips	8	958
how do i count how many times x in column a = 1 or 2 in column b Tony the Bajan	by excelent	8	684
if statements WaqB	by daddylonglegs	3	486
date format EdJack	by daddylonglegs	1	393
sumproduct help Todd	by daddylonglegs	1	522
Combine data - Please help Kelly	by Miguel Zapico	1	468
enter formula once for entire column sheepdiver	by Miguel Zapico	1	690
auto sum aloha mama	by JLatham	6	519
Range Names & Auto Fill Peter	by Peter	2	453
Loop thru rows to copy to another excel spreadsheet eighthman11	by eighthman11	0	506
Dynamic file referencing? [email protected]	by Miguel Zapico	1	648
Formula Bob	by Bob	5	343
My autofilter is dimmed in one worksheet only in Excel 2003 how d. LarrW	by Debra Dalgleish	3	740
copy select characters from specified cells. Ron	by Ron	3	905
First negative number Iriemon	by Bernard Liengme	3	672
deleting unused space at the end of a worksheet beckyz	by Paul B	3	1,382
Need statistical help DTTODGG	by Mike Middleton	2	730
I NEED HELP! Saky	by Saky	7	527
Read how to two-way link cells, now can't find the example!? Bill Case	by Bill Case	0	1,391
Chart data won't accept text functions in series name [email protected]	by JethroUK©	3	1,749
#ref error with Sumproduct [email protected]	by [email protected]	5	1,193
excel worksheet tabs to be organized vertically in outline format Ghomez32	by Ghomez32	0	1,159
Formulas with conditions EG	by [email protected]	2	379
Out of memory. Why? Carl	by JLatham	4	499
Navigate between worksheets Louise	by vezerid	1	485
Looking up previous data in column within an IF statement CheekyFlash	by CheekyFlash	0	586
vlookup to include text Louise	by Toppers	7	589
navigating between worksheets Louise	by JLatham	3	577
How do I combine five Excel 2003 workbooks? Robert Judge	by Mike Middleton	2	1,050
generating dates xppuser	by [email protected]	9	566
Excel formula - should this be a macro? Dos Equis	by Dos Equis	0	423
WORKDAY() Function Equivalent with SUMPRODUCT() George Ray	by daddylonglegs	4	1,184
Splitting appointment records in to 15 minute time bands The Inquirer	by The Inquirer	4	1,022
How do i add up every other coloumn in a linked sheet abs	by Roger Govier	1	505
how can I count (countif) the character: * Mousquito	by Stefi	1	606
Need help with complicated Vlookup, or possibly other function havocdragon	by Bob Phillips	1	773
Box Plot in Excel Omkar	by Carim	1	415
Formulas stop calculating slc	by Arvi Laanemets	2	440
Copying data based on a condition aheintz57	by Max	4	1,022
Using IF based on an LEN field James T	by Tom Ogilvy	2	564
Excel should have a QUARTER formula for DATE calculations Jeff Stubing	by JMB	5	4,588
Find Replace Textual Values across entire records Lynden	by Tom Ogilvy	1	608
Assign Macro David	by Tom Ogilvy	1	443
Nested Ifs Amy	by Amy	3	530