Excel Worksheet Functions - Page 294

Thread / Thread Starter	Last Post	Replies	Views
I need help with formula sopranoiam	by David Biddulph[_2_]	3	409
generate automatically sum Luchian	by Pete_UK	6	500
average in non-continuous set, excluding blanks JJ	by JJ	6	1,153
Split one worksheet to multiple Carolina Girl	by Thomas [PBD]	1	665
average with formula in cells BNT1 via OfficeKB.com	by Sheeloo[_2_]	13	858
How to convert date to YYQN Christine[_3_]	by John C[_2_]	3	313
Weighted average with changing weights… l[_2_]	by Bernie Deitrick	1	525
How to return the last non-blank cell in a column that is TEXT VSlaybaugh	by RagDyeR	6	1,299
Find a phrase in a string and convert it to a number X-Ray	by Ron Rosenfeld	5	914
A transportable solution using Data Connection Libraries in ShareP Jason Wilson	by Jason Wilson	0	419
German versions of the US keyboard shortcuts dienutz	by dienutz	0	1,029
Sum() formula with Text Mike H.	by Richard Schollar[_2_]	1	451
Countif in non adjacent columns mickjjuk	by mickjjuk	3	864
Need to match 2 columns, if a match found add info from 2nd column Stratton	by Max	1	1,144
If( AND( with VLOOKUP.... jane	by John C[_2_]	4	395
Merge and Sort 2 Worksheets dc059	by dc059	0	516
Add cell in every 7th column Igorin	by David Biddulph[_2_]	9	839
Formula for Angle of triangle from opposite and adjacent lengths Mustavagander	by David Biddulph[_2_]	1	2,371
Excel 2003 Andrew	by Andrew	0	386
Rounding whole numbers Bob	by T. Valko	6	520
EXCEL Spreadsheets and Multiple Users. Radio Producer	by RyGuy	1	386
Renaming Multiple Tabs britt@wjg	by Sheeloo[_2_]	1	526
Data list NWO	by NWO	2	526
Subtracting first and last values in a row to find net difference Tropikat	by Mike H	10	996
Sumproduct - use of some characters MrRJ	by T. Valko	10	794
Summing multiple rows if criteria bsl	by John C[_2_]	5	707
SUMIF and list of possible critieria blswes	by Bob Phillips[_3_]	2	875
lookup multiple search criteria but only return a value if both tr se7098	by se7098	8	761
Sum of Yes Response JohnR[_2_]	by John C[_2_]	8	912
Locked Cells PAL	by Gaurav[_4_]	1	402
Sumproduct dvision MrRJ	by MrRJ	14	770
Count and Sum function WT	by WT	2	455
Excel - Sorting for Duplicate Records jen	by JP[_4_]	1	424
Odd Numbers BinaryOrc	by Mike H	5	572
Variable file reference Michael	by Michael	2	502
Background Color for selected range Glyn[_2_]	by Gord Dibben	7	488
using vlookup to delete duplicate data carolj	by carolj	4	2,622
Sum Function that does not include 0 Txlonghorn76	by John C[_2_]	15	895
Data Entry Giles	by Peo Sjoblom[_2_]	2	285
How do i add a function button to a worksheet? TammyMarie	by Gord Dibben	3	440
help in If error Raz	by Raz	3	403
How do I change this to count days H Halliburton	by Sean Timmons	1	424
Excel 2000 Question Mojo	by Bernie Deitrick	1	436
SUMPRODUCT and finding text within a cell tigger	by tigger	6	782
COMO ESCRIBO UN NOMBRE EN UNA FORMULA OBA	by David Biddulph[_2_]	1	606
Sum automatically every cell in multiple rows Luchian	by Luchian	1	473
column freeze kurt dobler	by David Biddulph[_2_]	1	463
how to delete an excel line based on a condition The cricket	by Roger Govier[_3_]	2	406
How to link option box Karen	by Roger Govier[_3_]	1	400
Adding and subtraction Murray	by Pete_UK	2	529
Adding sum of "yes" JohnR[_2_]	by Max	6	565
Vlookup With Multiple Instances in Data Table [email protected]	by Charles Williams	5	705
removing duplicate data from a single list Brad	by Sheeloo[_2_]	1	644
Auto Sum Larry	by Larry	0	316
How to use or < in LOOKUP formula? CC	by JMB	1	355
Finding matching numbers in different rows. classic3283	by Sheeloo[_2_]	1	650
Minimum value look up [email protected]	by T. Valko	3	552
Row?? j.ruderman[_2_]	by j.ruderman[_2_]	8	368
Copying a block of cells so that it updates automatically Kiersten L	by Gord Dibben	2	474
Importing multiple lines into Excel from txt. EricB	by Gord Dibben	3	975
extract characters from filename Steve[_16_]	by Steve[_16_]	7	607
Copying sheets j.ruderman[_2_]	by TomPl	1	410
Referncing Rows of Filtered Data Mark T.	by JMB	8	636
2 VB Questions JRD-CFW[_2_]	by TomPl	2	363
Average price between dates PaulinaDi	by PaulinaDi	9	468
Marking page end lucy	by Gord Dibben	2	465
"If" formula Needing help at new job	by Sean Timmons	6	328
IF AND ISTEXT ISBLANK formula SCrowley	by Sean Timmons	5	1,128
Moving completed row to another worksheet Doehead	by Doehead	2	497
Using Vlookup and If functions simultaneously Vlookup and If	by Sean Timmons	3	1,164
optional calculations roger_the_dodger	by Sean Timmons	1	442
Conditional Sum Herb	by Herb	6	392
I'm trying to add columns and getting errors Kimb	by muddan madhu	2	360
If Function combined with OR and LEFT JRJ	by T. Valko	4	743
Copy Rows with a cell value 0 from several worksheets to a new sh Skeletor	by Max	1	409