Excel Worksheet Functions - Page 757

Thread / Thread Starter	Last Post	Replies	Views
How to replace a cell if value is alphabetic Hejde	by	5	496
lookup field and copy the row across adyden	by adyden	3	680
Break links automatically changes graph's date format WhytheQ	by WhytheQ	5	628
IF Function gpkelly	by Bondi	1	383
Selection of Drop down list that allows you to go to a particular cell Daphne	by Daphne	2	913
Help Please, Worksheet Change ilvmgicker	by Bob Phillips	1	403
vary the vlookup array depending on the value in a cell Greg Bergin	by	1	584
MSQuery Lac	by Lac	2	441
How to insert rows in transposed data table? Mike	by Hans Knudsen	2	1,084
RANK, duplicate ranking but no gaps in rank arron laing	by arron laing	4	1,951
if specific value from list A equals one of the values from list b... broer konijn	by Toppers	7	1,305
Search for first instance of text & return the value LisaChica	by Biff	12	3,408
dynamic print area based on cell value [email protected]	by Dave Peterson	2	1,609
Can a function do this? Bob Newman	by Dave Peterson	2	347
Dame: identifying duplicate numbers within a column Damondism's	by JMB	2	661
how do I automatically hide or suppress zero balance rows zhehol	by JMB	1	2,324
how do I perform a lookup on an 80,000 line array? Bartimus	by Harlan Grove	4	636
Compound Lookup, Large/Small, Match... uw805	by uw805	3	799
how can i ignore an error in a formula hotelmasters	by Pete_UK	3	703
how do you nest ROUNDDOWN in an IF formula? numbersguy	by SimonCC	1	679
Help with IF function Jim	by Jim	4	335
Retrieve specific date from one row of one column that is changing lpdc	by Dave Peterson	2	394
How do I compare lists in cells Excel Gerald Vandiver	by Gerald Vandiver	0	385
I was creating a histogram; now i have data but no histogram. ShannonMills3	by ShannonMills3	0	852
comparing ranges/arrays asaylor	by Biff	7	646
insert picture excel 2007 from scanner or camera Jerry Stone	by Jerry Stone	0	1,353
Formula to show zero if reference cell is zero? tricky! Simon Lloyd	by Simon Lloyd	3	676
Formula Help please sk81222	by Biff	1	368
functions to count Yes & No fofo	by Gord Dibben	4	1,006
How To Lock Cells and Columns without Protecting Worksheet lostinformulas	by Gord Dibben	3	1,231
=Now() Karen	by Gord Dibben	7	382
unlock a spreadsheet without password tmac	by Gord Dibben	1	1,317
convert cubic centimeters to fluid ounces and cubic centimeters OcalaElaine	by OcalaElaine	4	1,203
Datedif using cell references Excel 2000 JohnH	by Kevin Vaughn	11	1,265
Pivot table and Dsum security Heather	by Debra Dalgleish	1	525
unhide rows when cell is clicked lauren_roberts08	by Bearacade	2	425
How to convert cell contents Robert Judge	by Barb Reinhardt	1	335
Running Sum across columns but only to a certain point Steven Cheng	by Domenic	3	747
nested if function Robb27	by Biff	5	446
Moving cell data and separating or deleting jonhunt	by Max	6	624
Convert a julian gregorian date code into a regular date Robert	by Ron Rosenfeld	3	2,378
MEGA FORMULA Ray	by Arvi Laanemets	5	519
Multiple hyperlinks from drop down box lauren_roberts08	by Dave Peterson	1	380
Dare Format Don Ellet	by Don Ellet	4	862
Please help! Scoooter	by Scoooter	7	302
copy cell from one sheet to another lee254	by pdberger	3	374
Conditional COUNTIF Function Blair	by Bruno Campanini	3	374
User defined functions without using VBA. [email protected]	by [email protected]	0	704
Help with SUBTOTAL formula PO	by Roger Govier	1	450
User defined functions without using VBA. [email protected]	by [email protected]	0	534
Externalizing formulas. Dwayne	by Roger Govier	1	298
Still a problem with DSUM function oteixeira	by oteixeira	0	451
excel function cigars2	by [email protected]	3	353
Can anyone help? Scoooter	by Scoooter	4	415
Hlookup search in more than one sheet of excell? Misko	by Misko	0	399
turn off convert text to date (i.e. 4-9 to April 9, 2006) [email protected]	by [email protected]	4	1,465
Total Minutes Nick I	by [email protected]	3	402
How do I Change the value in a count function from 1 to .25 n2lth	by [email protected]	2	383
Xcel Formula # rows With value X in colF AND Value A or B in colJ Cat	by Domenic	2	392
IF Statement, including AND Louise	by Louise	5	1,300
Copy Worksheets adams77	by adams77	0	411
need value from referenced cell J	by J	2	441
Web toolbar in Excel 2007 beta skat	by skat	0	1,191
I need to count data in one colum based on data in another column LG	by Barb Reinhardt	1	517
Moving left of a cell reference jagbabbra	by Bondi	1	467
Hyperlinks Louise	by Louise	4	330
Moving left of a cell reference jagbabbra	by jagbabbra	0	449
Find and replace Comments Deba	by Dave Peterson	1	339
Basic Question on Subs JOUIOUI	by Dave Peterson	4	454
query in excel George Applegate	by George Applegate	0	1,460
Macro hangs up often but sometimes works fine Jeff	by Don Guillett	3	545
find value one row in advance of specified value broer konijn	by Bob Phillips	3	341
London Excel Conference Registration giveaway Damon Longworth	by Damon Longworth	0	364
Max and lookups ajayb	by ajayb	2	396
RE-submitting of: constructing (complex) variables with worksheet functions broer konijn	by broer konijn	0	538