Excel Worksheet Functions - Page 729

Thread / Thread Starter	Last Post	Replies	Views
determining & returning least and greatest dates DJS	by Marcelo	3	433
Vertical Lookup from a List B Golden	by B Golden	5	704
Validation list that also allows user entry? Angela Dennis 911	by Marcelo	6	675
Help with Networkdays Calculation Scoooter	by Scoooter	2	472
Question on functions various Excel versions support TP	by Dave Peterson	3	559
Count coloured cells in a range [email protected]	by Alberto Pinto	3	501
LOOKUP 2 DIFFERENT VALUES AT ONE TIME AND RETURN A VALUE nickipas	by nickipas	2	498
Use cell value as reference to sheet in formula? bluegnu	by bluegnu	4	637
IF(AND(etc., etc. ... problem Nicole Seibert	by Muhammed Rafeek M	2	431
insert a picture based on a formula Analyst	by Bernie Deitrick	1	904
Problem with formulas tufftoy	by Max	4	479
Excel should have 300 columns, for use aluminium smelter industry GerharddeBeer	by Toppers	1	444
Criteria for Countif coa01gsb	by David Biddulph	4	574
Text to Coloumns, by consecutive capital letters paperclip	by paperclip	2	694
Variable range in MAX-function nsv	by nsv	3	782
convert yards Les	by Les	2	610
Default Tab Stops for Template IMATech2	by Ian	3	448
Please help... only have 20 mins jamkul	by coa01gsb	1	341
What formula!?!?! jamkul	by jamkul	2	346
Creating a highlighting formula JustinKredible	by Dav	2	476
Cell protection Gregg Johnson	by Scoops	5	530
how to return multiple results in vlookup? Landa	by [email protected]	3	2,503
using vlookup between two separate sheets HB Designs	by Mikeopolo	4	1,604
Fiveif statements in a formula BillS	by Biff	1	335
find hidden data in worksheet catlover1946	by catlover1946	19	2,373
Using an Excel VB-made form in cell-specific conditions. David P. A. Hunter, esq. III	by Die_Another_Day	2	516
Reference external worksheet whose name is in a cell Poly4	by Die_Another_Day	1	396
Unable to get examples to work for lookup etc BrandonC	by Max	6	539
combine two macros Lisa	by Die_Another_Day	1	521
how to use work date function tom	by Paul B	1	429
How do I create a random number generator in excel? Katie	by Alan	2	2,215
How do I get correct results when LOOKUP with calculated numbers onthemountain	by onthemountain	2	685
return previous date from list [email protected]	by [email protected]	5	513
2 different workbooks into one new book Bgeorge	by Bgeorge	0	362
Tough one - Sum and IF with multiple referencing (array) ronlim	by Domenic	5	466
How do I uniformly change the values (numbers) of many cells? Exce Dave6	by Don Guillett	1	500
Refering to Cells madh83	by Kevin Vaughn	3	600
If then color of cell bumble78	by Marcelo	6	337
Shortening a formula GTVT06	by Biff	1	374
Formula question goodolehuskers	by Marcelo	1	634
Top 5 plus Other in Pivot table almpk	by Tom Hutchins	1	6,487
Simple Game and Puzzle - Very Difficult to Implement dmb490	by Maistrye	1	408
Populate current active cell - Help Please!! Larry	by Larry	0	690
array formula: return next date from list [email protected]	by Maistrye	2	1,822
Filling Cells with one Static Cell miscofficestaff	by miscofficestaff	3	468
Lookup with multiple criteria... please help! Anna	by Anna	3	573
Sumif with multiple criteria jn77	by MDubbelboer	5	724
showing multiple results to a formula Robert Brown	by Robert Brown	4	644
conditional format for text Todd	by Domenic	3	589
Date Last Modified Emma Hope	by Graham	3	545
Extracting tab names MLK	by MLK	5	454
sumproduct of columns DJS	by Dave	5	552
How do I calculate the mode of a column of IP addresses? Brandon	by Tushar Mehta	5	461
CountIf Function Barb Miles	by tz81c1	12	872
Help please, cell formatting only works after I double click the cell Mycotopian	by lk	1	1,081
convert number to month and year in formula Soth	by Soth	3	1,350
Concatening a text and a date c991257	by c991257	3	733
Vlookup returns value in the adjacent row Bran	by Tom Hutchins	2	921
Using cell value in filenames Neil Beddell	by vezerid	3	411
How do i print roman letters in the foot note Anwar Al-Harazi	by Anwar Al-Harazi	0	455
Excel If Statements with more than one Solution [email protected]	by Maistrye	1	626
cells Punkin	by Punkin	4	407
Excel, how to count every 4th cell in column to see if occupied? Ashley	by Ashley	4	2,666
Combining information from multiple tabs [email protected]	by BobS9895	10	1,094
Automatically insert a date value based on the value from another cell cmartin2459	by cmartin2459	6	2,929
roll up a calendar in excel Crystal	by Crystal	0	1,485
Round Problems Angela	by CLR	2	344
=if statement michael48	by SimonCC	2	325
Copying a linked worksheet SelimTheDream	by SelimTheDream	4	422
Average of a row of numbers not counting 0's BobS9895	by BobS9895	3	735
Return array from worksheet function Steve Lloyd	by Steve Lloyd	4	702
Using a listbox to show every unique record in a range [email protected]	by [email protected]	4	592
HOW DO I APPLY A FORMULA FOR AND ENTIRE ROW? jcpayne	by Gord Dibben	2	746
Searching and adding a value. rmg	by rmg	2	439
How do I use a formula to create a new line of text in a cell? Jon Shelton	by Gord Dibben	2	1,057