Excel Worksheet Functions - Page 1079

Thread / Thread Starter	Last Post	Replies	Views
Rounding to nearest integer pattyh	by Bernard Liengme	3	1,448
How to keep linked cells blank until information is entered? HollyB	by N Harkawat	1	1,543
Cell References and External Data Scott	by Scott	1	810
saving options along with spreadsheet woody	by Gord Dibben	1	605
Set a value, use it later (possible VBA?) Rich Palarea	by Gary Brown	1	349
How do I forecast monthly and annual totals from previous year's . Jeff Hart	by Jeff Hart	0	726
How to convert entire excel document from lower to upper case Paul	by Gord Dibben	2	1,485
Data validation not showing drop down Lily	by bj	1	1,185
can i sum up only visible cells? Wink	by Gord Dibben	2	1,149
Can VLOOKUP deliver the second occurence when target column entri. IdeaRat	by Alan Beban	3	785
Spread Sheet Tabs George	by Gord Dibben	9	945
How do I sort data from various worksheets in the same workbook i. Evelyne	by Evelyne	4	641
count if Help with count if	by bj	4	346
Applying a currency rate that doesn't change when source updated Redsmartie	by JulieD	3	517
indicate whether a cell contains a formula chopsx7	by Harlan Grove	5	432
Importing from other application Reggie	by Reggie	6	568
Summary of values from a date range Redsmartie	by JulieD	4	817
how do i make overtime in my payroll sheet calculate after 42.5 h. Kaye	by Kaye	0	942
Backwards lookup Derek	by Duke Carey	3	701
Set values in functions?? Fia	by JulieD	1	429
EXCEL 2003: Apply Conditional Formatting to COLUMNS HWDFWXCLGuru	by HWDFWXCLGuru	3	1,139
Calculate Due Date xgirl	by Lady Layla	10	1,673
How can I get a count of cells in a range that are shaded a certa. Slinkeysgirl	by Duke Carey	3	657
format cells Alfred	by Duke Carey	2	802
match and #ref PK	by PK	0	417
save external link values Werner Rohrmoser	by Werner Rohrmoser	0	832
EXCEL 2003 PROBLEM Amandle	by Amandle	4	1,117
Pivot table report BigBuck98	by BigBuck98	2	781
How do I sort by complete rows in excell Snoopy	by Snoopy	2	705
Help with formula please Eamon	by CLR	3	348
in excel how do I show a number as an alpha eg 65 as sixty five? Changing numbers to Alpha in Excel	by Niek Otten	5	793
How to share data between worksheets? Johnny F	by Fredrik Wahlgren	1	1,428
how do you get excel o calculate antilogs Oliver Trevelyan	by Fadi Chalouhi	1	460
Datbase check gunga	by gunga	2	421
Help combine 2 formulas into 1 Robert	by Robert	5	876
How do I pull information from one worksheet to another using cer. JeAnFrLe	by Debra Dalgleish	1	579
countif/sumproduct on multiple criteria Phil.M	by Peo Sjoblom	2	884
index / match function Lisa	by Peo Sjoblom	3	752
simple formula with blank cells Brian	by Reid McTaggart	1	798
Find project start and end dates in a DB with many different proje AceWriter01	by JulieD	3	928
Old, LOTUS 1-2-3 based function Gabor Szikla	by Harlan Grove	1	509
how do i make one chart that my ees can input info, and have a se. Marina	by Marina	0	711
How can I create a formula to locate data between two dates? A shink	by JulieD	3	670
What formula do I use in Excel to determine whether one cell fall. MJaure	by JulieD	1	704
Concatenate and then limit # of characters SP	by JulieD	3	554
Creating Drop down menus in an excel cell Debbie C	by [email protected]	2	886
EI_CALC Function Patricia	by Gord Dibben	3	510
Cell content elimination; duplicate BudD	by Bernie Deitrick	1	585
Can Excel "slide up" rows with content thru empty rows to condense portly44	by Gord Dibben	2	3,414
Microsoft excel 2000 Al Martino	by Gord Dibben	2	424
How to copy conditional formatting Dan	by Gord Dibben	3	877
how do I change case in an entire column of text in Excel linpengie	by Gord Dibben	9	1,300
VLOOKUP TABLE_ARRAY veljo	by Bob Phillips	6	775
difficulty changing cell format samsmimi	by Gord Dibben	4	702
data in empty cells samsmimi	by Gord Dibben	3	766
detect cell color and count it Maileen	by Gord Dibben	2	757
inventory counting AnimationMan	by Jason Morin	1	446
Networkdays problem JamesDMartin	by Ron Rosenfeld	3	681
SUMIF problem Carla Bradley	by Jason Morin	1	585
Remove leading Numbers from text DBLWizard	by Jason Morin	2	6,238
What are the tricks using "=(SHEET1!cell_reference)". JohnR	by bj	5	439
formula SUMIF or whichever one will work for my issue Richelle	by Alok	5	687
Only want color to show when cell is active riccck	by Bob Phillips	1	584
Returning Multiple Values Based on One Value Nick	by Nick	2	1,268
Why not nest more than 7 functions in Excel formula??? GrandCentral	by Fredrik Wahlgren	9	1,040
I need to know formula for matching retirement percents pebbles2005	by Niek Otten	1	831
round up cells to $xx.99 RVV	by ww	2	993
functions pebbles2005	by ww	1	490
Absolute average Marc Fleury	by Domenic	4	590
How to calculate a sum as one outcome of an IF statement barb in NC	by barb in NC	2	1,195
formula for calculating # of days between 2 cells Lois	by Lois	5	611
delete all text that match e3grk	by JulieD	1	421
Set Tab key lakesideprocessors	by Gary Brown	1	417
quotation form heather	by heather	0	422
I need a VLOOK-UP formula that uses two look-up vaiables in seper. Doug	by JulieD	3	555