Excel Worksheet Functions - Page 929

Thread / Thread Starter	Last Post	Replies	Views
Vlookup doesn't work until i edit(but not change) the lookup cell Confused	by Max	4	2,617
Excel macro Curt	by Curt	0	385
How to Append the Data to the Master Table Shiva	by Shiva	7	732
Help w/ counting multiple columns based on IF criteria ConstructionGuy	by Ashish Mathur	3	791
How do you average if your data contains a 0? ras711	by Max	14	1,106
dynamic summed range based on a variable Bruce	by Peo Sjoblom	3	1,038
how do I use if formula using dates? Simone	by Dave Peterson	4	1,474
Pulling in the path to a filename Pradhan	by Dave Peterson	5	506
Average with a 0 in the equation ruralkansas	by Peo Sjoblom	1	339
Count and Sum cells with certain format (e.g. color) [email protected]	by Ron Rosenfeld	2	909
splitting names can't see whats going wrong (Save My Sanity ) workaholic	by Ron Rosenfeld	1	420
Limiting the range of a lookup function Dorn	by Max	5	912
Links only update when external workbook is open CMB	by CMB	6	1,815
Excel columns do not add correctly. BMarilyn92220	by BMarilyn92220	3	690
lookup tables Pat	by Rowan Drummond	2	557
Detecting when a user deletes a row Wescotte	by Wescotte	0	521
How can I display a "sliding" range? msouterblight1	by Rowan Drummond	5	503
Creating a list in sequential order Mark Jackson	by Max	6	901
Can you create a formula to add 1 to the # you enter Word HelpNeeded	by Gord Dibben	5	373
How many IF are authorized? Warrio	by Richard Buttrey	3	448
Delete Formula azazel	by Per Erik Midtrød	2	461
Worksheet name in function Harv	by Bob Phillips	1	390
IF statement containing OR Steph	by Sandy Mann	2	417
Comparing Lists Q	by Bob Phillips	1	526
Protect Workbook vs Worksheet?? Dan B	by Don Guillett	3	4,298
counting text dknibbe	by Gary L Brown	1	510
CHK file in excel link files srinivasan	by Gary L Brown	1	1,019
Need cells to show as zero or empty BelkyBear	by Ian	3	446
IF Function HRMSN	by bill k	6	360
Drop-down boxs Eric C. Vogel	by Bob Phillips	1	339
Logon Screen mamun316	by Don Guillett	1	418
Text moving azazel	by bpeltzer	1	512
Complicated counting of cells (based on other cells contents) George	by Bob Phillips	3	2,598
HELP ME PLEASE byze	by Gary L Brown	1	306
Change text within multiple functions Harv	by Anne Troy	3	466
Multiple IF Tim Elhatton	by ConstructionGuy	3	310
Non-Blank Cells: Conditional Counting dknibbe	by Duke Carey	8	809
How to generate a list of randomly selected numbers within a range Bob	by Bob	2	824
Max and MIN question scott45	by scott45	13	667
import external data too many rows for one worksheet Margaret O'Connor	by Duke Carey	2	1,485
rows that need deleting LtFass	by LtFass	4	406
Counting te days worked in a month Curtis	by Curtis	0	424
conditioning DONNA	by DONNA	8	425
Formula which splits principal & interest pmts on P&I Loan Dealmakerjc	by Bernard Liengme	1	2,192
Consolidate Woorksheets DTTODGG	by DTTODGG	0	415
Function to return last entry in a column series? Tory	by Tory	2	963
VLOOKUP Problem (limitation)? SnotRockit	by SnotRockit	3	853
"Rows to repeat at top" option under page setup PaulandArt	by Don Guillett	1	758
IRR Guess Problem Dkline	by Dkline	4	1,631
{=AVERAGE(IF((C3:C325<M4), C3:C325))} Nebbez	by Bob Phillips	1	422
Formula Help rpalmer4	by rpalmer4	2	341
Creating a league table based on results gpktm	by Domenic	3	410
How do I lookup a corresponding value in another table Des	by Roger Govier	2	571
Columns with "zero" width Dalene	by Barb Reinhardt	2	360
Time sheets Driver	by sajay	5	1,499
Confused beginner sarahog	by sarahog	6	442
date format Tiffany	by Tiffany	3	387
overcoming nested IF limitations...with VBA? JLC	by Harlan Grove	3	621
isolating different aspects of worksheets...as objects? through section breaks? JLC	by JLC	2	1,030
How to return a value Referring to the other cell. ramana	by Stefi	6	428
How to make data in one workbook appear automatically In another Adrian B.	by Adrian B.	2	468
event macros - xl 2003 Sue	by Sue	8	458
Goodness of fit function J Shrimps, Jr.	by Lotus123	1	422
embeding a picture into a cell skeg2	by Lotus123	2	366
toclearasell clearcell	by Lotus123	1	315
Combobox to fit the size of a cell Lotus123	by Lotus123	0	2,555
How do I merge 2 excel spreadsheets containing some common info? SOS	by Lotus123	1	1,044
need a function to calculate a mortgage payment JSEVonda	by Lotus123	1	747
Excel Holiday Roster Calender ksp	by ksp	2	2,090
Conditional Equations in Excel Eric	by bpeltzer	2	555
Average, IF JMS	by JMS	11	623
Look up a list of prices Numpty	by Naz	1	486
Activex Text Box Protection Gerry Bakker	by Gerry Bakker	1	472
need a function to calculate a mortgage payment bpeltzer	by bpeltzer	0	632
Counting Age Simon Chang	by Simon Chang	2	367