Excel Worksheet Functions - Page 729

Thread / Thread Starter	Last Post	Replies	Views
determining & returning least and greatest dates DJS	by Marcelo	3	445
Vertical Lookup from a List B Golden	by B Golden	5	715
Validation list that also allows user entry? Angela Dennis 911	by Marcelo	6	687
Help with Networkdays Calculation Scoooter	by Scoooter	2	482
Question on functions various Excel versions support TP	by Dave Peterson	3	560
Count coloured cells in a range [email protected]	by Alberto Pinto	3	512
LOOKUP 2 DIFFERENT VALUES AT ONE TIME AND RETURN A VALUE nickipas	by nickipas	2	512
Use cell value as reference to sheet in formula? bluegnu	by bluegnu	4	648
IF(AND(etc., etc. ... problem Nicole Seibert	by Muhammed Rafeek M	2	444
insert a picture based on a formula Analyst	by Bernie Deitrick	1	910
Problem with formulas tufftoy	by Max	4	486
Excel should have 300 columns, for use aluminium smelter industry GerharddeBeer	by Toppers	1	445
Criteria for Countif coa01gsb	by David Biddulph	4	574
Text to Coloumns, by consecutive capital letters paperclip	by paperclip	2	698
Variable range in MAX-function nsv	by nsv	3	793
convert yards Les	by Les	2	610
Default Tab Stops for Template IMATech2	by Ian	3	458
Please help... only have 20 mins jamkul	by coa01gsb	1	353
What formula!?!?! jamkul	by jamkul	2	357
Creating a highlighting formula JustinKredible	by Dav	2	487
Cell protection Gregg Johnson	by Scoops	5	530
how to return multiple results in vlookup? Landa	by [email protected]	3	2,511
using vlookup between two separate sheets HB Designs	by Mikeopolo	4	1,616
Fiveif statements in a formula BillS	by Biff	1	348
find hidden data in worksheet catlover1946	by catlover1946	19	2,386
Using an Excel VB-made form in cell-specific conditions. David P. A. Hunter, esq. III	by Die_Another_Day	2	529
Reference external worksheet whose name is in a cell Poly4	by Die_Another_Day	1	402
Unable to get examples to work for lookup etc BrandonC	by Max	6	551
combine two macros Lisa	by Die_Another_Day	1	532
how to use work date function tom	by Paul B	1	436
How do I create a random number generator in excel? Katie	by Alan	2	2,222
How do I get correct results when LOOKUP with calculated numbers onthemountain	by onthemountain	2	697
return previous date from list [email protected]	by [email protected]	5	516
2 different workbooks into one new book Bgeorge	by Bgeorge	0	364
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	514
Refering to Cells madh83	by Kevin Vaughn	3	602
If then color of cell bumble78	by Marcelo	6	349
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,494
Simple Game and Puzzle - Very Difficult to Implement dmb490	by Maistrye	1	418
Populate current active cell - Help Please!! Larry	by Larry	0	699
array formula: return next date from list [email protected]	by Maistrye	2	1,827
Filling Cells with one Static Cell miscofficestaff	by miscofficestaff	3	471
Lookup with multiple criteria... please help! Anna	by Anna	3	584
Sumif with multiple criteria jn77	by MDubbelboer	5	725
showing multiple results to a formula Robert Brown	by Robert Brown	4	649
conditional format for text Todd	by Domenic	3	591
Date Last Modified Emma Hope	by Graham	3	552
Extracting tab names MLK	by MLK	5	465
sumproduct of columns DJS	by Dave	5	559
How do I calculate the mode of a column of IP addresses? Brandon	by Tushar Mehta	5	472
CountIf Function Barb Miles	by tz81c1	12	879
Help please, cell formatting only works after I double click the cell Mycotopian	by lk	1	1,085
convert number to month and year in formula Soth	by Soth	3	1,365
Concatening a text and a date c991257	by c991257	3	742
Vlookup returns value in the adjacent row Bran	by Tom Hutchins	2	932
Using cell value in filenames Neil Beddell	by vezerid	3	421
How do i print roman letters in the foot note Anwar Al-Harazi	by Anwar Al-Harazi	0	458
Excel If Statements with more than one Solution [email protected]	by Maistrye	1	626
cells Punkin	by Punkin	4	411
Excel, how to count every 4th cell in column to see if occupied? Ashley	by Ashley	4	2,669
Combining information from multiple tabs [email protected]	by BobS9895	10	1,095
Automatically insert a date value based on the value from another cell cmartin2459	by cmartin2459	6	2,941
roll up a calendar in excel Crystal	by Crystal	0	1,487
Round Problems Angela	by CLR	2	351
=if statement michael48	by SimonCC	2	331
Copying a linked worksheet SelimTheDream	by SelimTheDream	4	429
Average of a row of numbers not counting 0's BobS9895	by BobS9895	3	741
Return array from worksheet function Steve Lloyd	by Steve Lloyd	4	706
Using a listbox to show every unique record in a range [email protected]	by [email protected]	4	606
HOW DO I APPLY A FORMULA FOR AND ENTIRE ROW? jcpayne	by Gord Dibben	2	748
Searching and adding a value. rmg	by rmg	2	449
How do I use a formula to create a new line of text in a cell? Jon Shelton	by Gord Dibben	2	1,069