Excel Worksheet Functions - Page 294

Thread / Thread Starter	Last Post	Replies	Views
I need help with formula sopranoiam	by David Biddulph[_2_]	3	405
generate automatically sum Luchian	by Pete_UK	6	491
average in non-continuous set, excluding blanks JJ	by JJ	6	1,136
Split one worksheet to multiple Carolina Girl	by Thomas [PBD]	1	659
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	523
How to return the last non-blank cell in a column that is TEXT VSlaybaugh	by RagDyeR	6	1,283
Find a phrase in a string and convert it to a number X-Ray	by Ron Rosenfeld	5	908
A transportable solution using Data Connection Libraries in ShareP Jason Wilson	by Jason Wilson	0	416
German versions of the US keyboard shortcuts dienutz	by dienutz	0	967
Sum() formula with Text Mike H.	by Richard Schollar[_2_]	1	446
Countif in non adjacent columns mickjjuk	by mickjjuk	3	854
Need to match 2 columns, if a match found add info from 2nd column Stratton	by Max	1	1,102
If( AND( with VLOOKUP.... jane	by John C[_2_]	4	373
Merge and Sort 2 Worksheets dc059	by dc059	0	511
Add cell in every 7th column Igorin	by David Biddulph[_2_]	9	831
Formula for Angle of triangle from opposite and adjacent lengths Mustavagander	by David Biddulph[_2_]	1	2,357
Excel 2003 Andrew	by Andrew	0	381
Rounding whole numbers Bob	by T. Valko	6	511
EXCEL Spreadsheets and Multiple Users. Radio Producer	by RyGuy	1	382
Renaming Multiple Tabs britt@wjg	by Sheeloo[_2_]	1	511
Data list NWO	by NWO	2	518
Subtracting first and last values in a row to find net difference Tropikat	by Mike H	10	984
Sumproduct - use of some characters MrRJ	by T. Valko	10	787
Summing multiple rows if criteria bsl	by John C[_2_]	5	702
SUMIF and list of possible critieria blswes	by Bob Phillips[_3_]	2	865
lookup multiple search criteria but only return a value if both tr se7098	by se7098	8	723
Sum of Yes Response JohnR[_2_]	by John C[_2_]	8	899
Locked Cells PAL	by Gaurav[_4_]	1	393
Sumproduct dvision MrRJ	by MrRJ	14	766
Count and Sum function WT	by WT	2	438
Excel - Sorting for Duplicate Records jen	by JP[_4_]	1	404
Odd Numbers BinaryOrc	by Mike H	5	567
Variable file reference Michael	by Michael	2	482
Background Color for selected range Glyn[_2_]	by Gord Dibben	7	479
using vlookup to delete duplicate data carolj	by carolj	4	2,613
Sum Function that does not include 0 Txlonghorn76	by John C[_2_]	15	884
Data Entry Giles	by Peo Sjoblom[_2_]	2	282
How do i add a function button to a worksheet? TammyMarie	by Gord Dibben	3	433
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	420
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	598
Sum automatically every cell in multiple rows Luchian	by Luchian	1	469
column freeze kurt dobler	by David Biddulph[_2_]	1	458
how to delete an excel line based on a condition The cricket	by Roger Govier[_3_]	2	392
How to link option box Karen	by Roger Govier[_3_]	1	392
Adding and subtraction Murray	by Pete_UK	2	518
Adding sum of "yes" JohnR[_2_]	by Max	6	562
Vlookup With Multiple Instances in Data Table [email protected]	by Charles Williams	5	694
removing duplicate data from a single list Brad	by Sheeloo[_2_]	1	625
Auto Sum Larry	by Larry	0	311
How to use or < in LOOKUP formula? CC	by JMB	1	346
Finding matching numbers in different rows. classic3283	by Sheeloo[_2_]	1	633
Minimum value look up [email protected]	by T. Valko	3	546
Row?? j.ruderman[_2_]	by j.ruderman[_2_]	8	363
Copying a block of cells so that it updates automatically Kiersten L	by Gord Dibben	2	459
Importing multiple lines into Excel from txt. EricB	by Gord Dibben	3	936
extract characters from filename Steve[_16_]	by Steve[_16_]	7	597
Copying sheets j.ruderman[_2_]	by TomPl	1	392
Referncing Rows of Filtered Data Mark T.	by JMB	8	609
2 VB Questions JRD-CFW[_2_]	by TomPl	2	358
Average price between dates PaulinaDi	by PaulinaDi	9	456
Marking page end lucy	by Gord Dibben	2	453
"If" formula Needing help at new job	by Sean Timmons	6	320
IF AND ISTEXT ISBLANK formula SCrowley	by Sean Timmons	5	1,120
Moving completed row to another worksheet Doehead	by Doehead	2	478
Using Vlookup and If functions simultaneously Vlookup and If	by Sean Timmons	3	1,157
optional calculations roger_the_dodger	by Sean Timmons	1	429
Conditional Sum Herb	by Herb	6	386
I'm trying to add columns and getting errors Kimb	by muddan madhu	2	353
If Function combined with OR and LEFT JRJ	by T. Valko	4	737
Copy Rows with a cell value 0 from several worksheets to a new sh Skeletor	by Max	1	400