Excel Worksheet Functions - Page 671

Thread / Thread Starter	Last Post	Replies	Views
covert 72.8 to 72:48 Rosemary	by Bernie Deitrick	2	434
Returning text using a formula AJL	by JLatham	1	379
replace - by blank, keep 0 in phonenumber sofie	by SteveW	8	460
Calculating a sum with running total and replacement Mouse	by Mouse	3	551
remove -, keep 0 in phonenumber sofie	by sofie	2	323
COUNTIF in a range (and parts of cells) Phrank	by Phrank	3	617
Extracting information from large worksheet Louise	by Louise	6	555
combining data from two worksheets David	by Max	1	367
I need to recover a spreadsheet. Winneyfred	by David Biddulph	1	379
Disgusting cross-post Kevryl	by Kevryl	0	425
formulas cachegirl68	by Leo Heuser	1	298
Trying to MATCH a value out of a cell on an ARRAY - help pls goofy-duck	by Biff	2	690
hide values and display a decimal point that fills the cell Sally	by Epinn	2	838
Retrun "" (blank) Jay	by Biff	1	357
Macros inside Excel Mark	by TOT	4	526
CTRL+SPACEBAR Henk	by Henk	0	662
How do you save an excel file to be read as IBM-type text file ? Dee Franklin	by JLatham	2	834
Tournament Template? DTTODGG	by Gord Dibben	2	1,860
Removing a hyperlink when right click doesn't open shortcuts? [email protected]	by [email protected]	3	433
compare and combine data with in one workbook Kelly	by Pete_UK	1	449
Sum Color coded cells taxmom	by MarkN	1	836
Sending information from one worksheet to another Kevin	by Paul B	3	576
IF Function Suz	by Elkar	6	445
How do I display text in the data field of a pivot table? Allan	by Debra Dalgleish	1	1,395
IF then statements-Tiered PRicing Jackiec21	by Epinn	16	2,075
Countif Bobt	by daddylonglegs	1	402
Putting columns back in alpha order CLytle	by Roger Govier	9	682
Counting occurances in one column if another col. meets a certain Robert	by Elkar	1	360
Page numbering dilemma Rioh	by MyVeryOwnSelf	1	392
Can I make array position A(12) into a variable A(12*n) ? Paul	by Elkar	1	414
date format EdJack	by Bob Phillips	2	366
My discovery on adding months and days to a date! Epinn	by Bob Phillips	8	916
how do i count how many times x in column a = 1 or 2 in column b Tony the Bajan	by excelent	8	663
if statements WaqB	by daddylonglegs	3	457
date format EdJack	by daddylonglegs	1	385
sumproduct help Todd	by daddylonglegs	1	471
Combine data - Please help Kelly	by Miguel Zapico	1	445
enter formula once for entire column sheepdiver	by Miguel Zapico	1	676
auto sum aloha mama	by JLatham	6	509
Range Names & Auto Fill Peter	by Peter	2	447
Loop thru rows to copy to another excel spreadsheet eighthman11	by eighthman11	0	484
Dynamic file referencing? [email protected]	by Miguel Zapico	1	583
Formula Bob	by Bob	5	334
My autofilter is dimmed in one worksheet only in Excel 2003 how d. LarrW	by Debra Dalgleish	3	720
copy select characters from specified cells. Ron	by Ron	3	875
First negative number Iriemon	by Bernard Liengme	3	659
deleting unused space at the end of a worksheet beckyz	by Paul B	3	1,356
Need statistical help DTTODGG	by Mike Middleton	2	704
I NEED HELP! Saky	by Saky	7	515
Read how to two-way link cells, now can't find the example!? Bill Case	by Bill Case	0	1,365
Chart data won't accept text functions in series name [email protected]	by JethroUK©	3	1,720
#ref error with Sumproduct [email protected]	by [email protected]	5	1,161
excel worksheet tabs to be organized vertically in outline format Ghomez32	by Ghomez32	0	1,129
Formulas with conditions EG	by [email protected]	2	367
Out of memory. Why? Carl	by JLatham	4	485
Navigate between worksheets Louise	by vezerid	1	464
Looking up previous data in column within an IF statement CheekyFlash	by CheekyFlash	0	563
vlookup to include text Louise	by Toppers	7	565
navigating between worksheets Louise	by JLatham	3	543
How do I combine five Excel 2003 workbooks? Robert Judge	by Mike Middleton	2	1,027
generating dates xppuser	by [email protected]	9	559
Excel formula - should this be a macro? Dos Equis	by Dos Equis	0	404
WORKDAY() Function Equivalent with SUMPRODUCT() George Ray	by daddylonglegs	4	1,168
Splitting appointment records in to 15 minute time bands The Inquirer	by The Inquirer	4	999
How do i add up every other coloumn in a linked sheet abs	by Roger Govier	1	482
how can I count (countif) the character: * Mousquito	by Stefi	1	592
Need help with complicated Vlookup, or possibly other function havocdragon	by Bob Phillips	1	757
Box Plot in Excel Omkar	by Carim	1	411
Formulas stop calculating slc	by Arvi Laanemets	2	425
Copying data based on a condition aheintz57	by Max	4	999
Using IF based on an LEN field James T	by Tom Ogilvy	2	538
Excel should have a QUARTER formula for DATE calculations Jeff Stubing	by JMB	5	4,559
Find Replace Textual Values across entire records Lynden	by Tom Ogilvy	1	580
Assign Macro David	by Tom Ogilvy	1	424
Nested Ifs Amy	by Amy	3	508