Excel Worksheet Functions - Page 402

Thread / Thread Starter	Last Post	Replies	Views
if, or AJ	by GoBow777	1	482
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,353
DGET/DSUM etc ron_b	by Debra Dalgleish	2	477
Sorting CF Color Johnny1r	by Max	3	490
Formula for assigning distinct name to first instance in a list ofduplicate rows. NickNameGoesHere	by Max	1	448
Excel Dropdown boxes from Home, Page Layout, Insert, etc desilu	by Shah Shailesh	1	1,451
references Bert[_2_]	by Stan Brown	2	386
using VLOOKUP for series data Automate	by Automate	3	841
'Flash' random numbers Jock	by L. Howard Kittle	6	665
Variable Worksheet Name in Formula pdberger	by L. Howard Kittle	4	2,346
Get rid of #VALUE, after multiplying kbouquet	by T. Valko	1	1,594
How to make Same formula over multiple rows but still holds row # BallySuperTech	by Don Guillett	1	1,846
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	774
automatically show date day by day Bruno	by JLatham	5	581
Help on macro coding for URL Eric	by Don Guillett	2	563
select printer macro jatman	by JLatham	1	599
looping formulas Chas	by JLatham	2	399
Extract info from one sheet to another Kim	by Kim	2	508
Mix Formula Amnon Wilensky	by JLatham	1	400
Conditional Formatting in ref to active cell KUMPFfrog	by Tom Hutchins	2	2,432
Linking and keeping total Column at the Bottom Bob	by Max	1	690
Moving data from one worksheet to another tjvols	by Max	2	470
How to configure Excel to exceed the limit 256 columns. hp2411	by Tyro[_2_]	4	2,054
VB routine to print to PDF? fedude	by Pete_UK	4	1,082
Compare Columns James	by Pete_UK	5	516
simple If but not for me kfarley	by BoniM	3	320
Not sure how to write the formula Caligirl	by Pete_UK	10	795
creating a formula on one sheet that uses results of formulas on o gwendy	by Pete_UK	3	750
Using checkboxes, can I write formulas based on what is checked? Liz	by Billy Liddel	2	1,003
SumIF RoadKill	by Pete_UK	4	412
Importing data Jen40	by JP[_4_]	1	356
using IF to skip Julie	by Julie	4	612
counta in array formula not working Bruce	by T. Valko	3	662
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,063
Multiple Results for Vlookup in one column Curtd	by ryguy7272	3	987
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	409
SUMIF vs SUMPRODUCT Tim Richards	by T. Valko	2	426
How do I display every 5th row? Tom	by KS	3	364
Button funtion maybe!! adhide	by Rick Rothstein \(MVP - VB\)[_212_]	6	432
look up and data extraction RS	by RS	0	330
PLZ help me with MACROS heaven	by heaven	0	337
COUNTIF question Jock	by Dave Peterson	15	1,713
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	453
How to create primary/secon single click checkbox line autopopulat ktyner	by Max	1	485
Colour multiple cels using range.. adhide	by Max	2	430
Keep sheet from deleting contents Richard	by Jim Cone	1	473
Excel copy and paste beejj	by Max	1	425
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	884
Vlookup w/multiple lookups JT	by Dave Peterson	3	479
Managing columns KLH	by Don Guillett	3	396
End Down goes to infinity Keith Howard	by Conan Kelly	2	725
sorting a column Googi	by Pete_UK	2	425
How stop Excel default display of pasted number as scientific equa krausch	by Tyro[_2_]	1	1,046
SPSS DATA FILE Tara	by Harlan Grove[_2_]	1	512
HOW I USE MACRO FOR ONE WORKSHEET TO ANOTHER WORKSHEET vic patel[_2_]	by Fred Smith[_4_]	1	369
Vlookup referring to External Workbook or Spreadsheet cgsteel	by Jim	1	897
Count a Range, but only those cells with Black font Q Sean	by Bob Phillips	1	446
Can you use multiple operators in a single formula? Kurt	by Sandy Mann	2	356
Formula contains "" but cell still shows a value Glenn	by Keith Howard	4	487
Please help with report output! 49niner	by 49niner	2	414
Using Lookup Function based on Font Color jstec68	by Mike H	1	1,671
Modify Code Richard	by Richard	0	462
How to multiply hours by a dollar amount Teri	by RagDyer	3	3,892
Formula with sum/avg adimar	by Mike H	3	400
Vlookup? populate 3 columns of data when match a common value, UMPhy Tom	by Bernie Deitrick	1	1,500
Formula Cherie	by Max	3	472
if then else if nested functions in excel vik	by Mike H	1	864
sum formulas based on date Jia	by T. Valko	10	767
how do I stop scrolling from column to column ? gasco	by John Bundy	1	493