Excel Worksheet Functions - Page 1079

Thread / Thread Starter	Last Post	Replies	Views
Rounding to nearest integer pattyh	by Bernard Liengme	3	1,322
How to keep linked cells blank until information is entered? HollyB	by N Harkawat	1	1,479
Cell References and External Data Scott	by Scott	1	770
saving options along with spreadsheet woody	by Gord Dibben	1	574
Set a value, use it later (possible VBA?) Rich Palarea	by Gary Brown	1	326
How do I forecast monthly and annual totals from previous year's . Jeff Hart	by Jeff Hart	0	711
How to convert entire excel document from lower to upper case Paul	by Gord Dibben	2	1,435
Data validation not showing drop down Lily	by bj	1	1,143
can i sum up only visible cells? Wink	by Gord Dibben	2	1,126
Can VLOOKUP deliver the second occurence when target column entri. IdeaRat	by Alan Beban	3	760
Spread Sheet Tabs George	by Gord Dibben	9	917
How do I sort data from various worksheets in the same workbook i. Evelyne	by Evelyne	4	610
count if Help with count if	by bj	4	327
Applying a currency rate that doesn't change when source updated Redsmartie	by JulieD	3	493
indicate whether a cell contains a formula chopsx7	by Harlan Grove	5	414
Importing from other application Reggie	by Reggie	6	547
Summary of values from a date range Redsmartie	by JulieD	4	779
how do i make overtime in my payroll sheet calculate after 42.5 h. Kaye	by Kaye	0	921
Backwards lookup Derek	by Duke Carey	3	676
Set values in functions?? Fia	by JulieD	1	408
EXCEL 2003: Apply Conditional Formatting to COLUMNS HWDFWXCLGuru	by HWDFWXCLGuru	3	1,111
Calculate Due Date xgirl	by Lady Layla	10	1,635
How can I get a count of cells in a range that are shaded a certa. Slinkeysgirl	by Duke Carey	3	635
format cells Alfred	by Duke Carey	2	762
match and #ref PK	by PK	0	402
save external link values Werner Rohrmoser	by Werner Rohrmoser	0	792
EXCEL 2003 PROBLEM Amandle	by Amandle	4	1,060
Pivot table report BigBuck98	by BigBuck98	2	750
How do I sort by complete rows in excell Snoopy	by Snoopy	2	683
Help with formula please Eamon	by CLR	3	327
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	772
How to share data between worksheets? Johnny F	by Fredrik Wahlgren	1	1,411
how do you get excel o calculate antilogs Oliver Trevelyan	by Fadi Chalouhi	1	437
Datbase check gunga	by gunga	2	396
Help combine 2 formulas into 1 Robert	by Robert	5	766
How do I pull information from one worksheet to another using cer. JeAnFrLe	by Debra Dalgleish	1	491
countif/sumproduct on multiple criteria Phil.M	by Peo Sjoblom	2	853
index / match function Lisa	by Peo Sjoblom	3	732
simple formula with blank cells Brian	by Reid McTaggart	1	762
Find project start and end dates in a DB with many different proje AceWriter01	by JulieD	3	874
Old, LOTUS 1-2-3 based function Gabor Szikla	by Harlan Grove	1	484
how do i make one chart that my ees can input info, and have a se. Marina	by Marina	0	678
How can I create a formula to locate data between two dates? A shink	by JulieD	3	639
What formula do I use in Excel to determine whether one cell fall. MJaure	by JulieD	1	666
Concatenate and then limit # of characters SP	by JulieD	3	530
Creating Drop down menus in an excel cell Debbie C	by [email protected]	2	851
EI_CALC Function Patricia	by Gord Dibben	3	489
Cell content elimination; duplicate BudD	by Bernie Deitrick	1	557
Can Excel "slide up" rows with content thru empty rows to condense portly44	by Gord Dibben	2	3,377
Microsoft excel 2000 Al Martino	by Gord Dibben	2	411
How to copy conditional formatting Dan	by Gord Dibben	3	832
how do I change case in an entire column of text in Excel linpengie	by Gord Dibben	9	1,256
VLOOKUP TABLE_ARRAY veljo	by Bob Phillips	6	747
difficulty changing cell format samsmimi	by Gord Dibben	4	669
data in empty cells samsmimi	by Gord Dibben	3	725
detect cell color and count it Maileen	by Gord Dibben	2	725
inventory counting AnimationMan	by Jason Morin	1	411
Networkdays problem JamesDMartin	by Ron Rosenfeld	3	652
SUMIF problem Carla Bradley	by Jason Morin	1	555
Remove leading Numbers from text DBLWizard	by Jason Morin	2	6,159
What are the tricks using "=(SHEET1!cell_reference)". JohnR	by bj	5	415
formula SUMIF or whichever one will work for my issue Richelle	by Alok	5	663
Only want color to show when cell is active riccck	by Bob Phillips	1	544
Returning Multiple Values Based on One Value Nick	by Nick	2	1,232
Why not nest more than 7 functions in Excel formula??? GrandCentral	by Fredrik Wahlgren	9	1,007
I need to know formula for matching retirement percents pebbles2005	by Niek Otten	1	813
round up cells to $xx.99 RVV	by ww	2	972
functions pebbles2005	by ww	1	458
Absolute average Marc Fleury	by Domenic	4	563
How to calculate a sum as one outcome of an IF statement barb in NC	by barb in NC	2	1,158
formula for calculating # of days between 2 cells Lois	by Lois	5	588
delete all text that match e3grk	by JulieD	1	396
Set Tab key lakesideprocessors	by Gary Brown	1	394
quotation form heather	by heather	0	402
I need a VLOOK-UP formula that uses two look-up vaiables in seper. Doug	by JulieD	3	519