Excel Worksheet Functions - Page 729

Thread / Thread Starter	Last Post	Replies	Views
determining & returning least and greatest dates DJS	by Marcelo	3	416
Vertical Lookup from a List B Golden	by B Golden	5	689
Validation list that also allows user entry? Angela Dennis 911	by Marcelo	6	655
Help with Networkdays Calculation Scoooter	by Scoooter	2	451
Question on functions various Excel versions support TP	by Dave Peterson	3	538
Count coloured cells in a range [email protected]	by Alberto Pinto	3	488
LOOKUP 2 DIFFERENT VALUES AT ONE TIME AND RETURN A VALUE nickipas	by nickipas	2	483
Use cell value as reference to sheet in formula? bluegnu	by bluegnu	4	608
IF(AND(etc., etc. ... problem Nicole Seibert	by Muhammed Rafeek M	2	418
insert a picture based on a formula Analyst	by Bernie Deitrick	1	892
Problem with formulas tufftoy	by Max	4	456
Excel should have 300 columns, for use aluminium smelter industry GerharddeBeer	by Toppers	1	435
Criteria for Countif coa01gsb	by David Biddulph	4	545
Text to Coloumns, by consecutive capital letters paperclip	by paperclip	2	680
Variable range in MAX-function nsv	by nsv	3	767
convert yards Les	by Les	2	588
Default Tab Stops for Template IMATech2	by Ian	3	438
Please help... only have 20 mins jamkul	by coa01gsb	1	328
What formula!?!?! jamkul	by jamkul	2	335
Creating a highlighting formula JustinKredible	by Dav	2	466
Cell protection Gregg Johnson	by Scoops	5	513
how to return multiple results in vlookup? Landa	by [email protected]	3	2,475
using vlookup between two separate sheets HB Designs	by Mikeopolo	4	1,587
Fiveif statements in a formula BillS	by Biff	1	327
find hidden data in worksheet catlover1946	by catlover1946	19	2,347
Using an Excel VB-made form in cell-specific conditions. David P. A. Hunter, esq. III	by Die_Another_Day	2	494
Reference external worksheet whose name is in a cell Poly4	by Die_Another_Day	1	388
Unable to get examples to work for lookup etc BrandonC	by Max	6	513
combine two macros Lisa	by Die_Another_Day	1	508
how to use work date function tom	by Paul B	1	417
How do I create a random number generator in excel? Katie	by Alan	2	2,183
How do I get correct results when LOOKUP with calculated numbers onthemountain	by onthemountain	2	669
return previous date from list [email protected]	by [email protected]	5	488
2 different workbooks into one new book Bgeorge	by Bgeorge	0	349
Tough one - Sum and IF with multiple referencing (array) ronlim	by Domenic	5	446
How do I uniformly change the values (numbers) of many cells? Exce Dave6	by Don Guillett	1	481
Refering to Cells madh83	by Kevin Vaughn	3	581
If then color of cell bumble78	by Marcelo	6	329
Shortening a formula GTVT06	by Biff	1	364
Formula question goodolehuskers	by Marcelo	1	614
Top 5 plus Other in Pivot table almpk	by Tom Hutchins	1	6,455
Simple Game and Puzzle - Very Difficult to Implement dmb490	by Maistrye	1	394
Populate current active cell - Help Please!! Larry	by Larry	0	663
array formula: return next date from list [email protected]	by Maistrye	2	1,797
Filling Cells with one Static Cell miscofficestaff	by miscofficestaff	3	450
Lookup with multiple criteria... please help! Anna	by Anna	3	546
Sumif with multiple criteria jn77	by MDubbelboer	5	693
showing multiple results to a formula Robert Brown	by Robert Brown	4	622
conditional format for text Todd	by Domenic	3	569
Date Last Modified Emma Hope	by Graham	3	524
Extracting tab names MLK	by MLK	5	433
sumproduct of columns DJS	by Dave	5	535
How do I calculate the mode of a column of IP addresses? Brandon	by Tushar Mehta	5	448
CountIf Function Barb Miles	by tz81c1	12	861
Help please, cell formatting only works after I double click the cell Mycotopian	by lk	1	1,066
convert number to month and year in formula Soth	by Soth	3	1,278
Concatening a text and a date c991257	by c991257	3	719
Vlookup returns value in the adjacent row Bran	by Tom Hutchins	2	915
Using cell value in filenames Neil Beddell	by vezerid	3	393
How do i print roman letters in the foot note Anwar Al-Harazi	by Anwar Al-Harazi	0	442
Excel If Statements with more than one Solution [email protected]	by Maistrye	1	606
cells Punkin	by Punkin	4	394
Excel, how to count every 4th cell in column to see if occupied? Ashley	by Ashley	4	2,633
Combining information from multiple tabs [email protected]	by BobS9895	10	1,075
Automatically insert a date value based on the value from another cell cmartin2459	by cmartin2459	6	2,873
roll up a calendar in excel Crystal	by Crystal	0	1,466
Round Problems Angela	by CLR	2	338
=if statement michael48	by SimonCC	2	313
Copying a linked worksheet SelimTheDream	by SelimTheDream	4	410
Average of a row of numbers not counting 0's BobS9895	by BobS9895	3	726
Return array from worksheet function Steve Lloyd	by Steve Lloyd	4	681
Using a listbox to show every unique record in a range [email protected]	by [email protected]	4	560
HOW DO I APPLY A FORMULA FOR AND ENTIRE ROW? jcpayne	by Gord Dibben	2	708
Searching and adding a value. rmg	by rmg	2	432
How do I use a formula to create a new line of text in a cell? Jon Shelton	by Gord Dibben	2	1,022