Excel Worksheet Functions - Page 1079

Thread / Thread Starter	Last Post	Replies	Views
Rounding to nearest integer pattyh	by Bernard Liengme	3	1,354
How to keep linked cells blank until information is entered? HollyB	by N Harkawat	1	1,508
Cell References and External Data Scott	by Scott	1	791
saving options along with spreadsheet woody	by Gord Dibben	1	592
Set a value, use it later (possible VBA?) Rich Palarea	by Gary Brown	1	336
How do I forecast monthly and annual totals from previous year's . Jeff Hart	by Jeff Hart	0	723
How to convert entire excel document from lower to upper case Paul	by Gord Dibben	2	1,459
Data validation not showing drop down Lily	by bj	1	1,169
can i sum up only visible cells? Wink	by Gord Dibben	2	1,138
Can VLOOKUP deliver the second occurence when target column entri. IdeaRat	by Alan Beban	3	769
Spread Sheet Tabs George	by Gord Dibben	9	938
How do I sort data from various worksheets in the same workbook i. Evelyne	by Evelyne	4	624
count if Help with count if	by bj	4	335
Applying a currency rate that doesn't change when source updated Redsmartie	by JulieD	3	508
indicate whether a cell contains a formula chopsx7	by Harlan Grove	5	421
Importing from other application Reggie	by Reggie	6	556
Summary of values from a date range Redsmartie	by JulieD	4	801
how do i make overtime in my payroll sheet calculate after 42.5 h. Kaye	by Kaye	0	937
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,126
Calculate Due Date xgirl	by Lady Layla	10	1,669
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	785
match and #ref PK	by PK	0	416
save external link values Werner Rohrmoser	by Werner Rohrmoser	0	821
EXCEL 2003 PROBLEM Amandle	by Amandle	4	1,081
Pivot table report BigBuck98	by BigBuck98	2	764
How do I sort by complete rows in excell Snoopy	by Snoopy	2	695
Help with formula please Eamon	by CLR	3	339
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	782
How to share data between worksheets? Johnny F	by Fredrik Wahlgren	1	1,419
how do you get excel o calculate antilogs Oliver Trevelyan	by Fadi Chalouhi	1	446
Datbase check gunga	by gunga	2	406
Help combine 2 formulas into 1 Robert	by Robert	5	789
How do I pull information from one worksheet to another using cer. JeAnFrLe	by Debra Dalgleish	1	503
countif/sumproduct on multiple criteria Phil.M	by Peo Sjoblom	2	870
index / match function Lisa	by Peo Sjoblom	3	746
simple formula with blank cells Brian	by Reid McTaggart	1	785
Find project start and end dates in a DB with many different proje AceWriter01	by JulieD	3	903
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	696
How can I create a formula to locate data between two dates? A shink	by JulieD	3	658
What formula do I use in Excel to determine whether one cell fall. MJaure	by JulieD	1	681
Concatenate and then limit # of characters SP	by JulieD	3	541
Creating Drop down menus in an excel cell Debbie C	by [email protected]	2	870
EI_CALC Function Patricia	by Gord Dibben	3	494
Cell content elimination; duplicate BudD	by Bernie Deitrick	1	570
Can Excel "slide up" rows with content thru empty rows to condense portly44	by Gord Dibben	2	3,395
Microsoft excel 2000 Al Martino	by Gord Dibben	2	416
How to copy conditional formatting Dan	by Gord Dibben	3	858
how do I change case in an entire column of text in Excel linpengie	by Gord Dibben	9	1,289
VLOOKUP TABLE_ARRAY veljo	by Bob Phillips	6	760
difficulty changing cell format samsmimi	by Gord Dibben	4	688
data in empty cells samsmimi	by Gord Dibben	3	751
detect cell color and count it Maileen	by Gord Dibben	2	738
inventory counting AnimationMan	by Jason Morin	1	429
Networkdays problem JamesDMartin	by Ron Rosenfeld	3	667
SUMIF problem Carla Bradley	by Jason Morin	1	569
Remove leading Numbers from text DBLWizard	by Jason Morin	2	6,217
What are the tricks using "=(SHEET1!cell_reference)". JohnR	by bj	5	426
formula SUMIF or whichever one will work for my issue Richelle	by Alok	5	680
Only want color to show when cell is active riccck	by Bob Phillips	1	569
Returning Multiple Values Based on One Value Nick	by Nick	2	1,256
Why not nest more than 7 functions in Excel formula??? GrandCentral	by Fredrik Wahlgren	9	1,023
I need to know formula for matching retirement percents pebbles2005	by Niek Otten	1	825
round up cells to $xx.99 RVV	by ww	2	979
functions pebbles2005	by ww	1	472
Absolute average Marc Fleury	by Domenic	4	577
How to calculate a sum as one outcome of an IF statement barb in NC	by barb in NC	2	1,178
formula for calculating # of days between 2 cells Lois	by Lois	5	600
delete all text that match e3grk	by JulieD	1	404
Set Tab key lakesideprocessors	by Gary Brown	1	404
quotation form heather	by heather	0	409
I need a VLOOK-UP formula that uses two look-up vaiables in seper. Doug	by JulieD	3	529