Excel Worksheet Functions - Page 402

Thread / Thread Starter	Last Post	Replies	Views
if, or AJ	by GoBow777	1	481
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,334
DGET/DSUM etc ron_b	by Debra Dalgleish	2	476
Sorting CF Color Johnny1r	by Max	3	488
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,430
references Bert[_2_]	by Stan Brown	2	385
using VLOOKUP for series data Automate	by Automate	3	840
'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,593
How to make Same formula over multiple rows but still holds row # BallySuperTech	by Don Guillett	1	1,845
How do I put worksheets in a workbook in alpha order in 1 step Lynette	by Dave Peterson	1	705
Conditional Formatting Excel 2007 yelnocer	by T. Valko	1	772
automatically show date day by day Bruno	by JLatham	5	581
Help on macro coding for URL Eric	by Don Guillett	2	557
select printer macro jatman	by JLatham	1	598
looping formulas Chas	by JLatham	2	399
Extract info from one sheet to another Kim	by Kim	2	505
Mix Formula Amnon Wilensky	by JLatham	1	400
Conditional Formatting in ref to active cell KUMPFfrog	by Tom Hutchins	2	2,429
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,048
VB routine to print to PDF? fedude	by Pete_UK	4	1,081
Compare Columns James	by Pete_UK	5	516
simple If but not for me kfarley	by BoniM	3	319
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,002
SumIF RoadKill	by Pete_UK	4	410
Importing data Jen40	by JP[_4_]	1	356
using IF to skip Julie	by Julie	4	606
counta in array formula not working Bruce	by T. Valko	3	660
formula required to return data from one column Rich Hayes	by T. Valko	7	602
multiple functions in a single cell John C.	by Mike H	3	1,062
Multiple Results for Vlookup in one column Curtd	by ryguy7272	3	986
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	427
look up and data extraction RS	by RS	0	328
PLZ help me with MACROS heaven	by heaven	0	337
COUNTIF question Jock	by Dave Peterson	15	1,710
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	451
How to create primary/secon single click checkbox line autopopulat ktyner	by Max	1	484
Colour multiple cels using range.. adhide	by Max	2	428
Keep sheet from deleting contents Richard	by Jim Cone	1	472
Excel copy and paste beejj	by Max	1	417
Right clicking to summon Format Cells. John[_14_]	by Pete_UK	3	904
Extract a text string based on character kgiraffa	by Ron Rosenfeld	5	881
Vlookup w/multiple lookups JT	by Dave Peterson	3	472
Managing columns KLH	by Don Guillett	3	395
End Down goes to infinity Keith Howard	by Conan Kelly	2	725
sorting a column Googi	by Pete_UK	2	421
How stop Excel default display of pasted number as scientific equa krausch	by Tyro[_2_]	1	1,042
SPSS DATA FILE Tara	by Harlan Grove[_2_]	1	510
HOW I USE MACRO FOR ONE WORKSHEET TO ANOTHER WORKSHEET vic patel[_2_]	by Fred Smith[_4_]	1	367
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	355
Formula contains "" but cell still shows a value Glenn	by Keith Howard	4	487
Please help with report output! 49niner	by 49niner	2	413
Using Lookup Function based on Font Color jstec68	by Mike H	1	1,670
Modify Code Richard	by Richard	0	448
How to multiply hours by a dollar amount Teri	by RagDyer	3	3,891
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,499
Formula Cherie	by Max	3	472
if then else if nested functions in excel vik	by Mike H	1	863
sum formulas based on date Jia	by T. Valko	10	766
how do I stop scrolling from column to column ? gasco	by John Bundy	1	492