Excel Worksheet Functions - Page 580

Thread / Thread Starter	Last Post	Replies	Views
Replace #VALUE! with contents of cell?? MOK	by Roger Govier	1	680
Pivot table: Custom "Summarize by" functions kestasjk	by Roger Govier	1	558
Conditional Formatting Padraigglynn	by Pete_UK	3	357
If total answer is over default of 160 then 160, otherwise the formula i have works great! [email protected]	by Pete_UK	6	394
separate alpabets & nembers shaqil	by David Biddulph[_2_]	1	361
How do I use a wildcard in an excel formula? Archon007	by Bob Davison	4	1,062
How to calculate EMi? Rathin	by joeu2004	2	884
how do you create a floating row? Jeff	by Fred Smith	1	2,621
=IF(AND(OR statement needed? bracket89	by Martin Fishlock	2	482
Vlookup rounding up rather than down Steve[_3_]	by Ron Rosenfeld	4	1,594
HELP! Unknown range Excel_Oz	by Roger Govier	3	598
Finding Cumulative Interest [email protected]	by Fred Smith	2	434
vba for selecting multiple sheets to save as a new book Sharon	by Sharon	5	3,716
Transpose Maybe? Dan Oakes	by Roger Govier	7	673
Only show certain columns Woda	by Dave Peterson	1	1,989
Worksheet does not copy Bruce Hancock	by Bruce Hancock[_2_]	9	599
Copy text from cell to cell with one cell changing text Bobby	by Bobby	5	871
Using list values as variable in secondary formulae... best way? [email protected]	by [email protected]	1	447
Counting cells with multiple selection ub	by Teethless mama	2	428
Count if multiple statements in two columns Motaad	by Sandy Mann	3	784
Formula Help William@Target[_2_]	by William@Target[_2_]	1	424
creating list hannatrip	by Gord Dibben	7	407
how to duplex mulitple sheets simultaneously? smegen	by plb2862	1	440
text lists - begin typing names jtaiariol	by Anne Troy[_2_]	1	1,207
CountIF Function ub	by ub	3	352
How do I stop Excel from progressing a formula in fill down or rig mbaysden	by mbaysden	2	2,165
Unwanted spaces Loren	by Sandy Mann	3	458
Sharing info across 2 workbooks S Willingham	by S Willingham	18	1,226
Why doesn't Print Preview doesn't show everything correctly? Meenie	by Meenie	0	1,284
Active cell as a reference to open a worksheet LaDdIe	by Gord Dibben	6	715
66,000 excel record limit [email protected]	by Gord Dibben	4	810
Can not insert sheet??? S Davis	by S Davis	2	2,140
cell reference "values only" Shooter	by S Davis	2	3,052
using vlookup Rick[_2_]	by T. Valko	7	390
Sumproduct Multiple < Conditions undrline via OfficeKB.com	by undrline via OfficeKB.com	4	677
Using Exact() with VLookup or Match mikelee101	by T. Valko	6	876
Save As - Before Save Event, VB, another name Danny	by Danny	0	432
how do I round up to the nearest nickel? Melanie	by Teethless mama	2	543
Creating Work Weeks Gallego	by Teethless mama	1	546
Automatic creation of worksheets dave	by dave	2	530
Statement writing problem Clay	by Clay	4	440
Time array Richard	by Richard	6	427
Date to Text Terence	by RichardSchollar[_2_]	1	454
Highlight duplicate entries matching 2 criteria in another workshe RS	by Max	12	1,029
Same Format!! Sunil Bhatt	by Duke Carey	1	351
Help with VBA, or maybe vanilla Excel function? Zilla[_2_]	by Toppers	1	593
Average array hmm	by Roger Govier	5	783
creating an array Richard	by Tom Ogilvy	4	465
If And statements -- HELP! GI JOE	by Sandy Mann	8	570
eomonth John T[_2_]	by Gary Brown	3	468
Creating a formula calculates time impact on achieveing sales quota Khaledity	by vezerid	1	1,023
I want to delete duplicate in one time [email protected]	by JLatham	2	449
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	916
How do I import external data and create two formats? Renny03	by Joel	1	449
entering 1 cell fills the worksheet CaitlinC Pro Honda	by Max	1	491
Problems with HLOOKUP and VLOOKUP Frank	by Max	1	631
Automatic Filter Options jrw	by Max	1	553
Automatic Filter Options jrw	by Max	1	525
Creating a formula JonathanW	by T. Valko	1	363
Ranking Function casdaq	by T. Valko	4	811
vijay 5 vijaydsk1970	by vijaydsk1970	2	428
Creating a sliding scale discount JonathanW	by Teethless mama	1	3,585
Syntax for using variables in a cell formula to reference paths/fi colorado808	by colorado808	4	1,008
VLookup Functions Monica	by Monica	2	526
synchronize between sheets Habatz	by Habatz	0	839
Conditional Formatting for Formula Cells Vibeke	by T. Valko	10	712
how do i create a drop-down list using workbooks? Mako	by Gary''s Student	1	373
Creating a long string of text... AlieSlavin	by AlieSlavin	5	865
have excel go to defined cells when pressing enter rrg	by rrg	4	2,015
Sumproduct Function Question mjones	by mjones	4	389
A different look at VLOOKUP Bigfoot17	by Don Guillett	12	804
Saving without deleting previous input kdmarvin	by Roger Govier	10	808
3D References Mode() Function Excel the-big-john[_2_]	by Harlan Grove[_2_]	1	815
Alternate footers Bee	by Bee	3	423