Excel Worksheet Functions - Page 1007

Thread / Thread Starter	Last Post	Replies	Views
Locked cells not updating Jamie	by Jamie	0	1,211
How do I make a column that calculates gross margin percentage JImv	by John Mansfield	1	1,212
convert a value to a text incl apostrophe within the cell Jakob	by Beege	2	1,212
Capital account management BLIPSKYCPA	by Duke Carey	1	1,212
How to validate a cell to insert from 9 digit number to 13 digit number. ramulu	by john	1	1,212
Function to return a month name from a number (1-12) that is not a Chuck M	by Pete_UK	7	1,212
Sorting Data From One Column into Multiple Columns Justin Hoffmann	by Justin Hoffmann	2	1,212
Sumif date range Delsy	by Jim Cone[_2_]	6	1,212
Seperate cell string into individual cells ERudy	by Biff	2	1,212
How do I apply a formula to multiple rows at the same time? ManhattanRebel	by Dave Peterson	1	1,212
Insert "Proper Function" into existing macro jackel[_14_]	by jackel[_17_]	10	1,212
Function works in one cell but not another myssieh	by Duke Carey	2	1,212
Vlookup in reverse order PJFry	by Chip Pearson	6	1,212
Dependent List (via Data Validation) Error Dezdan	by Dezdan	2	1,212
Counting number of time a character appears in a string Henrik	by Ron Rosenfeld	5	1,212
Updated Formula question TLC	by Pete_UK	10	1,212
real-time countdown scottmiller	by Lomax	2	1,212
Is there a way... salgud	by salgud	5	1,212
IF or Vlookup or.... Which is best for this example: SSHO_99	by chadt74	10	1,212
pivot table yllee70	by Debra Dalgleish	1	1,212
How to return column header contents when a cell in the column has a value [email protected]	by Claus Busch	1	1,212
Remove weekends rhhince[_2_]	by Ashish Mathur[_2_]	2	1,212
.numberformat Q Aaron	by Rick Rothstein	4	1,212
Cell formula that will give back the address of the cursor? Byron	by T. Valko	1	1,212
Time calculations over 24hrs Ian R[_3_]	by Ian R[_3_]	5	1,212
Replace #N/A via sctipt [email protected]	by [email protected]	0	1,213
insert page number in work sheet Nandkish	by Nandkish	2	1,213
Net Present Worth of reptitive costs? dexoey	by Financial Engineer	3	1,213
Help Please.....numbers reaching limits and cells changing colour mgoo	by mgoo	3	1,213
countif two conditions met Jerry	by Jacob Skaria	2	1,213
Character Encoding Casi12	by Jacob Skaria	1	1,213
Running total over a find number of days Zorro[_2_]	by Zorro[_2_]	15	1,213
Why won't target cell data changes trigger formula evaluation? laura_in_abq	by Gord Dibben	3	1,213
nesting more than 7 functions? Brian	by Roger Govier[_3_]	11	1,213
How can I sort a list of numbers by the last 4 digits? Kristin S	by Chin via OfficeKB.com	3	1,213
Can Excel advanced filter be used in "and NOT" mode Robert	by Peo Sjoblom	1	1,213
Look up/math text JN	by Aladin Akyurek	11	1,213
How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? excelnovice	by Richard Buttrey	2	1,213
Put comments on a locked spreadsheet even though cells not locked RDP	by Debra Dalgleish	1	1,213
#NUM errors when calculating IRR [email protected]	by [email protected]	7	1,213
Accessing WorksheetFunction.XX from regular C# Forms application Jes Ramsing	by Jens Thiel	1	1,213
Sumproduct with date range ermeko	by Bob Phillips	6	1,213
Inverse sin John Fitzpatrick	by Myrna Larson	3	1,213
CELL IS NOT ACCODATING MORE THAN 12 NUMBRS HOW TO ENTER 15 DIGIT LOGANATHAN IYER	by David Biddulph[_2_]	2	1,214
why am I getting "#N/A"? Marc Bobrow	by Marc Bobrow	3	1,214
MAX/MIN with SUMPRODUCT [email protected]	by Max	7	1,214
Sort Columns of data at the same time, without regard to order. Herc	by Ashish Mathur[_2_]	3	1,214
Count the number of dates in a range that are earlier than today. DeborahS	by CLR	1	1,214
how do i change cell text colour based on value in other cell Oscarrot	by Max	2	1,214
EXCEL - LINKS cannot easily get list of all links & names in book Tuba Joe	by Gord Dibben	1	1,214
My formulas return the formula not a result in the cell 1stcoast	by IronMan	7	1,214
Function to find only exact matches in spreadsheets? Pam1288	by bpeltzer	3	1,214
How to make a cell copy the fill colour of another cell Chase	by Gary''s Student	1	1,214
automate row insert to archive tfrentz	by Don Guillett	15	1,214
Automatically copy formulas/functions to inserted rows. Barbara	by Gord Dibben	7	1,214
Select the most recent date dbs	by Don Guillett	4	1,214
Macro Auto-update of data labels [email protected]	by [email protected]	0	1,214
can a function return part of it's result in italics? Jamie	by Dave	1	1,214
If...then "0", if greater than, then enter actual JcR	by JcR	5	1,214
Excel'de yediden fazla EÄžER (IF) fonksiyonunun kullanÄ±mÄ±. Tulkas	by Tulkas	0	1,214
Any way to change generic icons in quick access toolbar? Marti	by Ron de Bruin	6	1,215
how to calculate average loan period of a 5 year loan Jayant	by joeu2004	2	1,215
Extracting integers from a text string. Bhupinder Rayat	by Gord Dibben	10	1,215
returning header row as a result... mj	by mj	17	1,215
Question On Excel Formulas David Smith	by Dana DeLouis	14	1,215
COUNTIF Formula in Excel with two conditions Gayla	by RajKohli	3	1,215
How do I set up an automated numbering system For my "Invoice Num Frank Medina & Associates	by Paul B	1	1,215
I was using Excel 2007, now 2003 and my Macros won't work Jaynemoggy	by PEGWINN	2	1,215
TTest with values in non-contiguous ranges Kristina	by [email protected]	6	1,215
Condensing a list/range with blank cells to a new list/range without blanks KR	by KR	4	1,215
How to open an .xlsx file with Excell chuckmlr1508	by Michael.Tarnowski	2	1,215
How to write a count-if-not function? Jsatter	by Toppers	3	1,215
copying date from one sheet to another work sheet Jay	by Jay	13	1,215
How does Excel calculate Multiple R when doing multiple regression whobell	by Mike Middleton	1	1,215
How do I calculate exact difference between two dates in y,m,d. Muhammad Javaid Hassan	by Domenic	3	1,215