Excel Worksheet Functions - Page 101

Thread / Thread Starter	Last Post	Replies	Views
how can I get the last value entered into an excel column to disp. taylord	by bj	2	590
statistical functions agenda9533	by Michael R Middleton	2	605
YTD Budget Sum if Actual Month has activities AGnes	by Gary Brown	1	1,579
Find a non-blank cell and bring back text a in same row Rod	by Rod	12	1,902
Can you password an Excel worksheet, if so how? Coga	by Trevor Shuttleworth	1	618
Autofill Confused?	by Gord Dibben	1	568
Question about sorting in protected worksheet SJC	by Gord Dibben	6	1,262
Mod-10 Check Digit Union70	by Myrna Larson	1	2,023
Move rows to columns Daniell	by Daniell	2	806
hOW DO I GET THE XCELL FUNCTION CUMPRINC TO WORK? Asterix	by Gord Dibben	1	781
How can I make a timesheet to figure my hours and payrate? Bruce	by Gord Dibben	2	1,082
filter and keep same information. WellsDesign	by CLR	3	509
How do I set up IRR and NPV functions in Excel? John Rovenolt	by Gord Dibben	2	1,162
Links Problem DSE	by Dave Peterson	2	781
designing and saving predefined pivot table formats? Surfstiling	by Debra Dalgleish	1	672
How 2 rotate information in a working shift pattern Xeraco	by JulieD	3	516
find previous row for an item HedwigVB	by HedwigVB	2	477
Sort Data by Frequency Susan Smith	by Myrna Larson	1	1,292
calculate totals of 5 sheets on to 6th sheet. salvo	by Roger Govier	1	1,039
Select all worksheets J Shrimps, Jr.	by Bob Phillips	1	516
HELP! Filtering and sorting lists. [email protected]	by Max	3	585
How does this formula work KB	by Bob Phillips	3	507
Auto filter no longer comes up Biged	by Dave Peterson	1	320
Colors and printing Dan wilson	by Dan Wilson	4	612
I need a formula like this "@if(2000 jlperezlafuente	by Duke Carey	2	375
Check box trs	by trs	0	295
How to sum a column of hours & minutes in format TEXT(C5-B5,"h:mm" nosam	by nosam	2	951
how to convert 357646 seconds into hh:mm:ss format? Samantha	by Fred Smith	6	963
Need a 1 Column multiplication formula for 2600 cells. How? Buckle	by JulieD	1	1,084
enable autofilter in a protected worksheet in Excel 97 WooGHeR	by Debra Dalgleish	1	1,033
How to find the second most frequent number in a list? Sam	by Sam	0	1,051
Pivot Table Grand Totals Adam	by Adam	0	828
Excel 2002 autofill and offset Tim	by Biff	3	669
how to do more than 7 if crunchh	by Myrna Larson	6	329
Inverse sin John Fitzpatrick	by Myrna Larson	3	1,212
Method of selecting an area with a macro WildGlio	by Duke Carey	1	378
How do you calculate number of workdays from dates entered? [email protected]	by [email protected]	0	732
Vlookup w/Date Function cym	by Duke Carey	1	988
My formulas does not sum together Catherine	by Catherine	2	466
Excel Solver background in forecasting modeling RL	by Michael R Middleton	3	3,057
IF Statement help... Pat	by Pat	6	434
How do you calculate number of workdays from dates entered? tfleck	by Niek Otten	1	740
Creating a macro in excel Not sure what I am doing	by Bob Phillips	1	510
Attaching a macro to a VB button on a form WildGlio	by WildGlio	2	643
Multiple Sheet workbooks [email protected]	by Gord Dibben	3	483
Can I see a list of the worksheets within a workbook without scro. shrn	by Gord Dibben	3	589
Converting text to numbers David	by David	4	713
VLOOKUP Duke Carey	by Anna	1	488
how do you add vlookup results? Anna	by JulieD	3	1,761
How do I make a copy / paste function default? Dan	by Dan	0	884
In between J Shrimps, Jr.	by Jason Morin	1	442
Macro help Dan Wilson	by Dan Wilson	2	407
Excel 2003, time scheduling? Eric G	by Biff	1	592
Formating decimal and date Rick	by Biff	1	610
add "X" to cell based on cell value thom hoyle	by JulieD	3	348
finding multiple MIN's Weekend user	by Aladin Akyurek	3	567
Delete rows not in Edit Menu NewsgroupFan	by Dave Peterson	1	410
setup Bonzo	by Bob Phillips	2	438
Button to clear all entries? Randy	by Bob Phillips	2	501
ISEVEN SimonW	by SimonW	4	410
Appending Text to a Cell Value Pappey	by Ron Rosenfeld	3	417
Understanding this formula Sal	by Sal	4	457
How do I convert 00:03:54 to get 234 seconds? SteverinoNeedsHelp	by RagDyeR	2	989
What function can make cells shift up when they are blank? Julie	by Julie	0	1,176
How do I calculate Amount of Sales Tax from Total Amount? MikeS	by Bob Phillips	1	2,809
if then else Russell Hampton	by Russell Hampton	9	482
Cell frequency II Sergio Magni	by Michael R Middleton	2	370
Count number of instances in sheet e.g. how many males/females MJ	by Chip Pearson	1	764
Add a constant to data PaulHardersen	by RagDyeR	1	834
IF Statement that's conditional on multiple IF Stmts in other cell Pat	by JE McGimpsey	1	681
Formula(ae) to mimic offsetinmg of losses against profits Bill	by Bill	0	352
Entering Data in multiple cells on one sheet & having it auto upda haynblend	by Max	2	995
Sum numbers that include #N/A ww	by ww	3	466
Formula appears as text Tiles	by JulieD	3	1,101
Counting values containing part of a cell davidm	by davidm	3	666