Excel Worksheet Functions - Page 569

Thread / Thread Starter	Last Post	Replies	Views
Querying Access for QTD and YTD Sales totals Marcotte A	by Marcotte A	0	823
Default date and time in the comment. Gary	by Gary	4	762
If, then statement troubles beez	by JE McGimpsey	1	482
Multiple formats in the same cell [email protected]	by Gord Dibben	2	510
Interpreting "comma" where an optional argument is Epinn	by Epinn	4	747
SUMPRODUCT - comma versus semicolon Epinn	by Epinn	6	1,854
Need help with a date check formula Dan B	by daddylonglegs	7	841
Match iamjbunni	by daddylonglegs	1	354
Excel Spreadsheet Assistance (Match, Compare) Nancy	by Bernie Deitrick	1	478
vlookup with a sum of array Jerry (the latin men)	by T. Valko	5	723
Copy a column dependant on a the contents of a cell Peter	by T. Valko	5	521
"general" cells turned into "accounting" - why and how to reverse Kolhoz	by Martin Fishlock	1	1,366
Cannot see formula descriptions in worksheet as I type a formula. RABL33	by T. Valko	5	564
Formula to average the last 4 non-blank numerical cells of a row? VB Coach	by Ron Coderre	5	3,514
number/time format sako 338	by sako 338	3	446
addition returns a number followed by E-15 sako 338	by sako 338	2	847
time and if statements Crazy Lady	by Crazy Lady	4	551
Concantenate numeric fields Pa Maher	by Pa Maher	10	1,017
IF and lookup functions combined? RSS	by driller	1	1,095
cells that "contain" values rok	by Rupert	5	410
Expanding and Collapsing Groups within a Protected Workbook blue	by arno	1	1,247
How do I treat row 1 in my worksheet as a header for each page? cfcoyne	by Don Guillett	3	478
how to I make member list that indicates when subs due Lozza	by Don Guillett	2	505
Repeating colors in Excel 2000 DennyB	by DennyB	0	479
Cell changes from General format to Scientific flish	by flish	9	1,943
formula/autocomplete to link data from other worksheets Andrew	by Bernie Deitrick	6	1,336
Sheet Column Headings and Row Labels monir	by jfreidin	9	1,059
Sum of every 6th column and recurring Pierian Spring	by Duke Carey	3	1,348
first number after zeroes in sequence [email protected]	by [email protected]	4	639
Conditional format based on entire row LisaVH	by driller	8	1,076
USING DATA FROM AN EXCEL FILE TO IMPORT INTO ANOTHER Andrew Pickles	by igorek	1	596
Formula needed for too much inventory Angela	by Angela	4	711
Custom number format problem Pierre	by Pierre	3	513
Workday Date Calculation kdlilly	by Paul B	7	563
Using cell data as file name huntnpeck	by huntnpeck	2	394
How to calculate the diference of times in excel? jaberli	by daddylonglegs	4	465
Right Justifing in Excel J Harris	by J Harris	3	369
data analysis addin in Excel 2007 Blake	by Blake	1	917
value expression RayB	by driller	7	702
{} in formel svemor	by Gord Dibben	2	474
How do you alphabetize a whole spreadsheet ? PageRW	by Jim Cone	5	1,014
(INDEX($T3:$T4849,MATCH($D3,$P$3:$P$4849),FALSE)) [email protected]	by Bernie Deitrick	1	512
filter for even numbers in Excel Kirstensaid	by Bernard Liengme	5	3,768
How to paste exact value into another cell? Lewis0205NC	by Gord Dibben	4	1,037
clear range of cells if another becomes blank bgg	by Max	3	650
Formula question - does anybody have the answers? Orangepegs	by Orangepegs	3	437
naming sheet tab artist4christ	by Gord Dibben	5	518
Vlookup problem Peter	by Dave Peterson	4	558
Subtotals not working correctly when 2nd subtotal added Pete	by Dave Peterson	1	1,202
IF and lookup functions combined? RSS	by RSS	4	644
Change Multiple Page Fields in two independent Pivot Tables Oleg	by Debra Dalgleish	1	1,104
LIFO inventory method? Tduncan	by Tduncan	2	2,090
Copying changes from one worksheet to other worksheets Steve	by DonCam65	2	413
message box text sako 338	by Martin Fishlock	2	422
Cell content is based on other cell value MIchel Khennafi	by Joerg	2	794
excell windows 03 cond format help John	by Bernard Liengme	7	557
hi, new value formula question RayB	by Bernard Liengme	5	519
Array using MIN Jatiro	by Jatiro	3	513
how to compare data in two different work sheets Melanie	by Teethless mama	2	906
Prevent worksheet from opening in a workbook laurenm	by Gord Dibben	5	1,003
Looking for Bi-Weekly CDN Amortization Schedule Nathalie	by [email protected]	4	1,207
Formula won't run Fadzil	by JE McGimpsey	1	549
How do I get data automatically entered into a cell? rldjda	by Martin Fishlock	1	595
Count working days by week inta251	by inta251 via OfficeKB.com	7	973
How to look for value? Eric	by JE McGimpsey	1	420
Autofilter multiple columns Saintsman	by Saintsman	2	1,606
MSDN article on Excel Limitations in Pivot Tables for Multiple consolidation ranges [email protected]	by [email protected]	0	1,020
Incremental Numbering Challenged	by Challenged	2	635
MORE THAN ONE CONDITION IN A FORMULA CLM	by CLM	5	712
Shadow to cell how? Anand vijay	by Max	1	530
calculate Joye	by Joye	2	496
Totalling up a Filtered List B Baggins	by B Baggins	2	738
Can I create new sheets automatically in a formula? Greg	by Marcelo	1	1,176
Sumproduct with wildcards Saintsman	by Teethless mama	3	648
Array formula fill down problem [email protected]	by [email protected]	0	1,229