Excel Worksheet Functions - Page 51

Thread / Thread Starter	Last Post	Replies	Views
Help! Compare one cell against a whole column, report adjacent cel Spam spam bacon spam	by Spam spam bacon spam	4	2,447
extract list of names and elimanate duplicates Frank Kabel	by petty	2	2,446
Protect Sheet but allow sorting LucyK	by George M	4	2,446
plus and minus sign in cells ivoryhunter	by ivoryhunter	3	2,446
Showing date as day of week Trevor Aiston[_2_]	by David Biddulph[_2_]	4	2,446
Converting Date of Birth to Age WendyMc	by Myrna Larson	8	2,446
Vlookup across multiple tabs Hirsch	by Biff	2	2,445
? Link attached - How to validate SIN (Social Insurance Number) [email protected]	by Marko	5	2,445
Vlookup a subtotal pfaxange18	by Claus Busch	2	2,444
To count how many are in a certain age group LEG	by T. Valko	10	2,443
SUMPRODUCT - Ignore blank rows sahafi	by sahafi	8	2,442
double lookup, nest, or macro? Josef.angel	by JulieD	1	2,442
Cell reference to current cell minus 1 Jared Mortlock	by Jared Mortlock	3	2,442
Imported Data creates blank cells that aren't really blank JackieD	by Dave Peterson	14	2,442
SUMIF function with text color condition MrWallyWorld	by Dave Peterson	4	2,442
Excel function to convert month-day-year to mm/dd/yyyy sweetthing4luc	by Rick Rothstein	7	2,441
how can I use randbetween without repeating numbers in a set Maria	by Bernd P	7	2,441
Turning a negative into a positive [email protected]	by Arla	4	2,440
Data validation with a fixed amount of decimal places [email protected]	by [email protected]	17	2,440
create an expense requisition form desesperada123	by [email protected]	3	2,440
Compare & highlight changes between two worksheets? Katie	by Shane Devenshire	3	2,439
Sumif from VBA Type mismatch mdalamers via OfficeKB.com	by mdalamers via OfficeKB.com	3	2,437
YTD average - How do I create a formula? Dana	by [email protected]	2	2,437
How do I reorder sheets in excel Dr Alok Modi MD	by Dr Alok Modi MD	5	2,436
Conditional formula using MIN function doesn't work SCarroll	by T. Valko	5	2,436
Excel calculation of duration in hours and minutes [email protected]	by David Biddulph	4	2,435
How do I avoid repeating calculation in IF function? Arthur	by Stephen Bye[_2_]	5	2,435
count the no.of records between two dates Sachin Pawar	by Don Guillett	2	2,434
how do you have the headings scroll down the page as you move dow Donna B	by bala_vb	2	2,434
Sum only if cells are not blank in adjacent column arch0072	by Spiky	4	2,434
Count number to reach a cumulative value Bruce	by Domenic	5	2,433
How do I shade cells using the "IF" function? Kaz	by Govind	3	2,433
How do i round up a price to the nearest 5,10,15 etc pence Millsy	by bj	1	2,433
insert a page number into a cell? Carrmuha	by Frank Kabel	2	2,433
How to sort and keep formulas Upya	by David McRitchie	2	2,432
Need conditional data from 1 sheet to populate another sheet cjtnoobexceller	by Max	3	2,432
How do you calculate cotangent in Excel 2003? mowgli	by Dana DeLouis	2	2,432
automaticely highlight the row that I am working on Cindy	by Luke M[_4_]	5	2,432
How do I create a formula in Excel that will countif or sumif bef. bkclark	by Frank Kabel	4	2,432
Sum a range across multiple sheets CarlosAntenna	by CarlosAntenna	4	2,431
NPV of cashflows to assess contribution to a joint venture ExcelMonkey	by joeu2004	2	2,431
How can I get my spreadsheets to open faster? Johnnie	by Johnnie	3	2,431
Need to find the right-most cell value in a string of cells -dc-	by Domenic	2	2,430
Stock control formula Rocket	by Rocket	0	2,430
If logical function with text and numbers Hugo	by Rick Rothstein	7	2,430
NESTED IF FORMULA - IGNORE BLANK CELLS Evan	by Evan	5	2,430
Control function for copy/paste Vicky	by Vicky	0	2,430
NPV vs. XNPV Robert	by [email protected]	2	2,429
Countif between two values Ronbo	by Jason Morin	2	2,428
Loan Amortization Template in Excel [email protected]	by Gary Brown	3	2,428
convert weekday date to the next sunday date Oldersox	by Oldersox	2	2,428
what exactly are relational operators in Excel? All math symbol? JC	by JC	7	2,427
T-Account templates can be found where? Shayla	by Shayla	0	2,427
Copy/Paste Drop Down List Ivano	by Ivano	0	2,427
APR formula for irregular transactions JR	by joeu2004	1	2,426
Label filter disabled Stacy	by Anne Rocco	2	2,426
remove leading zeros from text strings snooze	by Niek Otten	2	2,426
Hyperlinks using R[1]C[1] and offset function in its cell referenc Elijah-Dadda	by Elijah-Dadda	0	2,425
In Excel need to have a sub worksheet inserted into each row RT	by Dave Peterson	2	2,425
If formula with two conditions to meet Carolina	by Carolina	7	2,425
keeps turning off rio	by rio	4	2,425
=SLOPE(OFFSET(INDEX .... Help please Mark K[_2_]	by Bernd P	9	2,425
Removing spaces at the end of numbers Chris T.	by Peo Sjoblom	5	2,422
ctrl+shift+arrow does not highlight but ends formula when typing Excel-lent	by Excel-lent	0	2,422
Conditional Formatting that will display conditional data BrainFart	by Gary''s Student	1	2,422
Sum of Daily Overtime Keep It Simple Stupid	by Keep It Simple Stupid	10	2,422
sumproduct with wildcard for text? nattie	by Bob Phillips	4	2,422
Pivot Table Auto Update Data Source? Ket	by Debra Dalgleish	1	2,421
Add mailto (email) as function to a button in excel yagzzy	by Alan	1	2,421
Excel CHALLENGE...3 questions(indirect,rank,array formula)... Mlowry	by Max	8	2,419
HOW DO I DECONCATENATE pys	by Bob Phillips	2	2,419
DSUM - Need dynamic functionality Don[_3_]	by Harlan Grove[_2_]	8	2,418
Show hash marks instead of text Mary Thomas	by Mark Lincoln	3	2,418
Applying Offset to Range in VBA [email protected]	by JMB	2	2,418
Color Cells Summing HANYANA	by Max	29	2,418