Excel Worksheet Functions - Page 480

Thread / Thread Starter	Last Post	Replies	Views
Table_array and drop down boxes GMAN501	by Anant Basant	1	385
Moving a Task Pane Steve G	by Gord Dibben	3	363
#REF# Problem [email protected][_2_]	by [email protected][_2_]	1	424
Using Excel to auto spread data JJ	by daddylonglegs	2	1,331
Need help figuring out how to code this macro jefals	by jefals	4	351
A function incoprating date and a month/monetary value. Christopher Leigh Stout	by T. Valko	8	1,040
Limit a countif? Tim[_9_]	by T. Valko	4	760
Find then save to different worksheet galfriday905	by Galfriday	3	413
vlookup and hlookup formula, a good challenge Frances C[_2_]	by Ron Coderre	5	470
question about ABS Function Terry	by Gord Dibben	2	422
List Lookup Help nabanco	by Bob Phillips	6	367
Help with If Function Joy	by MartinW	3	320
Is a Pop-up Calendar Possible? KLB	by KLB	3	369
User Record nabanco	by JE McGimpsey	5	394
Subtracting 1 year from todays date Alan B	by OssieMac	9	1,791
Modifying only the worksheet when draging down a cell reference [email protected]	by Max	20	1,492
macro to: Add new sheet, then rename new sheet with todays date Paul	by Alan	3	5,723
special lookup Jasper	by T. Valko	1	410
Help with auto populating cells. Brad	by Balan	4	680
Excel 07 Conditional Formatting Help! [email protected]	by B. R.Ramachandran	4	495
COUNTIF a value within a range equals any value in an array/list sweens319	by T. Valko	14	2,218
Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul RyGuy	by RyGuy	2	1,477
Drop Down Calendar ? James	by Ron de Bruin	1	439
Get Cell Address From Lookup (Alternative to Lookup) ryguy7272	by RyGuy	12	2,016
Absolute Reference to the Left Until Change in Row RyGuy	by RyGuy	6	736
Complicated Cell Formula mjones	by kassie	9	395
Lookup?? Connie Martin	by Ron Coderre	5	317
list sheet names vertically below the active cell - need macro. Eddy Stan	by Tom Ogilvy	2	583
filtering a list to exclude 2 different dates Sarah	by Roger Govier[_3_]	4	611
SUMPRODUCT trciky use. Nde	by Ron Coderre	4	390
Lock cell as reference not value susy	by susy	8	872
How do I select cells within a column that contain a specific word Tobias	by Bob Umlas	1	1,260
I need help - search formula Jamie	by Jamie	4	429
conditional sum ?? Kevin	by Kevin	2	361
copying conditional formating Alpal	by Peo Sjoblom	1	424
Simple problem, simple formula, no FUNCTION ! Ron@Buy	by Ron@Buy	6	1,126
Criteria with cell references Johan	by Peo Sjoblom	2	453
Top cell in a list to match cells below of a certain value? NS421	by Gord Dibben	5	533
Custom Cell Format in a List Courtney	by Courtney	4	440
Creating sheet references Mats Samson	by Gord Dibben	4	395
Print Gridlines only on sections of a spreadsheet TMCAccounting	by tim m	1	640
IF/COUNT/AVERAGE... Value returned is incorrect. Rebekah	by Roger Govier[_3_]	3	746
Conditional Queries? Russell Seguin	by Roger Govier[_3_]	5	347
Custom functions excel 2003 NICOLA-ITALY	by NICOLA-ITALY	0	699
complex randbeween formula, Excel2007 Titus	by Titus	7	757
SUMIF problem richierich1961	by Max	5	551
Count if all both apply Grams	by Alan	10	755
AutoSum lost a penny PoldenKaz	by PoldenKaz	5	1,032
sum product not returning correct number Grams	by Ron Rosenfeld	3	589
how use msexcel tulsi	by JE McGimpsey	1	388
Hyperlink to another sheet within a workbook using formula Christopher Watson	by Max	1	2,198
Auto row insertion based on a number Eugene Wong	by Eugene Wong[_2_]	6	576
Extract a list from master list js	by Excel_Learner	4	669
How to combine "IF" functions BeeCee	by Harlan Grove[_2_]	3	763
Array or range lookup per row? RG	by RG	0	543
pivot table to contains more than 1 field groups jackysoh	by jackysoh	0	607
match multiple criteria ina range from multiple criteria multiplet RG	by RG	8	1,409
forcing date to excel Daniel	by Wondering[_2_]	1	319
How to hold running Macro? Eric	by Eric	2	328
HLOOKUP question Chuck M	by Pete_UK	6	442
Multiply by a rate depending on the value C.C.	by Pete_UK	3	457
count percentages jpmurray22	by Wondering[_2_]	3	319
zoom and scrolling with a mouse ijvoyse	by ijvoyse	4	829
showing the totals in a chart/table without charting them Anne	by Gord Dibben	1	813
day of month Scotty	by David Biddulph[_2_]	2	307
calculating differences in a pivot table [email protected]	by Roger Govier[_3_]	3	1,481
Sum of 12 cells BillyRogers	by BillyRogers	7	945
YTD value minus prev mth value = curent month - Rolling Report karenm	by karenm	0	767
date in excel ? Daniel	by Peo Sjoblom	7	397
Total 12 columns starting with first non blank column BillyRogers	by BillyRogers	9	556
Absolute value with a quick formula / shortcut? Derek	by Mark Lincoln	3	829
Modify A Macro carl	by JW[_2_]	1	393
Need Help Generating a Specific Formula Gene Cocchi	by Gene Cocchi[_2_]	4	438
How do I change colors on the row/column active header? GaryW	by Gord Dibben	3	639
Average Mike	by Mike	3	309