Excel Worksheet Functions - Page 547

Thread / Thread Starter	Last Post	Replies	Views
I want to highlight a column if the date in cell #4 is this week. John R.[_2_]	by T. Valko	4	1,679
What is a msoanchor? John Reames	by JLatham	2	702
SUM function across multiple worksheets within one workbook John Reimer	by John Reimer	4	740
how do i find unique avg buy prices in multiple group of buys/sell John Robbins	by John Robbins	1	483
Consolidating multiple workbooks John Robinson	by Harlan Grove	1	585
How do I set up IRR and NPV functions in Excel? John Rovenolt	by Gord Dibben	2	1,175
Formula to send answer from 2 sources to one column John Rundle	by Max	3	412
sumif John S	by T. Valko	9	721
Sheetname formula John S	by Gary''s Student	3	435
How can i split combined number and text in excel using formula? John S	by Lori	14	3,772
Sorting names in a range John S	by Arvi Laanemets	2	603
Excel sumif functions? John S via OfficeKB.com	by RagDyer	1	450
How can I set up names to automatically copy from a spreadsheet? John S.	by Gord Dibben	2	458
how to type this funtion John Sam	by Difficult1	1	367
max() and sort John Savage	by V for Vegemite	5	334
Table John Savy	by David Biddulph[_2_]	11	880
how do I display row 1 (my column titles) as I page down in excel John Schering	by Bob Phillips	2	642
Convert Gig to Meg John Schneider	by John Schneider	6	808
Font size for in-cell drop-down list John Simons	by John Simons	4	1,065
Nested IF statements John Simons	by Arvi Laanemets	14	2,603
Using VLOOKUP with multiple first column matches John Simons	by Ragdyer	2	1,536
=SUM question John Smith	by John Smith	6	364
possible to use IF to add formula? John Smith	by Pete_UK	1	404
formula for a formula JOhn Smith	by JOhn Smith	3	366
Index and Match John Smith[_17_]	by John Smith[_17_]	8	860
Determie Trend John Smith[_4_]	by Mike Middleton[_2_]	2	492
hybrid formula H&Vlookup???? John Smith[_6_]	by Max	5	699
Formula for determing average based on weighting John Sullivan	by [email protected]	2	794
Sum total formula for adding 2 columnson time sheet John Sullivan	by Anne Troy	1	788
time sheet to calculate 2 different columns John Sullivan	by Biff	1	1,493
IF, THEN statement John Sullivan	by Bob Phillips	1	362
Setting up page template John Sullivan	by Chip Pearson	1	576
Template for printing-orientation, header-footer setup John Sullivan	by John Sullivan	0	458
Auto calculate for date + days forward to yield new date John Sullivan	by Otto Moehrbach	1	3,802
Unable To OPen Excel 2003 John Sullivant	by John Sullivant	0	583
Pivot Table Field based on two data area fields John Sweeney	by Shane Devenshire[_2_]	3	1,097
ANOVAs Excel 2000 John T	by Mike Middleton	6	357
add cell a to cell b on worksheet ( both cells linked to other cel john t	by john t	0	335
HH:MM:SS to decimal John T Kennedy[_2_]	by Pete_UK	2	1,060
HH:MM:SS to decimal value John T Kennedy[_2_]	by John T Kennedy[_2_]	3	458
numbers to text function John T. Sheedy	by Ron Rosenfeld	2	528
How do I auto highlight a cell with the same data as another cell john talbot	by Pete_UK	11	1,224
lock tab in sheet 2 until cell in sheet one is completed john tempest	by john tempest	7	1,189
delete some cell formulas and leave others using code john tempest	by john tempest	0	608
Find top 10 scores John Terry	by John Terry	2	587
SUMIF john the confused	by john the confused	3	391
A "ConcatenateIF" Function in Excel John the Engineer	by John the Engineer	2	1,163
Deriving several lists from a master list John Tonitto	by John Tonitto	3	925
cell pointer content Info John Tucker	by John Tucker	0	577
negative times john tyler	by Chris Marlow	2	366
how do i show negative time in hours minutes john tyler	by john tyler	0	653
eomonth John T[_2_]	by Gary Brown	3	457
Multifunctional formula John T[_2_]	by Jacob Skaria	2	501
DATE AND TIME CONVERSION HELP John T[_2_]	by Shane Devenshire	2	378
Can the results of a formula drive color shading? How? Can it be . John V	by Frank Kabel	1	626
SUMPRODUCT Criteria Via Cell Reference?? John V	by Bob Phillips	8	1,534
OFFSET Problems John V[_2_]	by T. Valko	3	361
how do I have a cell that does the date plus 7? John W	by Beege	2	1,625
how to use shift and down arrow keys in a macro? John W	by David McRitchie	1	881
Auto-delete Unbolded Cells John Walker	by John Walker	2	524
Page Break Column Headers John Walker	by Stan Brown	1	1,053
Power and Sum John Watt	by Bernard Liengme	6	709
I need a formula please. John WEC	by John WEC	8	409
I want to create a function or formula John Weller	by Gaurav[_2_]	5	554
Sum Function sometimes displays incorrect answer John Westgate	by John Westgate	4	1,157
Read data from anohter XLS file John Whitehead via OfficeKB.com	by Justin	6	619
Is there a way to stop fractions from being simplified? John Wilkins	by Roger Govier	3	1,679
Why #NAME? John Wirt	by [email protected]	2	381
Why #Name?? John Wirt	by John Wirt	2	380
Conditional formatting--simple question John Wirt	by Biff	4	423
Tallying Letters John Wright OCC	by Mike H	2	450
Auto Filter - Calculating Median John Y	by Roger Govier[_3_]	1	770
Average with criteria for adjacent cells ? John Yaris	by GS[_2_]	1	1,834
How do I produce consecutive invoice numbers in Excel? John Z	by John Z[_2_]	4	2,182
Get data from pivot table (using VBA / index and match function) john-lau	by john-lau	0	1,064