Excel Worksheet Functions - Page 597

Thread / Thread Starter	Last Post	Replies	Views
B1 is blank if A1 is zero woitena1	by Max	1	314
B1 is blank if A1 is zero woitena1	by woitena1	2	867
how can i get the text to flash on and off in excell tom grant	by Alan	2	650
If A1 is zero, A2 is blank woitena1	by Herbert Seidenberg	3	849
Disapering text in a text box ! Macky	by Macky	0	331
Pasting data from Matlab to Microsoft Excel nt_artagnian	by Gord Dibben	5	1,612
Excel Solver as User Defined Funcntion Murthy	by Murthy	11	966
AND() for an array Zilla[_2_]	by Zilla[_2_]	8	373
Ue of VLOOKUP for a Range of Items Randy Brown	by Don Guillett	2	399
Extracting names from an unsorted list. Brian H	by Ron Coderre	7	771
Where can I get detailed steps to creating a SHARED WORKBOOK? LUNA	by LUNA	0	404
How do I insert web links into cells in excel? Dumbexcelgirl	by Gord Dibben	1	1,100
SUM function creates circular ref if first or last rows are moved Alera	by Héctor Miguel	1	524
SUM OF COLUMN A5-A50 IN EXCEL? bobby b385[_2_]	by Bob Phillips	2	466
formatting a column S Davis[_2_]	by MartinW	4	378
Need help with pulling out data between brackets Bob Smith	by Teethless mama	6	1,079
Trouble with concatenation number format FJ	by FJ	2	449
References between worksheets using IF Kamran	by Philip[_2_]	7	457
Pulling top 5 rank? [email protected]	by MartinW	1	685
decreasing # to stop decreasing when <=0 Ken	by JLatham	1	461
How to find average for grading? Param	by Bob Phillips	3	482
Linking Problem in Excel Double M	by Dave Peterson	1	490
Anyway to modify 30 or so web queries? Bob Smith	by Bob Smith	0	332
Get Current Row for use in INDIRECT function TBONE6540	by Harlan Grove[_2_]	7	1,320
Move Cell Value to Right Using Formula [email protected]	by Gord Dibben	4	708
Help using Pivot Tables K.R	by Debra Dalgleish	5	692
Telephone list in excel worksheet [email protected]	by Dave Peterson	1	694
Date Functions for Excel published to HTML A Bald	by A Bald	0	372
Sum Order and Vendor Orders from Pivot Table for Given Month vstar	by vstar	5	669
Code for button to hide/unhide rows Chris	by Chris	5	941
Excel help [email protected]	by David Biddulph[_2_]	2	376
DATE PROBLEM Malcolm Austin	by Malcolm Austin	2	309
how to convert a number to words automatically in a sheet? Mohit Gujjar	by Paul B	1	1,169
add cells ignoring hidden cells Doolys	by Bob Phillips	1	351
copy back macro/roll back moh	by moh	4	1,070
Help on IF function CBZ[_2_]	by Don Guillett	2	322
Obtaining Multiple Results using muliple Criteria from an Array Archie999	by Toppers	2	453
Dates display as "38854" Kamran	by Kamran	8	332
Interest calculation KeenKiwi	by Dave Breitenbach	14	1,355
how to formulate this easily??? driller	by driller	6	495
Extracting data from workbook1 to workbook2 [email protected]	by vezerid	1	302
Create a template, on close, save those cells into another workshe kangasnat	by Gord Dibben	1	364
Data-Validation-List-Width of list must be colomn width, is this possible Luc	by Gord Dibben	2	1,132
XL2003 inconsistency fixed in XL2007? joeu2004	by Harlan Grove[_2_]	2	543
Change cell color for more than 3 conditional statements Katie	by Bob Phillips	1	382
SELECT Query TJ[_2_]	by Harlan Grove[_2_]	6	463
counting the number of instances of a string within another string Keith R	by Keith R	3	860
Macro to protect multiple sheets? Stilla	by Dave Peterson	12	2,406
vlookup 2 fields [email protected]	by Dave Peterson	2	587
who can write Excel Formulae Craig Wargel	by JLatham	9	607
excluding #DIV/0! in further calculations tom ossieur	by Dave F	5	4,788
Countif Help Curtis	by KL	1	320
How do I determine how many worksheets a workbook has at a glance dm	by Gord Dibben	3	1,886
Multiple results in 1 cell w/ multiple criteria RS	by RS	0	587
Work's on mine but not others Don C	by Don C[_2_]	2	494
Vlookup Demetrio Valdez	by Don Guillett	9	789
#VALUE in Date calc Martha	by Pete_UK	1	632
animation in excel Jim	by Pete_UK	1	853
Need Sumif help.... Dan B[_2_]	by Toppers	10	690
Sumproduct with either text of number format Curtis	by driller	4	819
Time Diff from text format JICDB	by JICDB	8	513
Sub-Totals Question SBoak	by Per Erik Midtrød	1	376
Counting Unique Items with Multiple Criteria Joe Gieder	by Domenic	3	546
Converting Dates Jacq	by Jacq	5	486
Maybe Vlookup ? But..... Steve	by Steve	8	335
Sumproduct Curtis	by Jason	1	408
finding a value between a range Susan	by Susan	9	605
Countif forumulas that refer to more than one column Karl	by JLatham	4	967
CONCATENATE problem Mark Dullingham	by Mark Dullingham	6	941
mutiple Validations for cells ljhopkins_LOST and Cant find My Way	by JLatham	4	496
How to return data? KUKA Guy	by KUKA Guy	6	483
Cell/worksheet protection with macros enabled Zilla[_2_]	by Zilla[_2_]	7	1,307
copy of formula contains file names into other cells Turk	by Turk	2	489
% in Pivot Reports MLK	by MLK	2	358
Automating grouping of Excel pivot field [email protected]	by [email protected]	4	363