Excel Worksheet Functions - Page 551

Thread / Thread Starter	Last Post	Replies	Views
2 ?, Size and copying? Johnz414	by Johnz414	0	322
Calculating number of weeks between dates? John[_12_]	by Teethless mama	2	1,500
Right clicking to summon Format Cells. John[_14_]	by Pete_UK	3	892
Custom Headers and Footers John[_17_]	by John[_17_]	2	468
Double Match - version 2 John[_21_]	by Max	5	468
Double Match John[_21_]	by Max	6	735
Dynamic Sheet Name in Vlookup John[_21_]	by John[_21_]	6	1,562
Nested IF or( If And ) can't get it to work John[_22_]	by John[_22_]	2	391
To Mr. T. Valko John[_22_]	by T. Valko	5	511
Nested formulas John[_22_]	by John[_22_]	8	546
Three same Formulas John[_22_]	by Spiky	2	386
To All you Senior Guys out there. John[_22_]	by John[_22_]	7	393
#Div/0 error, can't get rid of it John[_22_]	by John[_22_]	8	681
Remove Multiple Contexts? John[_23_]	by John[_23_]	0	416
vat formula John[_25_]	by ob-server	2	548
Creating cell names from cell contents en masse John[_26_]	by Simon Lloyd[_236_]	1	481
Using a variable to point to a location John[_29_]	by John[_29_]	2	618
Getting same number to appear over and again John[_2_]	by MartinW	2	351
Using Excel in Formatted Output John[_31_]	by John[_31_]	2	742
Permutations John[_33_]	by John[_33_]	2	522
Lookups John[_5_]	by John[_5_]	4	515
Calculating Time from Speed and Distance? John[_6_]	by ExcelBanter AI	4	15,787
Displaying hours and minutes John[_6_]	by John[_6_]	3	693
Does a number exist in a range John[_9_]	by Vasant Nanavati	3	488
Using Excel as an actively linked workbook in Access John_A	by John_A	0	356
How to make excell ignore non-whole numbers John_Doe69	by John_Doe69	5	639
Four criteria MATCH INDEX lookup of date between matching two text John_J	by John_J	9	1,651
Count occurances of equal values in two col. - array within SUMPRO John_J	by Domenic[_2_]	5	927
"COUNTIF(AND" John_Lamb	by John_Lamb	4	1,426
IF statement pulling from Product List Johosh	by RagDyeR	5	480
Problems with VLOOKUP Johosh	by CIL	2	774
Fun with COUNT and AND functions. Johosh	by Ron Coderre	8	516
how to multiply h:mm value by an hourly $ rate Johstra	by barnabel	2	900
two cases for countif joi2	by Peo Sjoblom	1	391
office web components joia	by Michael Vardinghus	2	528
If function with more than 7 conditions joie	by Roger Govier	3	1,581
minimum from various columns without zeroes joie	by Peo Sjoblom	5	476
working with data Joikochan	by JMB	8	319
total a range of cells in Excel into a different worksheet Joint Council	by Joint Council	2	541
Leave cell data (IF(ISNA(VLOOKUP) is TRUE instead of returning blank (" ") or #NA [email protected]	by Arvi Laanemets	6	3,026
Spreadsheet reference in formula? [email protected]	by [email protected]	2	761
Delete options for AutoFilter? Jojjjo	by Jojjjo	2	435
To copy fomula jojo	by WDI	7	680
sort sheet tabs in Excel JOJO	by Norman Jones	2	626
solver constraint jojo	by jojo	0	1,056
help in excel jojo	by Bernard Liengme	8	427
how can I find out a total as a percentage using absolute cell JoJo	by Fred Smith	1	829
error message that says "too many different formats" Fix? JoJo	by Mike H	1	1,028
Save spreadsheet as webPage with interactivity JoJo	by JoJo	0	433
Autofill a Sheet Reference JOJO193	by David McRitchie	7	983
Auto generate invoices JOJO193	by Bushra Singh	1	1,089
Auto-fill a sheet reference JOJO193	by mcgrata	5	1,625
link worksheets by proper identificaton from master jojocuda06	by Ashish Mathur[_2_]	2	466
Capitalizing first word only... jojojpinkerton	by David McRitchie	4	650
Pivot Chart [email protected]	by Roger Govier[_3_]	1	337
Round 1.45 down to 1.25 and 1.57 down to 1.50 joker007	by joker007	2	608
Converting mm/dd/yyyy to yyyy/mm/dd [email protected]	by Ron Rosenfeld	6	796
Calculate negative hours (time) Jolanta	by Jolanta	7	868
The FV function Jolanta	by stew	8	443
Is there a way to use the space bar to delete? Jolene	by Jolene	0	677
Is there a way to use the space bar to delete? Jolene	by Niek Otten	1	852
AutoFilters Joli	by GaryE	1	447
Cell format will not update Joll	by HARSHAWARDHAN. S .SHASTRI[_2_]	1	957
Can you use the validate function in a data form in Excel? Jolly	by Jolly	0	625
circular formula gives different values jolly	by Luke M[_4_]	1	598
Office 2003 Excel funtion - data table Jolly	by Ashish Mathur[_2_]	3	520
Offset function gives different answer in columns v Rows Jolly	by Jolly	6	796
How can I choose more than one item from list in a form in Excel? Jolly	by Rick Rothstein $MVP - VB$[_909_]	7	822
Worksheets with OFFSET command always ask if I want to SAVE Jolly good Delaware lad	by JE McGimpsey	2	476
Status Bar Configuration area Jolly Jolly	by Ron Coderre	3	686
Colour cell when number changes Jolly Roger	by Gord Dibben	6	492
macro for "entering data" Jolly Rogers	by Jolly Rogers	4	618
How do I Calculate PI in an Excel formula? jollydottie	by Dana DeLouis	22	4,604
Very Basic Problem - Merged Cell Equals Contents of a Single Cell jollynicechap	by jollynicechap	3	3,894
Report one value out of a range jollyr	by jollyr	2	521