Excel Worksheet Functions - Page 402

Thread / Thread Starter	Last Post	Replies	Views
if, or AJ	by GoBow777	1	491
Can I create a pop-up box with terms to view a spreadsheet? eggens	by Jim Cone	2	751
How do I crate a function for week of year + year in same cell. patty ann	by Mike H	1	1,361
DGET/DSUM etc ron_b	by Debra Dalgleish	2	477
Sorting CF Color Johnny1r	by Max	3	498
Formula for assigning distinct name to first instance in a list ofduplicate rows. NickNameGoesHere	by Max	1	461
Excel Dropdown boxes from Home, Page Layout, Insert, etc desilu	by Shah Shailesh	1	1,462
references Bert[_2_]	by Stan Brown	2	386
using VLOOKUP for series data Automate	by Automate	3	849
'Flash' random numbers Jock	by L. Howard Kittle	6	671
Variable Worksheet Name in Formula pdberger	by L. Howard Kittle	4	2,355
Get rid of #VALUE, after multiplying kbouquet	by T. Valko	1	1,605
How to make Same formula over multiple rows but still holds row # BallySuperTech	by Don Guillett	1	1,855
How do I put worksheets in a workbook in alpha order in 1 step Lynette	by Dave Peterson	1	709
Conditional Formatting Excel 2007 yelnocer	by T. Valko	1	787
automatically show date day by day Bruno	by JLatham	5	588
Help on macro coding for URL Eric	by Don Guillett	2	574
select printer macro jatman	by JLatham	1	609
looping formulas Chas	by JLatham	2	402
Extract info from one sheet to another Kim	by Kim	2	517
Mix Formula Amnon Wilensky	by JLatham	1	400
Conditional Formatting in ref to active cell KUMPFfrog	by Tom Hutchins	2	2,446
Linking and keeping total Column at the Bottom Bob	by Max	1	690
Moving data from one worksheet to another tjvols	by Max	2	475
How to configure Excel to exceed the limit 256 columns. hp2411	by Tyro[_2_]	4	2,066
VB routine to print to PDF? fedude	by Pete_UK	4	1,091
Compare Columns James	by Pete_UK	5	521
simple If but not for me kfarley	by BoniM	3	327
Not sure how to write the formula Caligirl	by Pete_UK	10	800
creating a formula on one sheet that uses results of formulas on o gwendy	by Pete_UK	3	758
Using checkboxes, can I write formulas based on what is checked? Liz	by Billy Liddel	2	1,014
SumIF RoadKill	by Pete_UK	4	420
Importing data Jen40	by JP[_4_]	1	365
using IF to skip Julie	by Julie	4	627
counta in array formula not working Bruce	by T. Valko	3	670
formula required to return data from one column Rich Hayes	by T. Valko	7	606
multiple functions in a single cell John C.	by Mike H	3	1,076
Multiple Results for Vlookup in one column Curtd	by ryguy7272	3	997
formula for selecting cells in one table from values in another Rick Ball[_2_]	by Pete_UK	1	513
Embedded Video Mr. Matt	by Mr. Matt	0	418
SUMIF vs SUMPRODUCT Tim Richards	by T. Valko	2	429
How do I display every 5th row? Tom	by KS	3	374
Button funtion maybe!! adhide	by Rick Rothstein \(MVP - VB\)[_212_]	6	432
look up and data extraction RS	by RS	0	333
PLZ help me with MACROS heaven	by heaven	0	337
COUNTIF question Jock	by Dave Peterson	15	1,720
i want to learn MS OFFICE from micro soft from pakistan daud	by daud	0	481
copy if...or transfer if Manos	by Manos	2	465
How to create primary/secon single click checkbox line autopopulat ktyner	by Max	1	497
Colour multiple cels using range.. adhide	by Max	2	440
Keep sheet from deleting contents Richard	by Jim Cone	1	476
Excel copy and paste beejj	by Max	1	426
Right clicking to summon Format Cells. John[_14_]	by Pete_UK	3	911
Extract a text string based on character kgiraffa	by Ron Rosenfeld	5	892
Vlookup w/multiple lookups JT	by Dave Peterson	3	482
Managing columns KLH	by Don Guillett	3	404
End Down goes to infinity Keith Howard	by Conan Kelly	2	725
sorting a column Googi	by Pete_UK	2	435
How stop Excel default display of pasted number as scientific equa krausch	by Tyro[_2_]	1	1,053
SPSS DATA FILE Tara	by Harlan Grove[_2_]	1	522
HOW I USE MACRO FOR ONE WORKSHEET TO ANOTHER WORKSHEET vic patel[_2_]	by Fred Smith[_4_]	1	370
Vlookup referring to External Workbook or Spreadsheet cgsteel	by Jim	1	900
Count a Range, but only those cells with Black font Q Sean	by Bob Phillips	1	456
Can you use multiple operators in a single formula? Kurt	by Sandy Mann	2	365
Formula contains "" but cell still shows a value Glenn	by Keith Howard	4	490
Please help with report output! 49niner	by 49niner	2	422
Using Lookup Function based on Font Color jstec68	by Mike H	1	1,682
Modify Code Richard	by Richard	0	471
How to multiply hours by a dollar amount Teri	by RagDyer	3	3,898
Formula with sum/avg adimar	by Mike H	3	401
Vlookup? populate 3 columns of data when match a common value, UMPhy Tom	by Bernie Deitrick	1	1,503
Formula Cherie	by Max	3	475
if then else if nested functions in excel vik	by Mike H	1	876
sum formulas based on date Jia	by T. Valko	10	783
how do I stop scrolling from column to column ? gasco	by John Bundy	1	500