Excel Worksheet Functions - Page 677

Thread / Thread Starter	Last Post	Replies	Views
Shortened formula Rob	by Ron Coderre	1	430
need formula for % of times text appears in row. sunslight	by Marcelo	2	367
=ROUNDUP(INT(0.xxx)) Dave F	by Epinn	7	758
table lookup Jhill	by Jhill	3	375
Formula Christine Haines	by Christine Haines	3	341
Lookup Closest Value chad	by Herbert Seidenberg	3	1,245
Help with complex average/if statement [email protected]	by Domenic	1	553
Want average sales numbers for last 12 months. Pierre	by Pierre	2	572
Counting rows based on multiple columns Doyle	by Biff	1	671
SMALL function if 0 Louis	by Louis	5	3,079
Converting text to formulas Eutrapelia	by Gord Dibben	7	745
Copying figures from Access to Excel dalymjl	by dalymjl	0	460
Edit Drop Down List Lynn S	by MartinW	1	2,539
AVERAGE(with complicated range -blanks..) excelent	by excelent	7	628
sorting a column with numbers and text Ford35	by Jim Cone	5	555
Vlookup not working SMRE	by Dave Peterson	1	655
macros for autofill klafert	by klafert	0	440
SUMPRODUCT - Count Previous Month HearSay	by Dave Peterson	3	525
Using VLOOKUP, IF and RIGHT functions together Alicia	by Alicia	3	4,076
If Function Assistance Chris B.	by Sloth	3	531
Array Formula with Concatenate and If Kris_Wright_77	by Kris_Wright_77	2	978
Need blank formula cells rather than 0's Carl	by Sloth	3	707
Naming same cell in different worksheet with 2 value changing on e Yan	by Yan	0	418
need help with MY FORMULA [email protected]	by Dave F	1	396
array function birdsting	by Dave F	1	420
SUMIF with external data tina	by Dave F	1	492
Flaging Dates Paul	by Marcelo	1	393
Large excel file [email protected]	by Ronald Dodge	1	388
How do I convert dates (09/15/06 or 09/20/06) to month (Sept 06)? Kwalityguy	by David Biddulph	3	507
Issue with a formula to help generate a report. BillOSull	by BillOSull	0	415
Add VLOOKUP Nakia Allen	by Pete_UK	1	403
Disable Search Function In Excel Worksheet Dileep	by Dileep	0	1,705
Combining multiple worksheets tina	by tina	0	459
Custom Validation Not Accepting Valid Data Revision [email protected]	by Debra Dalgleish	1	626
RAND FUNCTION NADTARVIN	by Biff	1	638
How do I get labels to repeat in a pivot table? snmcpa	by Debra Dalgleish	3	753
SUMIF Function Freshman	by Biff	2	481
array functions Barak	by RagDyeR	5	408
Dynamically Changing HLOOKUP table PatK	by PatK	4	787
Conditional Underline John C	by bpeltzer	5	693
array manipulation pete	by JMB	1	612
converting hours to minutes w/o VBA herosuper	by Tieske	3	1,597
name an active worksheet djshides via OfficeKB.com	by Tieske	1	466
Multiple lists with repeated values for dependet drop down lists mcmanusb	by Tieske	1	1,366
Dropdown box [email protected]	by Tieske	1	330
calculate count on 2006 total, 2005 total, etc... Amanda Deshotel	by Don Guillett	6	972
Link multiple worksheets while extracting data aj9000	by aj9000	0	451
Rearranging cells into certain columns thelinds	by Tieske	1	705
Hide Rows shail	by Teethless mama	2	436
can I sort names in a column by the last name if it is typed last lanajv	by Tieske	1	432
Worksheet Protection status JimB	by Tieske	1	474
macro needed for non-blank cells beecher	by Ron Coderre	5	720
HELP Curt	by Kassie	1	365
Help with formula/function [email protected]	by [email protected]	0	386
filter help pete	by pete	8	371
Help with formula/function [email protected]	by [email protected]	0	402
Automating a series of dates for two columns? valholler	by valholler	0	477
What function(s) are best to use and when? McMillanY45	by Gord Dibben	3	385
Formulas Juli	by Juli	0	371
Start/End Date Calcs LisaD	by LisaD	0	366
sorting Curt	by Gary L Brown	2	430
SUM IF, Month Danny	by Danny	3	397
can I auto fill zip code column when city is typed Elsie C.	by Gord Dibben	1	2,966
Problems Sorting [email protected]	by Max	5	517
Non updatable Unique Random Number Ian	by Ian	30	3,649
How to do one cell accumulation VR	by Biff	3	1,069
Index Match for 2 columns and one Row [email protected]	by [email protected]	11	1,465
HOW TO COMPARE COLUMN VALUES IN EXCEL? New2Excel	by New2Excel	0	790
consolidate data using 3d function AND indirect Dave Breitenbach	by excelent	1	1,017
SUMIF Question Owen888	by ~L	4	596
How do i change quantities into letters ? luiscarlos	by Bob Phillips	2	470
If & Index & Match [email protected]	by shail	4	548
One-time NOW() function BigD	by Gord Dibben	3	629
Link cells to worksheets Sparky13	by Sparky13	6	658
locked cells rhwong via OfficeKB.com	by rhwong via OfficeKB.com	0	401