Excel Worksheet Functions - Page 402

Thread / Thread Starter	Last Post	Replies	Views
if, or AJ	by GoBow777	1	473
Can I create a pop-up box with terms to view a spreadsheet? eggens	by Jim Cone	2	742
How do I crate a function for week of year + year in same cell. patty ann	by Mike H	1	1,315
DGET/DSUM etc ron_b	by Debra Dalgleish	2	465
Sorting CF Color Johnny1r	by Max	3	482
Formula for assigning distinct name to first instance in a list ofduplicate rows. NickNameGoesHere	by Max	1	440
Excel Dropdown boxes from Home, Page Layout, Insert, etc desilu	by Shah Shailesh	1	1,419
references Bert[_2_]	by Stan Brown	2	374
using VLOOKUP for series data Automate	by Automate	3	834
'Flash' random numbers Jock	by L. Howard Kittle	6	660
Variable Worksheet Name in Formula pdberger	by L. Howard Kittle	4	2,314
Get rid of #VALUE, after multiplying kbouquet	by T. Valko	1	1,572
How to make Same formula over multiple rows but still holds row # BallySuperTech	by Don Guillett	1	1,817
How do I put worksheets in a workbook in alpha order in 1 step Lynette	by Dave Peterson	1	686
Conditional Formatting Excel 2007 yelnocer	by T. Valko	1	756
automatically show date day by day Bruno	by JLatham	5	570
Help on macro coding for URL Eric	by Don Guillett	2	533
select printer macro jatman	by JLatham	1	583
looping formulas Chas	by JLatham	2	394
Extract info from one sheet to another Kim	by Kim	2	495
Mix Formula Amnon Wilensky	by JLatham	1	386
Conditional Formatting in ref to active cell KUMPFfrog	by Tom Hutchins	2	2,413
Linking and keeping total Column at the Bottom Bob	by Max	1	681
Moving data from one worksheet to another tjvols	by Max	2	457
How to configure Excel to exceed the limit 256 columns. hp2411	by Tyro[_2_]	4	2,022
VB routine to print to PDF? fedude	by Pete_UK	4	1,060
Compare Columns James	by Pete_UK	5	505
simple If but not for me kfarley	by BoniM	3	310
Not sure how to write the formula Caligirl	by Pete_UK	10	786
creating a formula on one sheet that uses results of formulas on o gwendy	by Pete_UK	3	737
Using checkboxes, can I write formulas based on what is checked? Liz	by Billy Liddel	2	976
SumIF RoadKill	by Pete_UK	4	400
Importing data Jen40	by JP[_4_]	1	348
using IF to skip Julie	by Julie	4	594
counta in array formula not working Bruce	by T. Valko	3	656
formula required to return data from one column Rich Hayes	by T. Valko	7	581
multiple functions in a single cell John C.	by Mike H	3	1,046
Multiple Results for Vlookup in one column Curtd	by ryguy7272	3	979
formula for selecting cells in one table from values in another Rick Ball[_2_]	by Pete_UK	1	504
Embedded Video Mr. Matt	by Mr. Matt	0	396
SUMIF vs SUMPRODUCT Tim Richards	by T. Valko	2	420
How do I display every 5th row? Tom	by KS	3	360
Button funtion maybe!! adhide	by Rick Rothstein \(MVP - VB\)[_212_]	6	425
look up and data extraction RS	by RS	0	322
PLZ help me with MACROS heaven	by heaven	0	330
COUNTIF question Jock	by Dave Peterson	15	1,690
i want to learn MS OFFICE from micro soft from pakistan daud	by daud	0	474
copy if...or transfer if Manos	by Manos	2	435
How to create primary/secon single click checkbox line autopopulat ktyner	by Max	1	468
Colour multiple cels using range.. adhide	by Max	2	422
Keep sheet from deleting contents Richard	by Jim Cone	1	457
Excel copy and paste beejj	by Max	1	409
Right clicking to summon Format Cells. John[_14_]	by Pete_UK	3	893
Extract a text string based on character kgiraffa	by Ron Rosenfeld	5	867
Vlookup w/multiple lookups JT	by Dave Peterson	3	467
Managing columns KLH	by Don Guillett	3	382
End Down goes to infinity Keith Howard	by Conan Kelly	2	714
sorting a column Googi	by Pete_UK	2	411
How stop Excel default display of pasted number as scientific equa krausch	by Tyro[_2_]	1	1,017
SPSS DATA FILE Tara	by Harlan Grove[_2_]	1	500
HOW I USE MACRO FOR ONE WORKSHEET TO ANOTHER WORKSHEET vic patel[_2_]	by Fred Smith[_4_]	1	356
Vlookup referring to External Workbook or Spreadsheet cgsteel	by Jim	1	890
Count a Range, but only those cells with Black font Q Sean	by Bob Phillips	1	439
Can you use multiple operators in a single formula? Kurt	by Sandy Mann	2	352
Formula contains "" but cell still shows a value Glenn	by Keith Howard	4	476
Please help with report output! 49niner	by 49niner	2	406
Using Lookup Function based on Font Color jstec68	by Mike H	1	1,655
Modify Code Richard	by Richard	0	428
How to multiply hours by a dollar amount Teri	by RagDyer	3	3,829
Formula with sum/avg adimar	by Mike H	3	399
Vlookup? populate 3 columns of data when match a common value, UMPhy Tom	by Bernie Deitrick	1	1,479
Formula Cherie	by Max	3	463
if then else if nested functions in excel vik	by Mike H	1	855
sum formulas based on date Jia	by T. Valko	10	762
how do I stop scrolling from column to column ? gasco	by John Bundy	1	487