Excel Worksheet Functions - Page 580

Thread / Thread Starter	Last Post	Replies	Views
Replace #VALUE! with contents of cell?? MOK	by Roger Govier	1	651
Pivot table: Custom "Summarize by" functions kestasjk	by Roger Govier	1	535
Conditional Formatting Padraigglynn	by Pete_UK	3	340
If total answer is over default of 160 then 160, otherwise the formula i have works great! [email protected]	by Pete_UK	6	376
separate alpabets & nembers shaqil	by David Biddulph[_2_]	1	355
How do I use a wildcard in an excel formula? Archon007	by Bob Davison	4	1,034
How to calculate EMi? Rathin	by joeu2004	2	864
how do you create a floating row? Jeff	by Fred Smith	1	2,592
=IF(AND(OR statement needed? bracket89	by Martin Fishlock	2	459
Vlookup rounding up rather than down Steve[_3_]	by Ron Rosenfeld	4	1,570
HELP! Unknown range Excel_Oz	by Roger Govier	3	568
Finding Cumulative Interest [email protected]	by Fred Smith	2	424
vba for selecting multiple sheets to save as a new book Sharon	by Sharon	5	3,672
Transpose Maybe? Dan Oakes	by Roger Govier	7	643
Only show certain columns Woda	by Dave Peterson	1	1,964
Worksheet does not copy Bruce Hancock	by Bruce Hancock[_2_]	9	563
Copy text from cell to cell with one cell changing text Bobby	by Bobby	5	826
Using list values as variable in secondary formulae... best way? [email protected]	by [email protected]	1	426
Counting cells with multiple selection ub	by Teethless mama	2	411
Count if multiple statements in two columns Motaad	by Sandy Mann	3	757
Formula Help William@Target[_2_]	by William@Target[_2_]	1	420
creating list hannatrip	by Gord Dibben	7	385
how to duplex mulitple sheets simultaneously? smegen	by plb2862	1	419
text lists - begin typing names jtaiariol	by Anne Troy[_2_]	1	1,195
CountIF Function ub	by ub	3	332
How do I stop Excel from progressing a formula in fill down or rig mbaysden	by mbaysden	2	2,098
Unwanted spaces Loren	by Sandy Mann	3	435
Sharing info across 2 workbooks S Willingham	by S Willingham	18	1,206
Why doesn't Print Preview doesn't show everything correctly? Meenie	by Meenie	0	1,266
Active cell as a reference to open a worksheet LaDdIe	by Gord Dibben	6	697
66,000 excel record limit [email protected]	by Gord Dibben	4	749
Can not insert sheet??? S Davis	by S Davis	2	2,113
cell reference "values only" Shooter	by S Davis	2	3,015
using vlookup Rick[_2_]	by T. Valko	7	373
Sumproduct Multiple < Conditions undrline via OfficeKB.com	by undrline via OfficeKB.com	4	647
Using Exact() with VLookup or Match mikelee101	by T. Valko	6	817
Save As - Before Save Event, VB, another name Danny	by Danny	0	411
how do I round up to the nearest nickel? Melanie	by Teethless mama	2	520
Creating Work Weeks Gallego	by Teethless mama	1	523
Automatic creation of worksheets dave	by dave	2	518
Statement writing problem Clay	by Clay	4	427
Time array Richard	by Richard	6	403
Date to Text Terence	by RichardSchollar[_2_]	1	433
Highlight duplicate entries matching 2 criteria in another workshe RS	by Max	12	1,006
Same Format!! Sunil Bhatt	by Duke Carey	1	335
Help with VBA, or maybe vanilla Excel function? Zilla[_2_]	by Toppers	1	576
Average array hmm	by Roger Govier	5	755
creating an array Richard	by Tom Ogilvy	4	448
If And statements -- HELP! GI JOE	by Sandy Mann	8	552
eomonth John T[_2_]	by Gary Brown	3	457
Creating a formula calculates time impact on achieveing sales quota Khaledity	by vezerid	1	1,008
I want to delete duplicate in one time [email protected]	by JLatham	2	431
GROWTH too aggressive, TREND too conservative - what to do? Brett L.	by Jerry W. Lewis	2	355
How do I automatically copy data from one sheet to another? DonnaO	by Duke Carey	1	895
How do I import external data and create two formats? Renny03	by Joel	1	437
entering 1 cell fills the worksheet CaitlinC Pro Honda	by Max	1	476
Problems with HLOOKUP and VLOOKUP Frank	by Max	1	614
Automatic Filter Options jrw	by Max	1	521
Automatic Filter Options jrw	by Max	1	484
Creating a formula JonathanW	by T. Valko	1	346
Ranking Function casdaq	by T. Valko	4	789
vijay 5 vijaydsk1970	by vijaydsk1970	2	425
Creating a sliding scale discount JonathanW	by Teethless mama	1	3,541
Syntax for using variables in a cell formula to reference paths/fi colorado808	by colorado808	4	984
VLookup Functions Monica	by Monica	2	500
synchronize between sheets Habatz	by Habatz	0	823
Conditional Formatting for Formula Cells Vibeke	by T. Valko	10	697
how do i create a drop-down list using workbooks? Mako	by Gary''s Student	1	352
Creating a long string of text... AlieSlavin	by AlieSlavin	5	852
have excel go to defined cells when pressing enter rrg	by rrg	4	1,987
Sumproduct Function Question mjones	by mjones	4	371
A different look at VLOOKUP Bigfoot17	by Don Guillett	12	790
Saving without deleting previous input kdmarvin	by Roger Govier	10	782
3D References Mode() Function Excel the-big-john[_2_]	by Harlan Grove[_2_]	1	790
Alternate footers Bee	by Bee	3	407