Excel Worksheet Functions - Page 1079

Thread / Thread Starter	Last Post	Replies	Views
Rounding to nearest integer pattyh	by Bernard Liengme	3	1,445
How to keep linked cells blank until information is entered? HollyB	by N Harkawat	1	1,533
Cell References and External Data Scott	by Scott	1	799
saving options along with spreadsheet woody	by Gord Dibben	1	596
Set a value, use it later (possible VBA?) Rich Palarea	by Gary Brown	1	338
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,472
Data validation not showing drop down Lily	by bj	1	1,177
can i sum up only visible cells? Wink	by Gord Dibben	2	1,139
Can VLOOKUP deliver the second occurence when target column entri. IdeaRat	by Alan Beban	3	770
Spread Sheet Tabs George	by Gord Dibben	9	944
How do I sort data from various worksheets in the same workbook i. Evelyne	by Evelyne	4	625
count if Help with count if	by bj	4	336
Applying a currency rate that doesn't change when source updated Redsmartie	by JulieD	3	509
indicate whether a cell contains a formula chopsx7	by Harlan Grove	5	423
Importing from other application Reggie	by Reggie	6	562
Summary of values from a date range Redsmartie	by JulieD	4	807
how do i make overtime in my payroll sheet calculate after 42.5 h. Kaye	by Kaye	0	939
Backwards lookup Derek	by Duke Carey	3	694
Set values in functions?? Fia	by JulieD	1	417
EXCEL 2003: Apply Conditional Formatting to COLUMNS HWDFWXCLGuru	by HWDFWXCLGuru	3	1,127
Calculate Due Date xgirl	by Lady Layla	10	1,672
How can I get a count of cells in a range that are shaded a certa. Slinkeysgirl	by Duke Carey	3	642
format cells Alfred	by Duke Carey	2	789
match and #ref PK	by PK	0	416
save external link values Werner Rohrmoser	by Werner Rohrmoser	0	823
EXCEL 2003 PROBLEM Amandle	by Amandle	4	1,112
Pivot table report BigBuck98	by BigBuck98	2	767
How do I sort by complete rows in excell Snoopy	by Snoopy	2	698
Help with formula please Eamon	by CLR	3	340
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	785
How to share data between worksheets? Johnny F	by Fredrik Wahlgren	1	1,425
how do you get excel o calculate antilogs Oliver Trevelyan	by Fadi Chalouhi	1	449
Datbase check gunga	by gunga	2	408
Help combine 2 formulas into 1 Robert	by Robert	5	868
How do I pull information from one worksheet to another using cer. JeAnFrLe	by Debra Dalgleish	1	569
countif/sumproduct on multiple criteria Phil.M	by Peo Sjoblom	2	873
index / match function Lisa	by Peo Sjoblom	3	746
simple formula with blank cells Brian	by Reid McTaggart	1	786
Find project start and end dates in a DB with many different proje AceWriter01	by JulieD	3	914
Old, LOTUS 1-2-3 based function Gabor Szikla	by Harlan Grove	1	494
how do i make one chart that my ees can input info, and have a se. Marina	by Marina	0	700
How can I create a formula to locate data between two dates? A shink	by JulieD	3	660
What formula do I use in Excel to determine whether one cell fall. MJaure	by JulieD	1	692
Concatenate and then limit # of characters SP	by JulieD	3	543
Creating Drop down menus in an excel cell Debbie C	by [email protected]	2	876
EI_CALC Function Patricia	by Gord Dibben	3	495
Cell content elimination; duplicate BudD	by Bernie Deitrick	1	573
Can Excel "slide up" rows with content thru empty rows to condense portly44	by Gord Dibben	2	3,400
Microsoft excel 2000 Al Martino	by Gord Dibben	2	420
How to copy conditional formatting Dan	by Gord Dibben	3	864
how do I change case in an entire column of text in Excel linpengie	by Gord Dibben	9	1,295
VLOOKUP TABLE_ARRAY veljo	by Bob Phillips	6	762
difficulty changing cell format samsmimi	by Gord Dibben	4	693
data in empty cells samsmimi	by Gord Dibben	3	754
detect cell color and count it Maileen	by Gord Dibben	2	743
inventory counting AnimationMan	by Jason Morin	1	433
Networkdays problem JamesDMartin	by Ron Rosenfeld	3	669
SUMIF problem Carla Bradley	by Jason Morin	1	575
Remove leading Numbers from text DBLWizard	by Jason Morin	2	6,224
What are the tricks using "=(SHEET1!cell_reference)". JohnR	by bj	5	431
formula SUMIF or whichever one will work for my issue Richelle	by Alok	5	684
Only want color to show when cell is active riccck	by Bob Phillips	1	570
Returning Multiple Values Based on One Value Nick	by Nick	2	1,262
Why not nest more than 7 functions in Excel formula??? GrandCentral	by Fredrik Wahlgren	9	1,029
I need to know formula for matching retirement percents pebbles2005	by Niek Otten	1	827
round up cells to $xx.99 RVV	by ww	2	981
functions pebbles2005	by ww	1	476
Absolute average Marc Fleury	by Domenic	4	578
How to calculate a sum as one outcome of an IF statement barb in NC	by barb in NC	2	1,185
formula for calculating # of days between 2 cells Lois	by Lois	5	602
delete all text that match e3grk	by JulieD	1	407
Set Tab key lakesideprocessors	by Gary Brown	1	404
quotation form heather	by heather	0	410
I need a VLOOK-UP formula that uses two look-up vaiables in seper. Doug	by JulieD	3	542