Excel Worksheet Functions - Page 803

Thread / Thread Starter	Last Post	Replies	Views
if "a" selected from dropdown menu then show "K" in other cell LEGALMATTERS	by Duke Carey	1	1,729
Copy a formula down a column Otto Moehrbach	by Otto Moehrbach	3	687
Conditional Format Issue Darkdrew	by Darkdrew	3	461
need macro to check part# and sum jg53	by Bob Phillips	8	462
How do I format to currency when number includes cents? INEEDHELP	by Pete_UK	2	1,018
Formula Help Sandy	by Sandy	0	365
counting instances of specific times in fields with date and time Rob Odum	by Rob Odum	2	645
How do you set up the data to perform a Anova 2 Factor/w reps? Mack	by Mack	2	940
Need help with formula Geobass	by Geobass	2	304
Vlookup maybe??? Tom K	by Pete_UK	4	387
Exclude data from summary totals when hidden XVOTE	by LTUser54	1	891
Compare one Column to a Second Column Formula Help Needed jeffc	by Bob Phillips	1	580
Formula to return a value if any numbers in a group meet a criteri dcozzi	by dcozzi	3	523
Adding columns in Pivot Table having coomon description sayvari	by John James	1	451
columns on worksheet2 don't sort with worksheet1 PatAlexander	by John James	1	583
How do i populate a text box according to selection in combobox? Steve	by Steve	0	951
Matching multiple columns Rothman	by JR	5	611
How do I set up a formula for parts (or units) per hour? Ender-DI	by Duke Carey	10	5,453
stumped ?? my	by Duke Carey	2	515
skip rows marat	by JE McGimpsey	1	526
How to draw a circle in excel with specific radius Mile	by Arvi Laanemets	1	2,281
parsing text in a multiple column count JK57	by John James	3	833
Intergrate data area in a function istratos	by Ardus Petus	1	452
Hiding Rows if Blank cell mohd21uk via OfficeKB.com	by rajkohli	3	3,439
Pop up windows in excel Darren1o1	by Darren1o1	0	365
Make cells flash. aacstv	by Peo Sjobom	1	330
Arrange numbers in a sequence Joe	by Joe	2	460
Which formula should I use? [email protected]	by Biff	1	335
Need a function to convert value in its name Abraham	by MageeStringer	2	498
How do I speed up recalcs when using lots of SUMPRODUCT formulas Peterdout	by Mikeopolo	2	815
Summing every other cell in a column? RJH	by RJH	4	348
deleting line item in import function causes REF# error Jen	by John James	1	472
If stmt and assigning a value to another cell lovethepirk	by Max	3	493
transfer data from sheet1 to sheet 2 joe311	by Max	5	1,070
get date with now() today() but dont update with recalc robert w	by CLR	1	527
Need Help with formula Mark B	by Mark B	2	342
GetPivotData need help [email protected]	by Debra Dalgleish	2	589
Pivot Table - creating % of Totals BernzG	by Debra Dalgleish	3	513
time addition to predict finish time Martin B	by Sandy Mann	5	864
Using Mode in Excel, need more than 1st most frequent number. waterdancn	by Peo Sjoblom	2	712
Combo boxes and formulas TC	by TC	4	514
Truncate words [email protected]	by [email protected]	2	682
Using Concatenate operator to overcome 7 nested IF's TG	by Bob Phillips	1	612
sumif with multiple conditions Slax	by Slax	5	709
Average range including blank cells: #DIV/0! Areaka	by Areaka	3	1,000
How to display two worksheets from the same workbook side-by-side Darlene Teas	by Darlene Teas	2	3,004
Choosing which sheet opens josephdmcc	by Dave Peterson	1	451
Address of Maximum value in Cell Session101	by Peo Sjoblom	1	911
Excel conditional sum bloop	by Roberto	9	467
Adding columns in Pivot Table having common description sayvari	by sayvari	2	619
Vlookup Displays Blank Jani	by Jani	8	431
Conditional page break if merged rows won't fit on the page. zbprtal	by William Horton	1	1,017
LINKING WORKSHEETS CANDY L	by Gord Dibben	1	404
Can a linked hyperlink be updated Tgivin	by Tgivin	0	459
Multiple conditions in a formula TV	by CLR	3	651
An "If" statement coded in a macro rojobrown	by Bob Phillips	2	503
SUMPRODUCT Criteria Via Cell Reference?? John V	by Bob Phillips	8	1,730
Validating non-blank cells in workbook cboyko	by Dave Peterson	1	399
Can anyone tell me what's wrong with this formula? Linda	by ChE_maynard	5	420
How to extract multiple cells based on one value Extrer datos en excel	by Extrer datos en excel	0	449
How to total rows in Excel with non-value cells like "included"? HR	by HR	2	746
vlookup returns last value in array Nicholas Scarpinato	by Duke Carey	3	1,081
How do I anchor a cell/create absolute ref. while clicking on it? dsapan	by Duke Carey	1	710
Multiple Subtotal levels in Excel 2003 Chris Luka	by Chris Luka	2	973
OFFSET function returning #VALUE when using external references AndrewPace	by AndrewPace	2	1,741
lookup with more then one codition zia	by Bob Phillips	1	340
Rounding to a specific value (up or down) Dave	by Ron Coderre	3	386
Wildcard IF formula Goh Han	by Biff	3	870
PHONE NUMBER formatting [email protected]	by Beege	3	477
copying a reference jrw	by Gary L Brown	1	361
Download An Open Letter From Al-RASHEDEEN Army To The American President qqqqqqq	by JR	1	364
Address for Linked Files in Formula kohai	by JR	1	671
what's the formula for finding 401(k)? Manuel H. Cruz	by JR	1	373
Convert Excel 4 formula to Excel 2003 format The Gasell	by JE McGimpsey	3	1,055
When I open a workbook, how can I choose which worksheet opens? josephdmcc	by JR	1	516