Excel Worksheet Functions - Page 420

Thread / Thread Starter	Last Post	Replies	Views
Weird prob: Format 3rd condition for other than first two Sue in AZ[_2_]	by Sue in AZ[_2_]	5	535
Sumproduct with Match and Vlookup? adimar	by adimar	8	551
vlookup? SteveDB1	by SteveDB1	0	322
error handling-need to get rid of a value returned as #N/A Gluefoot	by Michelle	2	594
I want to convert a formula to the actual number/verbage Sheryll from Connecticut	by MrAcquire	3	444
How can I use formula and format as it is, in the next rows? Niranjan	by Rick Rothstein \(MVP - VB\)[_7_]	1	435
Less than or equal to Alan K.	by Bob Phillips	2	410
Locate negative number BurtArkin	by BurtArkin	2	325
How to create a formula to calculate a sum of cells from a date ra RayRay	by Bob Phillips	4	367
Easy Input Ash	by T. Valko	1	416
networkdays and holidays TST	by TST	2	754
custom addin gives #name? errors bh1	by Dave Peterson	4	520
Entry takes 1 min, Office 2007. Large sheet O'Bake	by Niek Otten	1	381
Work days difference between 2 dates. Jeremy	by ryguy7272	7	753
auto-filter image jane	by ryguy7272	3	582
Marco Editing Help Gaffnr	by Don Guillett	9	571
Embedded If Limitation Gaffnr	by Bob Phillips	10	757
Countif Booman	by Pete_UK	3	372
Need to average clock times Tall Texan	by Dave Peterson	1	1,430
Copy from one named cell to another dependent on content of a third. Colin Hayes	by Colin Hayes	3	443
test Gaffnr	by Gaffnr	0	434
Stock Market Calculation Stock Market Calculation	by Ron Rosenfeld	2	1,078
named range in sum formula (indirect, offset, worksheet name) Hans	by Hans	4	1,150
Time series calculation RD Wirr	by Ron Rosenfeld	7	940
Formula henriques	by henriques	4	399
Have problem in Manipulating Workbook Object and make macro shortest as possible Irmann	by Irmann	0	355
Sort columns vwdrv1	by vwdrv1	8	458
How do I add "accrued vacation days" column to the Employee Attend Jam	by Jam	4	1,532
Problem with Data Validation George	by T. Valko	2	473
Formula bryannc	by FSt1	1	458
Moving Macros Cheri	by Cheri	2	427
excel 2007 Morfeo	by Morfeo	2	331
Counting on two separate values Leif	by Bob Phillips	5	515
Pivot Table and Calulated Field BerkshireGuy	by Roger Govier[_3_]	1	320
Use dynamic column reference without R1C1 Pontificateur	by T. Valko	3	1,846
counting data in columns with linked cells Bernie R.	by Roger Govier[_3_]	4	455
Time Calc 24 hrs Meebers	by Meebers	6	607
how do i use averageifs function? Lee	by T. Valko	2	438
Using cell content as reference in formula ptrip	by Max	14	1,125
Using formulas for survey snappl3	by Tyro[_2_]	1	485
look up formula Dee	by Conan Kelly	9	392
Excel Bugs rguerrie	by David Biddulph[_2_]	12	786
Changing number in cell when printing JLee	by Gord Dibben	2	484
want to use a barcode scanner in excell need formula "if" "then" ? clubman	by Thomas Lutz	3	1,592
How can I SUM all values in a column where the rows... JRThomas	by Gary''s Student	5	487
ISNA with VLOOKUP against 2 locations steph	by T. Valko	7	962
Conditional PAL	by Bernie Deitrick	6	402
CTRL+select Excel 2007 ripley	by Roger Govier[_3_]	5	1,850
named ranges Carol Ann	by Pete_UK	4	444
Adding number within a cell Jon A	by Peo Sjoblom	5	628
IF Statement Help Jcraig713	by CLR	4	331
Excel to pull data from web Bigpiggy	by ryguy7272	1	620
how do I get cells to automaticly change colour on data input? walltur	by Gav123	2	927
VLOOKUP with IF steph	by steph	7	459
Adding formulas across Worksheets Belle[_2_]	by Don Guillett	2	560
Excel Function Dries	by Max	5	387
VLOOKUP problem (N/V) Mortir	by Bob Phillips	7	566
Conditional Validation The Narcissist	by George	3	467
Multiple if functions with sum louisa	by Mike H	1	514
sum year to date totals for particular month irishrover	by Bob Phillips	1	1,633
Understanding SUMPRODUCT() Jakobshavn Isbrae	by Bob Phillips	18	985
Advanced filter a	by Max	1	365
using two functions in the same cell Brian204845	by T. Valko	6	1,109
"A+" convert to "4," "A-" to "3.7" etc... Kevin Stone	by Arvi Laanemets	3	690
split cells with each having a formula possible? drb	by T. Valko	4	362
if zero, then return blank/empty cls	by T. Valko	8	1,180
2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia Damon Longworth	by Damon Longworth	0	598
adding up vlookup values in one column and in between them observer	by T. Valko	13	1,068
how do we get gaussian distributuion parameters of a sequence Bursali	by Stan Brown	1	425
sumif sumif	by Dave Peterson	1	461
split cells with each having a formula possible? drb	by drb	0	505
How do I stop mouse from automatically selecting multiple cells Digger	by Tyro[_2_]	1	2,046
Need help with Excel 2000 text-related functions Joan A	by T. Valko	7	721
Date comparison adimar	by adimar	14	1,362
Excel 2007 Not Responding Terri	by [email protected]	10	1,330