Excel Worksheet Functions - Page 294

Thread / Thread Starter	Last Post	Replies	Views
I need help with formula sopranoiam	by David Biddulph[_2_]	3	401
generate automatically sum Luchian	by Pete_UK	6	490
average in non-continuous set, excluding blanks JJ	by JJ	6	1,135
Split one worksheet to multiple Carolina Girl	by Thomas [PBD]	1	655
average with formula in cells BNT1 via OfficeKB.com	by Sheeloo[_2_]	13	854
How to convert date to YYQN Christine[_3_]	by John C[_2_]	3	307
Weighted average with changing weights… l[_2_]	by Bernie Deitrick	1	515
How to return the last non-blank cell in a column that is TEXT VSlaybaugh	by RagDyeR	6	1,282
Find a phrase in a string and convert it to a number X-Ray	by Ron Rosenfeld	5	904
A transportable solution using Data Connection Libraries in ShareP Jason Wilson	by Jason Wilson	0	413
German versions of the US keyboard shortcuts dienutz	by dienutz	0	965
Sum() formula with Text Mike H.	by Richard Schollar[_2_]	1	441
Countif in non adjacent columns mickjjuk	by mickjjuk	3	853
Need to match 2 columns, if a match found add info from 2nd column Stratton	by Max	1	1,099
If( AND( with VLOOKUP.... jane	by John C[_2_]	4	373
Merge and Sort 2 Worksheets dc059	by dc059	0	510
Add cell in every 7th column Igorin	by David Biddulph[_2_]	9	828
Formula for Angle of triangle from opposite and adjacent lengths Mustavagander	by David Biddulph[_2_]	1	2,352
Excel 2003 Andrew	by Andrew	0	381
Rounding whole numbers Bob	by T. Valko	6	508
EXCEL Spreadsheets and Multiple Users. Radio Producer	by RyGuy	1	378
Renaming Multiple Tabs britt@wjg	by Sheeloo[_2_]	1	506
Data list NWO	by NWO	2	503
Subtracting first and last values in a row to find net difference Tropikat	by Mike H	10	982
Sumproduct - use of some characters MrRJ	by T. Valko	10	786
Summing multiple rows if criteria bsl	by John C[_2_]	5	701
SUMIF and list of possible critieria blswes	by Bob Phillips[_3_]	2	862
lookup multiple search criteria but only return a value if both tr se7098	by se7098	8	720
Sum of Yes Response JohnR[_2_]	by John C[_2_]	8	889
Locked Cells PAL	by Gaurav[_4_]	1	390
Sumproduct dvision MrRJ	by MrRJ	14	764
Count and Sum function WT	by WT	2	437
Excel - Sorting for Duplicate Records jen	by JP[_4_]	1	403
Odd Numbers BinaryOrc	by Mike H	5	564
Variable file reference Michael	by Michael	2	481
Background Color for selected range Glyn[_2_]	by Gord Dibben	7	474
using vlookup to delete duplicate data carolj	by carolj	4	2,594
Sum Function that does not include 0 Txlonghorn76	by John C[_2_]	15	878
Data Entry Giles	by Peo Sjoblom[_2_]	2	282
How do i add a function button to a worksheet? TammyMarie	by Gord Dibben	3	431
help in If error Raz	by Raz	3	391
How do I change this to count days H Halliburton	by Sean Timmons	1	406
Excel 2000 Question Mojo	by Bernie Deitrick	1	418
SUMPRODUCT and finding text within a cell tigger	by tigger	6	778
COMO ESCRIBO UN NOMBRE EN UNA FORMULA OBA	by David Biddulph[_2_]	1	595
Sum automatically every cell in multiple rows Luchian	by Luchian	1	467
column freeze kurt dobler	by David Biddulph[_2_]	1	457
how to delete an excel line based on a condition The cricket	by Roger Govier[_3_]	2	391
How to link option box Karen	by Roger Govier[_3_]	1	389
Adding and subtraction Murray	by Pete_UK	2	517
Adding sum of "yes" JohnR[_2_]	by Max	6	562
Vlookup With Multiple Instances in Data Table [email protected]	by Charles Williams	5	693
removing duplicate data from a single list Brad	by Sheeloo[_2_]	1	624
Auto Sum Larry	by Larry	0	310
How to use or < in LOOKUP formula? CC	by JMB	1	345
Finding matching numbers in different rows. classic3283	by Sheeloo[_2_]	1	628
Minimum value look up [email protected]	by T. Valko	3	540
Row?? j.ruderman[_2_]	by j.ruderman[_2_]	8	360
Copying a block of cells so that it updates automatically Kiersten L	by Gord Dibben	2	455
Importing multiple lines into Excel from txt. EricB	by Gord Dibben	3	914
extract characters from filename Steve[_16_]	by Steve[_16_]	7	591
Copying sheets j.ruderman[_2_]	by TomPl	1	390
Referncing Rows of Filtered Data Mark T.	by JMB	8	602
2 VB Questions JRD-CFW[_2_]	by TomPl	2	354
Average price between dates PaulinaDi	by PaulinaDi	9	455
Marking page end lucy	by Gord Dibben	2	448
"If" formula Needing help at new job	by Sean Timmons	6	319
IF AND ISTEXT ISBLANK formula SCrowley	by Sean Timmons	5	1,116
Moving completed row to another worksheet Doehead	by Doehead	2	476
Using Vlookup and If functions simultaneously Vlookup and If	by Sean Timmons	3	1,153
optional calculations roger_the_dodger	by Sean Timmons	1	428
Conditional Sum Herb	by Herb	6	383
I'm trying to add columns and getting errors Kimb	by muddan madhu	2	348
If Function combined with OR and LEFT JRJ	by T. Valko	4	736
Copy Rows with a cell value 0 from several worksheets to a new sh Skeletor	by Max	1	396