Excel Worksheet Functions - Page 677

Thread / Thread Starter	Last Post	Replies	Views
Shortened formula Rob	by Ron Coderre	1	432
need formula for % of times text appears in row. sunslight	by Marcelo	2	369
=ROUNDUP(INT(0.xxx)) Dave F	by Epinn	7	760
table lookup Jhill	by Jhill	3	379
Formula Christine Haines	by Christine Haines	3	343
Lookup Closest Value chad	by Herbert Seidenberg	3	1,254
Help with complex average/if statement [email protected]	by Domenic	1	559
Want average sales numbers for last 12 months. Pierre	by Pierre	2	580
Counting rows based on multiple columns Doyle	by Biff	1	679
SMALL function if 0 Louis	by Louis	5	3,082
Converting text to formulas Eutrapelia	by Gord Dibben	7	756
Copying figures from Access to Excel dalymjl	by dalymjl	0	469
Edit Drop Down List Lynn S	by MartinW	1	2,542
AVERAGE(with complicated range -blanks..) excelent	by excelent	7	628
sorting a column with numbers and text Ford35	by Jim Cone	5	558
Vlookup not working SMRE	by Dave Peterson	1	668
macros for autofill klafert	by klafert	0	440
SUMPRODUCT - Count Previous Month HearSay	by Dave Peterson	3	527
Using VLOOKUP, IF and RIGHT functions together Alicia	by Alicia	3	4,084
If Function Assistance Chris B.	by Sloth	3	536
Array Formula with Concatenate and If Kris_Wright_77	by Kris_Wright_77	2	979
Need blank formula cells rather than 0's Carl	by Sloth	3	727
Naming same cell in different worksheet with 2 value changing on e Yan	by Yan	0	424
need help with MY FORMULA [email protected]	by Dave F	1	397
array function birdsting	by Dave F	1	425
SUMIF with external data tina	by Dave F	1	493
Flaging Dates Paul	by Marcelo	1	393
Large excel file [email protected]	by Ronald Dodge	1	390
How do I convert dates (09/15/06 or 09/20/06) to month (Sept 06)? Kwalityguy	by David Biddulph	3	509
Issue with a formula to help generate a report. BillOSull	by BillOSull	0	425
Add VLOOKUP Nakia Allen	by Pete_UK	1	404
Disable Search Function In Excel Worksheet Dileep	by Dileep	0	1,705
Combining multiple worksheets tina	by tina	0	460
Custom Validation Not Accepting Valid Data Revision [email protected]	by Debra Dalgleish	1	642
RAND FUNCTION NADTARVIN	by Biff	1	647
How do I get labels to repeat in a pivot table? snmcpa	by Debra Dalgleish	3	760
SUMIF Function Freshman	by Biff	2	489
array functions Barak	by RagDyeR	5	409
Dynamically Changing HLOOKUP table PatK	by PatK	4	796
Conditional Underline John C	by bpeltzer	5	703
array manipulation pete	by JMB	1	617
converting hours to minutes w/o VBA herosuper	by Tieske	3	1,599
name an active worksheet djshides via OfficeKB.com	by Tieske	1	468
Multiple lists with repeated values for dependet drop down lists mcmanusb	by Tieske	1	1,383
Dropdown box [email protected]	by Tieske	1	333
calculate count on 2006 total, 2005 total, etc... Amanda Deshotel	by Don Guillett	6	976
Link multiple worksheets while extracting data aj9000	by aj9000	0	459
Rearranging cells into certain columns thelinds	by Tieske	1	708
Hide Rows shail	by Teethless mama	2	439
can I sort names in a column by the last name if it is typed last lanajv	by Tieske	1	434
Worksheet Protection status JimB	by Tieske	1	476
macro needed for non-blank cells beecher	by Ron Coderre	5	727
HELP Curt	by Kassie	1	366
Help with formula/function [email protected]	by [email protected]	0	388
filter help pete	by pete	8	371
Help with formula/function [email protected]	by [email protected]	0	405
Automating a series of dates for two columns? valholler	by valholler	0	480
What function(s) are best to use and when? McMillanY45	by Gord Dibben	3	386
Formulas Juli	by Juli	0	372
Start/End Date Calcs LisaD	by LisaD	0	368
sorting Curt	by Gary L Brown	2	432
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,968
Problems Sorting [email protected]	by Max	5	532
Non updatable Unique Random Number Ian	by Ian	30	3,703
How to do one cell accumulation VR	by Biff	3	1,107
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,021
SUMIF Question Owen888	by ~L	4	596
How do i change quantities into letters ? luiscarlos	by Bob Phillips	2	472
If & Index & Match [email protected]	by shail	4	552
One-time NOW() function BigD	by Gord Dibben	3	634
Link cells to worksheets Sparky13	by Sparky13	6	661
locked cells rhwong via OfficeKB.com	by rhwong via OfficeKB.com	0	411