Excel Worksheet Functions - Page 14

Thread / Thread Starter	Last Post	Replies	Views
In Excel, conditional format (font red) referencing another cell? Christine Hemphill	by Jamie	39	5,408
If statement - can it stop once a conditon is reached? mike	by jamescox[_50_]	1	5,404
how can i write an equation in polar form in excel vi_friend	by Herbert Seidenberg	3	5,403
permanent conversion of 1904 date format to 1900 date format Jos	by Agostino Banchi	4	5,402
Conditional formatting of entire workbook computhom	by Dave	3	5,402
Finding 3rd (or 2nd) Sunday in a given year/month Bob	by Ron Rosenfeld	5	5,401
Find "Look in" box does not show 'values' on 'formulas' Oldnovice	by Spiky	2	5,400
Function / formula to be used if cell contains a letter. Cameron Stewart	by Cameron Stewart	2	5,390
Countif a corresponding value is not equal to zero or blank raphiel2063	by Teethless mama	1	5,390
Mod 10 & 11 Pablo	by Colin Vicary	13	5,390
CAN'T INSERT SYMBOL? Malcolm Austin	by JLatham	4	5,388
HELP! Single cell formula to calculate weeks cover of stock on forward sales. [email protected]	by [email protected]	2	5,385
Don't run formula if cell is blank Randy Mis	by wickedchew	1	5,383
how I can calculate EAR with continuous compounding? salman	by Joe User[_2_]	2	5,381
Extract Month and year from Cell containing date, month, year & time Montenegro Mick	by Ron Rosenfeld[_2_]	2	5,378
How do you keep the date using =TODAY() from changing? Chaneyt	by Myrna Larson	3	5,372
Using Bloomberg's BDP function in VBA [email protected]	by [email protected]	0	5,370
Blinking Text ( 1 2) Esra Dekan	by Gord Dibben	43	5,370
GetPivotData from OLAP Cube Cell Referencing Formula. Bazy2k	by Debra Dalgleish	1	5,368
remove partial data from cell nanox	by nanox	2	5,365
How to filter a column of text for exact words Suzanne	by Ron Coderre	9	5,365
Summing and Averages with non-numeric cells Erinayn	by Erinayn	11	5,364
Exclude dates from a sum formula SirMatthew	by T. Valko	3	5,355
how to make formula to get past due 30-60-90 days ASHRAF	by Roger Govier[_3_]	2	5,348
OFFSET COLUMN() ROW() - what does this mean? foxyfmu	by wickedchew	1	5,345
convert excel spreadsheet to a calendar? convert excel spreadsheet to a calendar	by Gary L Brown	2	5,342
formulat to convert base 32 to decimal? TMG005	by D Hilberg	5	5,340
Copy cell format to cell on another worksht and update automatical kevinm	by paul	21	5,337
formula bar displays "=RC[-12]+RC[-11]". how to get normal view? Laurent	by Laurent	3	5,333
how can you perform Lagrange interpolation using excel? Mauricio	by Bernie Deitrick	1	5,328
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com	by Sam via OfficeKB.com	23	5,324
Database or list range is not valid JRM	by JRM	2	5,323
Pivot Table - How to keep data hidden [email protected]	by Ron Coderre	2	5,321
How can up type text upsidedown in a cell please not 90 degrees Justin	by Dave Peterson	4	5,318
Sumproduct Fucntion - the use of dash ( -- ) Negda	by plb2862	11	5,317
Excel 2007 - Conditional Formatting Problem with Percentages Caros	by Dave P[_3_]	3	5,307
hOW TO USE EXCEL TO CALCULATE BASEBALL BATTING AVERAGE golfer18	by Biff	4	5,302
How to compute StDev of only nonzero entries in a range? Sam	by T. Valko	3	5,298
Custom Section Numbering MAnderson	by Max	6	5,290
RANK on race times JockW	by David Biddulph[_2_]	3	5,289
conditional formatting for cell date to equal today's date Sistereinstein	by bprime	2	5,289
Calculate the difference between ages, show as yy mm Hilary from New Zealand	by Sandy Mann	3	5,285
Formula to detect color? [email protected]	by [email protected]	9	5,281
CAR LEASE CALCULATION WITH RESIDUAL FIN	by [email protected]	1	5,280
How do I set up a formula for parts (or units) per hour? Ender-DI	by Duke Carey	10	5,279
Converting Month Number to Month Text Abbreviation Bob	by Dave Peterson	10	5,277
Two subjects: Column sort and True/False in cell dilynn17	by Tanya	3	5,276
Match Last Occurrence of two numbers and Count to Previous Occurence Sam via OfficeKB.com	by Max	33	5,274
how to link horizontal data to vertical cells in a new sheet sinoxolo	by isabelle	1	5,273
Has anyone a template for a surveyors field book Jack Tangaloma	by paul	1	5,271
How do I hide subcategories in Excel? Nicole	by Ivyleaf	1	5,270
how do i calculate 2' x 4' x 4" PlaceCarp	by Dana DeLouis[_3_]	5	5,260
hyperlink error: "Cannot open the specified file" Kate Choi	by Dave Peterson	1	5,259
WORK HOURS DIFFERENCE BETWEEN TWO DATES CHRISTI	by [email protected]	14	5,258
how to get formula content of a cell? muster	by Kevin Vaughn	16	5,256
Counting Unique Values Bob	by Jamie Collins	38	5,255
Combining subtotal and sumif functions TPDigg	by TPDigg	3	5,253
IS BLANK checking 2 Cells MKuria	by Rick Rothstein	6	5,253
Weighted Regression Engineer001	by ryguy7272	5	5,251
vlookup column index number argument ibvalentine	by ibvalentine	6	5,250
IF TODAY equals date in cell A10, or if TODAY is beyond that date SoupNazi	by SoupNazi	4	5,250
Displaying a decimal as years and months Chris	by David Biddulph[_2_]	14	5,247
Can you rotate a section of excel cell data Johnmcleanh	by mikebres	1	5,245
Calc days between two dates and exclude leap year days scoz	by Ron Rosenfeld	5	5,245
Skip if false? DeFautT	by DeFautT	2	5,239
Remove blank from pivot table Kishor Bhalerao	by yasho bhushan	5	5,235
allocating between positive and negative amounts THosier	by Gary Brown	1	5,227
IF statement - multiple scenarios Laz	by Rick Rothstein \(MVP - VB\)	4	5,222
Excel 2003 - Split Content of Cell w/Text Separator (Return) DeeW	by Gord Dibben	3	5,221
How do you prevent users from changing certain cells? Kelly	by Susan	4	5,221
I need to calculate hours worked from 11pm to 7am minus a lunch Paula Brooks	by Shane Devenshire[_2_]	2	5,220
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) RICHARD	by Lady Layla	1	5,217
Can I print a blank spreadsheet with gridlines rocky	by Zorro[_2_]	2	5,215
partial word match for conditional formatting Maureen	by Spiky	9	5,210
Can I convert a number(1-365) to a month and day of a year? rnc	by Shane Devenshire	4	5,210