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	505
Sumproduct with Match and Vlookup? adimar	by adimar	8	539
vlookup? SteveDB1	by SteveDB1	0	316
error handling-need to get rid of a value returned as #N/A Gluefoot	by Michelle	2	581
I want to convert a formula to the actual number/verbage Sheryll from Connecticut	by MrAcquire	3	425
How can I use formula and format as it is, in the next rows? Niranjan	by Rick Rothstein \(MVP - VB\)[_7_]	1	414
Less than or equal to Alan K.	by Bob Phillips	2	399
Locate negative number BurtArkin	by BurtArkin	2	318
How to create a formula to calculate a sum of cells from a date ra RayRay	by Bob Phillips	4	346
Easy Input Ash	by T. Valko	1	392
networkdays and holidays TST	by TST	2	742
custom addin gives #name? errors bh1	by Dave Peterson	4	504
Entry takes 1 min, Office 2007. Large sheet O'Bake	by Niek Otten	1	373
Work days difference between 2 dates. Jeremy	by ryguy7272	7	733
auto-filter image jane	by ryguy7272	3	567
Marco Editing Help Gaffnr	by Don Guillett	9	557
Embedded If Limitation Gaffnr	by Bob Phillips	10	734
Countif Booman	by Pete_UK	3	364
Need to average clock times Tall Texan	by Dave Peterson	1	1,412
Copy from one named cell to another dependent on content of a third. Colin Hayes	by Colin Hayes	3	417
test Gaffnr	by Gaffnr	0	423
Stock Market Calculation Stock Market Calculation	by Ron Rosenfeld	2	1,064
named range in sum formula (indirect, offset, worksheet name) Hans	by Hans	4	1,121
Time series calculation RD Wirr	by Ron Rosenfeld	7	922
Formula henriques	by henriques	4	394
Have problem in Manipulating Workbook Object and make macro shortest as possible Irmann	by Irmann	0	349
Sort columns vwdrv1	by vwdrv1	8	454
How do I add "accrued vacation days" column to the Employee Attend Jam	by Jam	4	1,461
Problem with Data Validation George	by T. Valko	2	452
Formula bryannc	by FSt1	1	452
Moving Macros Cheri	by Cheri	2	411
excel 2007 Morfeo	by Morfeo	2	328
Counting on two separate values Leif	by Bob Phillips	5	492
Pivot Table and Calulated Field BerkshireGuy	by Roger Govier[_3_]	1	319
Use dynamic column reference without R1C1 Pontificateur	by T. Valko	3	1,822
counting data in columns with linked cells Bernie R.	by Roger Govier[_3_]	4	448
Time Calc 24 hrs Meebers	by Meebers	6	589
how do i use averageifs function? Lee	by T. Valko	2	416
Using cell content as reference in formula ptrip	by Max	14	1,103
Using formulas for survey snappl3	by Tyro[_2_]	1	475
look up formula Dee	by Conan Kelly	9	389
Excel Bugs rguerrie	by David Biddulph[_2_]	12	760
Changing number in cell when printing JLee	by Gord Dibben	2	475
want to use a barcode scanner in excell need formula "if" "then" ? clubman	by Thomas Lutz	3	1,518
How can I SUM all values in a column where the rows... JRThomas	by Gary''s Student	5	455
ISNA with VLOOKUP against 2 locations steph	by T. Valko	7	957
Conditional PAL	by Bernie Deitrick	6	395
CTRL+select Excel 2007 ripley	by Roger Govier[_3_]	5	1,824
named ranges Carol Ann	by Pete_UK	4	428
Adding number within a cell Jon A	by Peo Sjoblom	5	609
IF Statement Help Jcraig713	by CLR	4	328
Excel to pull data from web Bigpiggy	by ryguy7272	1	603
how do I get cells to automaticly change colour on data input? walltur	by Gav123	2	889
VLOOKUP with IF steph	by steph	7	456
Adding formulas across Worksheets Belle[_2_]	by Don Guillett	2	538
Excel Function Dries	by Max	5	383
VLOOKUP problem (N/V) Mortir	by Bob Phillips	7	546
Conditional Validation The Narcissist	by George	3	443
Multiple if functions with sum louisa	by Mike H	1	491
sum year to date totals for particular month irishrover	by Bob Phillips	1	1,616
Understanding SUMPRODUCT() Jakobshavn Isbrae	by Bob Phillips	18	961
Advanced filter a	by Max	1	363
using two functions in the same cell Brian204845	by T. Valko	6	1,103
"A+" convert to "4," "A-" to "3.7" etc... Kevin Stone	by Arvi Laanemets	3	687
split cells with each having a formula possible? drb	by T. Valko	4	347
if zero, then return blank/empty cls	by T. Valko	8	1,161
2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia Damon Longworth	by Damon Longworth	0	571
adding up vlookup values in one column and in between them observer	by T. Valko	13	1,034
how do we get gaussian distributuion parameters of a sequence Bursali	by Stan Brown	1	417
sumif sumif	by Dave Peterson	1	453
split cells with each having a formula possible? drb	by drb	0	474
How do I stop mouse from automatically selecting multiple cells Digger	by Tyro[_2_]	1	2,000
Need help with Excel 2000 text-related functions Joan A	by T. Valko	7	699
Date comparison adimar	by adimar	14	1,340
Excel 2007 Not Responding Terri	by [email protected]	10	1,309