Excel Worksheet Functions - Page 580

Thread / Thread Starter	Last Post	Replies	Views
Replace #VALUE! with contents of cell?? MOK	by Roger Govier	1	668
Pivot table: Custom "Summarize by" functions kestasjk	by Roger Govier	1	546
Conditional Formatting Padraigglynn	by Pete_UK	3	348
If total answer is over default of 160 then 160, otherwise the formula i have works great! [email protected]	by Pete_UK	6	392
separate alpabets & nembers shaqil	by David Biddulph[_2_]	1	360
How do I use a wildcard in an excel formula? Archon007	by Bob Davison	4	1,044
How to calculate EMi? Rathin	by joeu2004	2	876
how do you create a floating row? Jeff	by Fred Smith	1	2,609
=IF(AND(OR statement needed? bracket89	by Martin Fishlock	2	470
Vlookup rounding up rather than down Steve[_3_]	by Ron Rosenfeld	4	1,581
HELP! Unknown range Excel_Oz	by Roger Govier	3	595
Finding Cumulative Interest [email protected]	by Fred Smith	2	428
vba for selecting multiple sheets to save as a new book Sharon	by Sharon	5	3,711
Transpose Maybe? Dan Oakes	by Roger Govier	7	661
Only show certain columns Woda	by Dave Peterson	1	1,979
Worksheet does not copy Bruce Hancock	by Bruce Hancock[_2_]	9	592
Copy text from cell to cell with one cell changing text Bobby	by Bobby	5	857
Using list values as variable in secondary formulae... best way? [email protected]	by [email protected]	1	444
Counting cells with multiple selection ub	by Teethless mama	2	425
Count if multiple statements in two columns Motaad	by Sandy Mann	3	779
Formula Help William@Target[_2_]	by William@Target[_2_]	1	421
creating list hannatrip	by Gord Dibben	7	391
how to duplex mulitple sheets simultaneously? smegen	by plb2862	1	428
text lists - begin typing names jtaiariol	by Anne Troy[_2_]	1	1,203
CountIF Function ub	by ub	3	337
How do I stop Excel from progressing a formula in fill down or rig mbaysden	by mbaysden	2	2,149
Unwanted spaces Loren	by Sandy Mann	3	447
Sharing info across 2 workbooks S Willingham	by S Willingham	18	1,222
Why doesn't Print Preview doesn't show everything correctly? Meenie	by Meenie	0	1,279
Active cell as a reference to open a worksheet LaDdIe	by Gord Dibben	6	713
66,000 excel record limit [email protected]	by Gord Dibben	4	808
Can not insert sheet??? S Davis	by S Davis	2	2,134
cell reference "values only" Shooter	by S Davis	2	3,041
using vlookup Rick[_2_]	by T. Valko	7	375
Sumproduct Multiple < Conditions undrline via OfficeKB.com	by undrline via OfficeKB.com	4	666
Using Exact() with VLookup or Match mikelee101	by T. Valko	6	866
Save As - Before Save Event, VB, another name Danny	by Danny	0	422
how do I round up to the nearest nickel? Melanie	by Teethless mama	2	534
Creating Work Weeks Gallego	by Teethless mama	1	536
Automatic creation of worksheets dave	by dave	2	529
Statement writing problem Clay	by Clay	4	440
Time array Richard	by Richard	6	416
Date to Text Terence	by RichardSchollar[_2_]	1	444
Highlight duplicate entries matching 2 criteria in another workshe RS	by Max	12	1,024
Same Format!! Sunil Bhatt	by Duke Carey	1	338
Help with VBA, or maybe vanilla Excel function? Zilla[_2_]	by Toppers	1	586
Average array hmm	by Roger Govier	5	770
creating an array Richard	by Tom Ogilvy	4	456
If And statements -- HELP! GI JOE	by Sandy Mann	8	565
eomonth John T[_2_]	by Gary Brown	3	467
Creating a formula calculates time impact on achieveing sales quota Khaledity	by vezerid	1	1,021
I want to delete duplicate in one time [email protected]	by JLatham	2	437
GROWTH too aggressive, TREND too conservative - what to do? Brett L.	by Jerry W. Lewis	2	362
How do I automatically copy data from one sheet to another? DonnaO	by Duke Carey	1	905
How do I import external data and create two formats? Renny03	by Joel	1	439
entering 1 cell fills the worksheet CaitlinC Pro Honda	by Max	1	491
Problems with HLOOKUP and VLOOKUP Frank	by Max	1	626
Automatic Filter Options jrw	by Max	1	541
Automatic Filter Options jrw	by Max	1	511
Creating a formula JonathanW	by T. Valko	1	352
Ranking Function casdaq	by T. Valko	4	803
vijay 5 vijaydsk1970	by vijaydsk1970	2	427
Creating a sliding scale discount JonathanW	by Teethless mama	1	3,578
Syntax for using variables in a cell formula to reference paths/fi colorado808	by colorado808	4	1,006
VLookup Functions Monica	by Monica	2	514
synchronize between sheets Habatz	by Habatz	0	832
Conditional Formatting for Formula Cells Vibeke	by T. Valko	10	700
how do i create a drop-down list using workbooks? Mako	by Gary''s Student	1	369
Creating a long string of text... AlieSlavin	by AlieSlavin	5	861
have excel go to defined cells when pressing enter rrg	by rrg	4	2,009
Sumproduct Function Question mjones	by mjones	4	382
A different look at VLOOKUP Bigfoot17	by Don Guillett	12	798
Saving without deleting previous input kdmarvin	by Roger Govier	10	796
3D References Mode() Function Excel the-big-john[_2_]	by Harlan Grove[_2_]	1	809
Alternate footers Bee	by Bee	3	416