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,615
Excel macro Curt	by Curt	0	379
How to Append the Data to the Master Table Shiva	by Shiva	7	730
Help w/ counting multiple columns based on IF criteria ConstructionGuy	by Ashish Mathur	3	787
How do you average if your data contains a 0? ras711	by Max	14	1,101
dynamic summed range based on a variable Bruce	by Peo Sjoblom	3	1,036
how do I use if formula using dates? Simone	by Dave Peterson	4	1,463
Pulling in the path to a filename Pradhan	by Dave Peterson	5	500
Average with a 0 in the equation ruralkansas	by Peo Sjoblom	1	333
Count and Sum cells with certain format (e.g. color) [email protected]	by Ron Rosenfeld	2	905
splitting names can't see whats going wrong (Save My Sanity ) workaholic	by Ron Rosenfeld	1	419
Limiting the range of a lookup function Dorn	by Max	5	906
Links only update when external workbook is open CMB	by CMB	6	1,815
Excel columns do not add correctly. BMarilyn92220	by BMarilyn92220	3	688
lookup tables Pat	by Rowan Drummond	2	525
Detecting when a user deletes a row Wescotte	by Wescotte	0	513
How can I display a "sliding" range? msouterblight1	by Rowan Drummond	5	493
Creating a list in sequential order Mark Jackson	by Max	6	891
Can you create a formula to add 1 to the # you enter Word HelpNeeded	by Gord Dibben	5	365
How many IF are authorized? Warrio	by Richard Buttrey	3	443
Delete Formula azazel	by Per Erik Midtrød	2	457
Worksheet name in function Harv	by Bob Phillips	1	390
IF statement containing OR Steph	by Sandy Mann	2	416
Comparing Lists Q	by Bob Phillips	1	524
Protect Workbook vs Worksheet?? Dan B	by Don Guillett	3	4,290
counting text dknibbe	by Gary L Brown	1	504
CHK file in excel link files srinivasan	by Gary L Brown	1	1,016
Need cells to show as zero or empty BelkyBear	by Ian	3	444
IF Function HRMSN	by bill k	6	356
Drop-down boxs Eric C. Vogel	by Bob Phillips	1	338
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,597
HELP ME PLEASE byze	by Gary L Brown	1	302
Change text within multiple functions Harv	by Anne Troy	3	465
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	819
Max and MIN question scott45	by scott45	13	662
import external data too many rows for one worksheet Margaret O'Connor	by Duke Carey	2	1,483
rows that need deleting LtFass	by LtFass	4	398
Counting te days worked in a month Curtis	by Curtis	0	417
conditioning DONNA	by DONNA	8	416
Formula which splits principal & interest pmts on P&I Loan Dealmakerjc	by Bernard Liengme	1	2,187
Consolidate Woorksheets DTTODGG	by DTTODGG	0	407
Function to return last entry in a column series? Tory	by Tory	2	959
VLOOKUP Problem (limitation)? SnotRockit	by SnotRockit	3	847
"Rows to repeat at top" option under page setup PaulandArt	by Don Guillett	1	751
IRR Guess Problem Dkline	by Dkline	4	1,628
{=AVERAGE(IF((C3:C325<M4), C3:C325))} Nebbez	by Bob Phillips	1	420
Formula Help rpalmer4	by rpalmer4	2	337
Creating a league table based on results gpktm	by Domenic	3	407
How do I lookup a corresponding value in another table Des	by Roger Govier	2	568
Columns with "zero" width Dalene	by Barb Reinhardt	2	355
Time sheets Driver	by sajay	5	1,495
Confused beginner sarahog	by sarahog	6	441
date format Tiffany	by Tiffany	3	387
overcoming nested IF limitations...with VBA? JLC	by Harlan Grove	3	620
isolating different aspects of worksheets...as objects? through section breaks? JLC	by JLC	2	1,024
How to return a value Referring to the other cell. ramana	by Stefi	6	420
How to make data in one workbook appear automatically In another Adrian B.	by Adrian B.	2	462
event macros - xl 2003 Sue	by Sue	8	453
Goodness of fit function J Shrimps, Jr.	by Lotus123	1	403
embeding a picture into a cell skeg2	by Lotus123	2	361
toclearasell clearcell	by Lotus123	1	311
Combobox to fit the size of a cell Lotus123	by Lotus123	0	2,549
How do I merge 2 excel spreadsheets containing some common info? SOS	by Lotus123	1	1,039
need a function to calculate a mortgage payment JSEVonda	by Lotus123	1	742
Excel Holiday Roster Calender ksp	by ksp	2	2,089
Conditional Equations in Excel Eric	by bpeltzer	2	550
Average, IF JMS	by JMS	11	620
Look up a list of prices Numpty	by Naz	1	483
Activex Text Box Protection Gerry Bakker	by Gerry Bakker	1	464
need a function to calculate a mortgage payment bpeltzer	by bpeltzer	0	628
Counting Age Simon Chang	by Simon Chang	2	361