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	588
statistical functions agenda9533	by Michael R Middleton	2	599
YTD Budget Sum if Actual Month has activities AGnes	by Gary Brown	1	1,569
Find a non-blank cell and bring back text a in same row Rod	by Rod	12	1,889
Can you password an Excel worksheet, if so how? Coga	by Trevor Shuttleworth	1	614
Autofill Confused?	by Gord Dibben	1	567
Question about sorting in protected worksheet SJC	by Gord Dibben	6	1,255
Mod-10 Check Digit Union70	by Myrna Larson	1	2,007
Move rows to columns Daniell	by Daniell	2	804
hOW DO I GET THE XCELL FUNCTION CUMPRINC TO WORK? Asterix	by Gord Dibben	1	771
How can I make a timesheet to figure my hours and payrate? Bruce	by Gord Dibben	2	1,077
filter and keep same information. WellsDesign	by CLR	3	485
How do I set up IRR and NPV functions in Excel? John Rovenolt	by Gord Dibben	2	1,033
Links Problem DSE	by Dave Peterson	2	759
designing and saving predefined pivot table formats? Surfstiling	by Debra Dalgleish	1	670
How 2 rotate information in a working shift pattern Xeraco	by JulieD	3	510
find previous row for an item HedwigVB	by HedwigVB	2	473
Sort Data by Frequency Susan Smith	by Myrna Larson	1	1,285
calculate totals of 5 sheets on to 6th sheet. salvo	by Roger Govier	1	1,033
Select all worksheets J Shrimps, Jr.	by Bob Phillips	1	513
HELP! Filtering and sorting lists. [email protected]	by Max	3	580
How does this formula work KB	by Bob Phillips	3	502
Auto filter no longer comes up Biged	by Dave Peterson	1	299
Colors and printing Dan wilson	by Dan Wilson	4	606
I need a formula like this "@if(2000 jlperezlafuente	by Duke Carey	2	374
Check box trs	by trs	0	293
How to sum a column of hours & minutes in format TEXT(C5-B5,"h:mm" nosam	by nosam	2	942
how to convert 357646 seconds into hh:mm:ss format? Samantha	by Fred Smith	6	961
Need a 1 Column multiplication formula for 2600 cells. How? Buckle	by JulieD	1	1,078
enable autofilter in a protected worksheet in Excel 97 WooGHeR	by Debra Dalgleish	1	1,006
How to find the second most frequent number in a list? Sam	by Sam	0	1,048
Pivot Table Grand Totals Adam	by Adam	0	824
Excel 2002 autofill and offset Tim	by Biff	3	667
how to do more than 7 if crunchh	by Myrna Larson	6	327
Inverse sin John Fitzpatrick	by Myrna Larson	3	1,207
Method of selecting an area with a macro WildGlio	by Duke Carey	1	373
How do you calculate number of workdays from dates entered? [email protected]	by [email protected]	0	731
Vlookup w/Date Function cym	by Duke Carey	1	986
My formulas does not sum together Catherine	by Catherine	2	464
Excel Solver background in forecasting modeling RL	by Michael R Middleton	3	3,055
IF Statement help... Pat	by Pat	6	433
How do you calculate number of workdays from dates entered? tfleck	by Niek Otten	1	736
Creating a macro in excel Not sure what I am doing	by Bob Phillips	1	507
Attaching a macro to a VB button on a form WildGlio	by WildGlio	2	635
Multiple Sheet workbooks [email protected]	by Gord Dibben	3	481
Can I see a list of the worksheets within a workbook without scro. shrn	by Gord Dibben	3	565
Converting text to numbers David	by David	4	707
VLOOKUP Duke Carey	by Anna	1	480
how do you add vlookup results? Anna	by JulieD	3	1,734
How do I make a copy / paste function default? Dan	by Dan	0	878
In between J Shrimps, Jr.	by Jason Morin	1	426
Macro help Dan Wilson	by Dan Wilson	2	405
Excel 2003, time scheduling? Eric G	by Biff	1	588
Formating decimal and date Rick	by Biff	1	603
add "X" to cell based on cell value thom hoyle	by JulieD	3	347
finding multiple MIN's Weekend user	by Aladin Akyurek	3	562
Delete rows not in Edit Menu NewsgroupFan	by Dave Peterson	1	400
setup Bonzo	by Bob Phillips	2	417
Button to clear all entries? Randy	by Bob Phillips	2	495
ISEVEN SimonW	by SimonW	4	406
Appending Text to a Cell Value Pappey	by Ron Rosenfeld	3	417
Understanding this formula Sal	by Sal	4	456
How do I convert 00:03:54 to get 234 seconds? SteverinoNeedsHelp	by RagDyeR	2	984
What function can make cells shift up when they are blank? Julie	by Julie	0	1,171
How do I calculate Amount of Sales Tax from Total Amount? MikeS	by Bob Phillips	1	2,808
if then else Russell Hampton	by Russell Hampton	9	481
Cell frequency II Sergio Magni	by Michael R Middleton	2	369
Count number of instances in sheet e.g. how many males/females MJ	by Chip Pearson	1	763
Add a constant to data PaulHardersen	by RagDyeR	1	833
IF Statement that's conditional on multiple IF Stmts in other cell Pat	by JE McGimpsey	1	673
Formula(ae) to mimic offsetinmg of losses against profits Bill	by Bill	0	351
Entering Data in multiple cells on one sheet & having it auto upda haynblend	by Max	2	989
Sum numbers that include #N/A ww	by ww	3	464
Formula appears as text Tiles	by JulieD	3	1,099
Counting values containing part of a cell davidm	by davidm	3	664