Excel Worksheet Functions - Page 84

Thread / Thread Starter	Last Post	Replies	Views
how do i set up a calendar selection in excel Phil	by Gord Dibben	1	1,847
EDate function + #NAME? error Lina	by Ron Rosenfeld	10	1,847
how do i do interest roll up calculation in excel Steve Costello	by Spiky	2	1,847
how do I repeat a drop down box Need help	by Debra Dalgleish	2	1,847
Calculate Years of Service Jerry	by Gilles Desjardins	5	1,847
Can a date range be used in SUMPRODUCT bruce	by bruce	2	1,846
how do i enter a bull call spread into the options spread sheet ? alvin smith	by alvin smith	0	1,846
hex to decimal convert Nadia	by Ron Rosenfeld	4	1,846
Team Role Rotation (number of team members is variable) Scott Wagner	by Pete_UK	3	1,846
Conditional Formatting with VLookup and Offset functions Phrank	by Claus Busch	2	1,846
use sumif with criteria including sheet name SleepyCat	by T. Valko	4	1,845
If/Then functions Grimsgrin	by Ron Rosenfeld[_2_]	1	1,845
using a conditional suffix in text function format syntax=text(value,format_text) Brotherharry	by JE McGimpsey	1	1,845
how do i open an ods file in excel? JIREH	by AnimalMagic	2	1,845
create macro - if cell is 0 delete row pywhacket	by Tom Ogilvy	1	1,845
TAN INVERSE ? Ahsan	by Mike H	3	1,845
Calculating a Check Digit Routine rojobrown	by barry houdini[_37_]	4	1,845
Can an Excel Spreadsheet automatically sort new data? Stumped	by Stumped	2	1,845
Formula for Gross Profit % to commission % based on GP $ Antveenie	by pmartglass	2	1,845
calculate square feet Walt	by Jacob Skaria	4	1,844
Match a cell to something in a column and return a YES Kathy	by Bob Phillips	1	1,844
Sumif for groups and subgroups / Excel 2003 mwear	by Pete_UK	9	1,844
Move merged cells with conditional formatting? SpikeUK	by SpikeUK	11	1,843
Calculate average of ratings as a function of length rodeo	by Bernard Liengme	2	1,843
Condtional Quartile statement Verizon news	by Peo Sjoblom	3	1,843
rank the numbers / range of data using 'RANK' and 'ABS' KP	by Rick Rothstein $MVP - VB$[_162_]	1	1,843
Find a value Using a lookup table multiple columns and rows glasspumpkin	by glasspumpkin	4	1,843
match and count words David	by Max	5	1,843
feet and inches to meters scott	by David Biddulph[_2_]	4	1,843
Excel Map function Karen Yandle via OfficeKB.com	by Gord Dibben	1	1,843
compare two columns within a worksheet, then highlight duplicates Beth	by Bernard Liengme	1	1,843
Excel 2003, SUM left-most characters David Aukerman	by T. Valko	13	1,842
SUMPRODUCT use of --() syntax Stephen Lloyd[_2_]	by Stephen Lloyd[_2_]	2	1,842
Total Time to Resolution LJ[_2_]	by Glenn	1	1,842
Sum column based on value in each row, if two cells equal, or if date is within time period [email protected]	by Carim	8	1,842
How to do I convert angles from radians to degrees in Excel? HELP ME PLEASE!!!!!	by David Billigmeier	2	1,842
Conditional Formating to Show Numbers NOT Divisible by another Sliver Rayne	by T. Valko	3	1,841
Stratify Data In a Range Johnny Stranger	by Dave Peterson	6	1,841
Compound Interest Rate or Growth Rate 1944-71222	by Fred Smith[_4_]	2	1,841
How to show zero for #DIV/0! Brett Romero	by CLR	3	1,841
with weekly score sheet how do I column a weekly progressive aver. tom	by tom	2	1,840
VLOOKUP with IF logic Rae	by John C[_2_]	5	1,840
What formula do I use to copy only text on left side of a comma? Danielsjt	by JLatham	4	1,840
how do I divide or multiply an entire column? 1number	by Gord Dibben	4	1,840
due date for payable invoice due date for payable invoice	by Duke Carey	2	1,840
Variable Input Range for Combo Box Defoes Right Boot	by Defoes Right Boot	2	1,840
feel that the STANDARD DEVIATION formula on Excel is incorrect !! Ganapati Hegde	by ribbin	3	1,840
Excel 2000, count, sort a list & count totals? sunslight	by Dave F	1	1,840
Return Summed Count of Multiple Consecutive Numeric Values Sam via OfficeKB.com	by Sam via OfficeKB.com	4	1,839
Labeling Grouped & Collapsed Columns trickyfingers28	by trickyfingers28	0	1,839
Lookup cell value using list of worksheet names amaranth	by KL	5	1,839
How to delete a macro that has been assigned to run when workshee. tcsigecan	by Bernie Deitrick	1	1,839
Gridlines are not printing in Excel although box is checked Jacy needs help	by Gord Dibben	3	1,839
Sum working days NM	by T. Valko	13	1,839
Formula to return cell position AJPendragon	by Gary''s Student	1	1,838
how to find common cells in several columns Landa	by vezerid	3	1,838
HOW TO CALCULATE 2/10 OF 1 PERCENT OF A TOTAL NUMBER? AMANDA RILEY	by [email protected]	4	1,838
count rows that meet two criteria in two different columns? dsk3808	by JonR	6	1,838
count cells over multiple sheets Have three columns R,S,T	by Frank Kabel	4	1,838
Is there an array size limit for MMULT or MINVERSE in excel 2007? jimr315	by Harlan Grove	4	1,837
SumIf - when I fill down the Range, Criteria & sum range changes markholt	by Sheeloo[_3_]	3	1,837
how can i round in excel to the nearest thousand Jamie	by Rick Rothstein $MVP - VB$	10	1,837
Add numbers for duplicate entries then delete Chillygoose	by Frank Kabel	1	1,837
Solver returns non binary answer in binary constrained cells Navy Student	by Navy Student	6	1,837
count if the cell contains a word found in another cell Go Bucks!!![_2_]	by Go Bucks!!![_2_]	2	1,836
MedianIf multiple range and criteria C.	by T. Valko	5	1,836
Rename Defined Names Sige	by Sige	3	1,836
How to Find Weekend date Mike Metal	by JE McGimpsey	3	1,836
Accrue & Calculate pd leave across sheets hixnstix	by wickedchew	1	1,836
Distance between two GPS points (Decimal degrees) David Reavill	by David Reavill	0	1,836
excel not copying formulas/formatting to next row? neowok	by JE McGimpsey	2	1,836
vlookup and using single quote Bishop	by joel	2	1,835
Find MAX number with criteria GoBow777	by GoBow777	5	1,835
How do I add up the last 12 cells (containing values) in a column. Michelle D	by Teethless mama	4	1,835
How do I set up Reminders in an excel spreadsheet? Chilli Mel	by Flintstone	1	1,835