Excel Worksheet Functions - Page 757

Thread / Thread Starter	Last Post	Replies	Views
How to replace a cell if value is alphabetic Hejde	by	5	508
lookup field and copy the row across adyden	by adyden	3	701
Break links automatically changes graph's date format WhytheQ	by WhytheQ	5	648
IF Function gpkelly	by Bondi	1	385
Selection of Drop down list that allows you to go to a particular cell Daphne	by Daphne	2	953
Help Please, Worksheet Change ilvmgicker	by Bob Phillips	1	413
vary the vlookup array depending on the value in a cell Greg Bergin	by	1	609
MSQuery Lac	by Lac	2	454
How to insert rows in transposed data table? Mike	by Hans Knudsen	2	1,097
RANK, duplicate ranking but no gaps in rank arron laing	by arron laing	4	1,969
if specific value from list A equals one of the values from list b... broer konijn	by Toppers	7	1,325
Search for first instance of text & return the value LisaChica	by Biff	12	3,437
dynamic print area based on cell value [email protected]	by Dave Peterson	2	1,624
Can a function do this? Bob Newman	by Dave Peterson	2	351
Dame: identifying duplicate numbers within a column Damondism's	by JMB	2	697
how do I automatically hide or suppress zero balance rows zhehol	by JMB	1	2,360
how do I perform a lookup on an 80,000 line array? Bartimus	by Harlan Grove	4	660
Compound Lookup, Large/Small, Match... uw805	by uw805	3	815
how can i ignore an error in a formula hotelmasters	by Pete_UK	3	731
how do you nest ROUNDDOWN in an IF formula? numbersguy	by SimonCC	1	696
Help with IF function Jim	by Jim	4	353
Retrieve specific date from one row of one column that is changing lpdc	by Dave Peterson	2	424
How do I compare lists in cells Excel Gerald Vandiver	by Gerald Vandiver	0	404
I was creating a histogram; now i have data but no histogram. ShannonMills3	by ShannonMills3	0	873
comparing ranges/arrays asaylor	by Biff	7	669
insert picture excel 2007 from scanner or camera Jerry Stone	by Jerry Stone	0	1,390
Formula to show zero if reference cell is zero? tricky! Simon Lloyd	by Simon Lloyd	3	712
Formula Help please sk81222	by Biff	1	374
functions to count Yes & No fofo	by Gord Dibben	4	1,025
How To Lock Cells and Columns without Protecting Worksheet lostinformulas	by Gord Dibben	3	1,242
=Now() Karen	by Gord Dibben	7	391
unlock a spreadsheet without password tmac	by Gord Dibben	1	1,348
convert cubic centimeters to fluid ounces and cubic centimeters OcalaElaine	by OcalaElaine	4	1,234
Datedif using cell references Excel 2000 JohnH	by Kevin Vaughn	11	1,285
Pivot table and Dsum security Heather	by Debra Dalgleish	1	539
unhide rows when cell is clicked lauren_roberts08	by Bearacade	2	458
How to convert cell contents Robert Judge	by Barb Reinhardt	1	361
Running Sum across columns but only to a certain point Steven Cheng	by Domenic	3	764
nested if function Robb27	by Biff	5	463
Moving cell data and separating or deleting jonhunt	by Max	6	643
Convert a julian gregorian date code into a regular date Robert	by Ron Rosenfeld	3	2,415
MEGA FORMULA Ray	by Arvi Laanemets	5	562
Multiple hyperlinks from drop down box lauren_roberts08	by Dave Peterson	1	392
Dare Format Don Ellet	by Don Ellet	4	873
Please help! Scoooter	by Scoooter	7	306
copy cell from one sheet to another lee254	by pdberger	3	385
Conditional COUNTIF Function Blair	by Bruno Campanini	3	392
User defined functions without using VBA. [email protected]	by [email protected]	0	733
Help with SUBTOTAL formula PO	by Roger Govier	1	467
User defined functions without using VBA. [email protected]	by [email protected]	0	565
Externalizing formulas. Dwayne	by Roger Govier	1	310
Still a problem with DSUM function oteixeira	by oteixeira	0	483
excel function cigars2	by [email protected]	3	370
Can anyone help? Scoooter	by Scoooter	4	419
Hlookup search in more than one sheet of excell? Misko	by Misko	0	415
turn off convert text to date (i.e. 4-9 to April 9, 2006) [email protected]	by [email protected]	4	1,544
Total Minutes Nick I	by [email protected]	3	410
How do I Change the value in a count function from 1 to .25 n2lth	by [email protected]	2	393
Xcel Formula # rows With value X in colF AND Value A or B in colJ Cat	by Domenic	2	399
IF Statement, including AND Louise	by Louise	5	1,322
Copy Worksheets adams77	by adams77	0	419
need value from referenced cell J	by J	2	471
Web toolbar in Excel 2007 beta skat	by skat	0	1,237
I need to count data in one colum based on data in another column LG	by Barb Reinhardt	1	541
Moving left of a cell reference jagbabbra	by Bondi	1	489
Hyperlinks Louise	by Louise	4	344
Moving left of a cell reference jagbabbra	by jagbabbra	0	477
Find and replace Comments Deba	by Dave Peterson	1	358
Basic Question on Subs JOUIOUI	by Dave Peterson	4	479
query in excel George Applegate	by George Applegate	0	1,482
Macro hangs up often but sometimes works fine Jeff	by Don Guillett	3	570
find value one row in advance of specified value broer konijn	by Bob Phillips	3	361
London Excel Conference Registration giveaway Damon Longworth	by Damon Longworth	0	378
Max and lookups ajayb	by ajayb	2	406
RE-submitting of: constructing (complex) variables with worksheet functions broer konijn	by broer konijn	0	564