Excel Worksheet Functions - Page 177

Thread / Thread Starter	Last Post	Replies	Views
returning header row as a result... mj	by mj	17	1,215
#NUM errors when calculating IRR [email protected]	by [email protected]	7	1,215
nesting more than 7 functions? Brian	by Roger Govier[_3_]	11	1,215
Sorting Data From One Column into Multiple Columns Justin Hoffmann	by Justin Hoffmann	2	1,215
PING within Excel Cell Steve	by Vikky	1	1,215
automate row insert to archive tfrentz	by Don Guillett	15	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
If...then "0", if greater than, then enter actual JcR	by JcR	5	1,214
how do i change cell text colour based on value in other cell Oscarrot	by Max	2	1,214
Sort Columns of data at the same time, without regard to order. Herc	by Ashish Mathur[_2_]	3	1,214
convert a value to a text incl apostrophe within the cell Jakob	by Beege	2	1,214
why am I getting "#N/A"? Marc Bobrow	by Marc Bobrow	3	1,214
How to use VLOOKUP to find data on another sheet MIKEYH	by MIKEYH	6	1,214
Automatically copy formulas/functions to inserted rows. Barbara	by Gord Dibben	7	1,214
Count the number of dates in a range that are earlier than today. DeborahS	by CLR	1	1,214
Select the most recent date dbs	by Don Guillett	4	1,214
CELL IS NOT ACCODATING MORE THAN 12 NUMBRS HOW TO ENTER 15 DIGIT LOGANATHAN IYER	by David Biddulph[_2_]	2	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 or Vlookup or.... Which is best for this example: SSHO_99	by chadt74	10	1,214
How to make a cell copy the fill colour of another cell Chase	by Gary''s Student	1	1,214
Excel'de yediden fazla EÄžER (IF) fonksiyonunun kullanÄ±mÄ±. Tulkas	by Tulkas	0	1,214
Help Please.....numbers reaching limits and cells changing colour mgoo	by mgoo	3	1,213
Running total over a find number of days Zorro[_2_]	by Zorro[_2_]	15	1,213
Sumproduct with date range ermeko	by Bob Phillips	6	1,213
How to clear multiple cells of input data in Excel simultaneously sstea	by Dave Peterson	12	1,213
countif two conditions met Jerry	by Jacob Skaria	2	1,213
Can Excel advanced filter be used in "and NOT" mode Robert	by Peo Sjoblom	1	1,213
.numberformat Q Aaron	by Rick Rothstein	4	1,213
Net Present Worth of reptitive costs? dexoey	by Financial Engineer	3	1,213
Inverse sin John Fitzpatrick	by Myrna Larson	3	1,213
How can I replace 2 of 5 characters within an cell in MS Excel? pmhall	by RagDyer	8	1,213
Accessing WorksheetFunction.XX from regular C# Forms application Jes Ramsing	by Jens Thiel	1	1,213
Formula for payout & interest Atreyu	by JoeU2004	3	1,213
Put comments on a locked spreadsheet even though cells not locked RDP	by Debra Dalgleish	1	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
Why won't target cell data changes trigger formula evaluation? laura_in_abq	by Gord Dibben	3	1,213
Counting number of time a character appears in a string Henrik	by Ron Rosenfeld	5	1,213
Replace #N/A via sctipt [email protected]	by [email protected]	0	1,213
AVERAGEIF AND SUMIF AND COUNTIF kathi	by Don Guillett	15	1,213
Capital account management BLIPSKYCPA	by Duke Carey	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
Excel: Cell Naming Bulk Delete Grant	by Mike H	1	1,212
Function works in one cell but not another myssieh	by Duke Carey	2	1,212
Time calculations over 24hrs Ian R[_3_]	by Ian R[_3_]	5	1,212
Vlookup in reverse order PJFry	by Chip Pearson	6	1,212
Two Matches, then Sumproduct of Values ryguy7272	by ryguy7272	16	1,212
Is there a way... salgud	by salgud	5	1,212
Updated Formula question TLC	by Pete_UK	10	1,212
Dependent List (via Data Validation) Error Dezdan	by Dezdan	2	1,212
Data Validation List Option Affecting Other Cells? tomrobs	by JulieD	1	1,212
How do I count how many times x appears in a column? Ian Roberts	by Ian Roberts	2	1,212
How do I make a column that calculates gross margin percentage JImv	by John Mansfield	1	1,212
Locked cells not updating Jamie	by Jamie	0	1,212
pivot table yllee70	by Debra Dalgleish	1	1,212
Concatenate a range King	by Harlan Grove	3	1,212
retrieve cell formatting with IF(HLOOKUP) formula useR	by useR	2	1,212
real-time countdown scottmiller	by Lomax	2	1,212
Insert "Proper Function" into existing macro jackel[_14_]	by jackel[_17_]	10	1,212
Index? Match? Function to sort and return value fr diff column in Smurfette	by Herbert Seidenberg	6	1,212
Seperate cell string into individual cells ERudy	by Biff	2	1,212
How do I reinstall the autosum button? I cannot find it on Excel KC	by KC	4	1,212
Vlookup using cell for tab name Nav	by Nav	2	1,212
How to merge data in Excel - one sheet to template sheet? Gabriela	by Gabriela	2	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
Sumif date range Delsy	by Jim Cone[_2_]	6	1,212
VLOOKUP to ignore lines which do not meet criteria Custard Tart	by Pete_UK	1	1,211
i want to add increments of time not time & date Bella	by Peo Sjoblom	1	1,211
sumproduct with partial charcter matching Matt	by Max	3	1,211
VLOOKUP using a cell calculated with NOW returns Error Chris Berding	by Ron Rosenfeld	2	1,211
negative sumif Sue Sumif	by Jerry W. Lewis	1	1,211
If both dates are entered into a cell then answer is yes Teresa Warne	by JulieD	2	1,211
Total number of each month in a column of dates GeorgeF.	by Frank Kabel	1	1,211