Excel Worksheet Functions - Page 619

Thread / Thread Starter	Last Post	Replies	Views
DAYS360 Candentco Creative Collection[_2_]	by Candentco Creative Collection[_2_]	4	619
Converting a Grid (or range) of Data to a List a	by Dave Peterson	1	567
maximum Dale	by Elkar	1	457
Is there a way to automatically hide empty rows? Christine	by PCLIVE	1	1,125
Plot times of day on chart Bruce	by Sandy Mann	2	813
pivot in 2003 using 2007 data Maritza	by Maritza	0	336
Wildcard and Sumproduct kd	by David McRitchie	6	505
is there a function to change negative values to zero? B-manninja	by David McRitchie	2	341
Add 4 hours (only if between 9am-5pm) Angela1979	by David McRitchie	3	556
Can "lotus" from IBM be intergreaded with Excel. and how? Jason	by Jason	0	370
Excel base 10 log for Optical Density vs %T BillO	by Barb Reinhardt	1	968
Calculate average in a cell from one of two columns BillO	by Mike	2	517
Adding months to a date miss misty	by Stan Brown	3	460
sum certain cells in a column based on criteria from another colum rainbowraven	by T. Valko	8	963
Formula to give date and time Angela1979	by BoniM	6	543
Saving Sort Criteria in 2007 Dbltap	by Leung	1	749
print more than one file hitesh	by Leung	1	550
Can't make conditional lookups work with SUMIF. RoryTuna	by T. Valko	3	559
sum emmcee	by emmcee	2	429
Write a function to do what auto-filter does Kobus	by Kobus	4	542
How can I use "&" in footer coz Its not appear when print preview SRE SHAZIELA	by David Biddulph[_2_]	1	453
get Pivot table to generate separate worksheets for each row? Matt D Francis	by Matt D Francis	2	1,189
+++Switch Rows & Columns Ian	by David Biddulph[_2_]	1	429
how do i put in a parallel line on a cell to show a cancellation Janie	by Mike	1	680
Excell function Milli	by Duke Carey	4	451
Tricky Conditional Count Steve	by Teethless mama	5	415
Finding the oldest & newest dates Bob Smith	by Bob Smith	3	1,016
I want to use sumif to sum up a column based on a range of dates Ricky from Pine Island	by Teethless mama	2	620
How do I unembed a worksheet? Rachel	by Rachel	0	1,898
RANK with 0 values JN	by Yogi Anand--www.energyefficientbuild.com	4	537
Please help with a "find duplicates" macro - 4/10/07 41db14	by Rodrigo Ferreira	13	840
Advanced Filter ...?? RWilliams	by Yogi Anand--www.energyefficientbuild.com[_2_]	4	355
if statements SB777	by Yogi Anand--www.energyefficientbuild.com[_2_]	3	393
SIMPLE SUM FORMULA [email protected]	by [email protected]	3	338
Formula for totaling occurrences in a specified range Valerie	by Naz	1	465
formulas continuing crtreporter	by Naz	1	461
How do I find elapsed time between 2 dates and times? Alistair	by Alistair	5	1,961
Linking 2 documents Hoosiers	by GQC	2	524
Can I duplicate headers and footers on multiple sheets? HeatherDBecerra	by HeatherDBecerra	2	1,792
Formatting action activated link Go figure	by Go figure	0	611
Sumif vs Text? Ken	by Ken	6	658
Use a code to populate a cell with a specific value braveT	by Storm	5	867
how do i transfer dada from one spread sheet to another ziggy	by MyVeryOwnSelf	1	545
Trouble with copy & paste from Visa web site Tri-Pacer	by Elkar	2	541
numbers automatically populate in red ekornell	by Sam Carraway	4	395
Sum values, by month, in another worksheet Carlee	by Max	1	740
Cell incremental increase stuck in van nuys	by Dana DeLouis	2	1,049
Formatting one cell based on the contents of another cell A.C.G.	by A.C.G.[_2_]	2	944
Sumif NeedHelpFast	by NeedHelpFast	6	329
Combining Cell Contents Storm	by Teethless mama	4	517
Reference a Sheet in Formula Carlee	by Bob Phillips	3	352
Sliding scale Question Sandy	by Joel	1	1,055
Any method to set cell background color conditionally ? come_mon_come_mon!	by Joel	2	917
IF Function - Specific currency format Colin	by Gary''s Student	8	1,967
Lookup function using 2 variables tbar38547	by Yogi Anand--www.energyefficientbuild.com[_2_]	2	780
Automatically saving value even though the formula changes with th jpolzner	by Joel	1	337
help about date & month function in Excel FOUAD	by Joel	6	351
Excel List submenu missing in XP, after reloading builtin menus Mark	by Gord Dibben	3	858
Enable the Options button from the Tools Menu Dacasinoking	by Gord Dibben	2	699
Importing Excel Sheet to Outlook Contacts Denise	by Gord Dibben	2	717
How can I setup a rolling 13 week spreadsheet? cshel	by Art	1	3,561
Condtional Format Question Jon Dow[_2_]	by Jon Dow[_2_]	2	490
Pivot Table question-formatting Jon Dow[_2_]	by Jon Dow[_2_]	0	309
validation zero Devlin	by Bob Phillips	2	303
ARRAY NOT COUNTING A CERTAIN ROW Rafterrpf	by Don Guillett	2	505
Removing a formula from a cell once the result is in the cell jpolzner	by David McRitchie	2	579
Formula mygirls2_ae	by David McRitchie	4	400
How do I set caps lock as default? Mark Barnard	by David McRitchie	1	1,659
workday include saturday stremetzky	by Bernd	5	1,123
I want to return the #VALUE! as a blank cell. kgb1953	by David Biddulph[_2_]	1	436
Need help Moe	by David Biddulph[_2_]	7	421
Min < 0 St@cy	by JMB	2	302
Dependent Dropdown List - Not Easy! kditty02	by kditty02	2	497
Array: Counting multiple values within array Trilux_nogo	by JMB	4	1,147
Help: Trying to get hours for 11pm-7am shift Caramon6561	by Caramon6561	7	1,157