Excel Worksheet Functions - Page 12

Thread / Thread Starter	Last Post	Replies	Views
Sum Product Matrix Phycodes	by Phycodes	1	1,009
Floating cell with running total across multiple sheets [email protected]	by GS[_6_]	2	965
Removing #N/A from formula results Holly	by Roger Govier[_11_]	8	4,732
VLOOKUP questions Auric__	by GS[_6_]	5	963
Retreiving records from closed workbook HÃ¥kan BjÃ¶rkstrÃ¶m	by HÃ¥kan BjÃ¶rkstrÃ¶m	0	962
Request for a Research Paper [email protected]	by Auric__	1	840
Excel Help! Multiplication Formula With A Max And Min Value NGOULD	by Roger Govier[_11_]	5	1,552
quick annualization billyk81	by billyk81	0	936
bar code scanning w/spaces [email protected]	by GS[_6_]	1	1,022
Calculating combinations Beddy Boy	by Beddy Boy	0	903
Problem With formula tb	by tb	2	822
automatically putting in dates like tuesday/thursday [email protected]	by [email protected]	0	839
Training Tracking Irodeludo	by Irodeludo	2	848
Conditional Formatting- highight entire row nmb	by Claus Busch	1	875
Sort Data into new spreadsheet based on cell value Nat96173	by Nat96173	0	852
Is there a simple formula to convert time in hundredths to minute Ron	by [email protected]	11	3,778
Excel 2007 sheet and workbook protection Old Keith	by [email protected]	8	1,593
Rename Current PDF file name using Excel Sheet List [email protected]	by [email protected]	2	1,336
Divide based on a value of another cell Steve1971	by Steve1971	0	721
Hyperlink button is greyed out. Angie	by [email protected]	2	2,358
Date of the First Friday every month [email protected]	by Claus Busch	6	1,095
sumif function in excel Basil	by [email protected]	5	1,339
custom number format code using letters and numbers Foo Foo Daddy	by Tháº¿45363	15	4,454
Calendar on multiple sheets Antoine Balon	by GS[_6_]	1	1,220
LINEST with r2 = -1.18 ??? [email protected]	by [email protected]	0	1,006
Sum columns based on conditions shani1975	by Claus Busch	1	942
Adding a max percentage to existing formula JedSrq	by JedSrq	2	1,023
Round up by 0.5 if =.25, down to integer if <.25 [email protected]	by Luannguyen992	4	1,194
How to put space in between each Character in same cell with formula Sunil V	by DungSports	7	1,198
Formula That Checks For Changes tb	by Claus Busch	7	1,676
Prevent rounding up and down TerrySmith33	by Claus Busch	2	1,513
Excel spreadsheet formula to count numbers in PivotTable column [email protected]	by GS[_6_]	3	1,505
Excel 2016 IF function wrong answer Leilan	by Leilan	0	1,533
Comparing Stop Watch Times Curtopia	by Claus Busch	3	1,683
Extract date / extract time / strip data Smurfy	by cachmangmuasam	14	3,216
Change Excel Date Format [email protected]	by tinhdauhcm1	1	1,680
Help with multiple IF Tarlis Machado	by Claus Busch	3	1,358
How to add random cells and get a sum value in another cell than status bar. Umi	by GS[_6_]	4	1,406
sum cells with specific text in comments phillip cole	by Claus Busch	18	3,638
Simplify formula [email protected]	by Txlebang106	1	1,630
Array Formula to return Header L. Howard	by L. Howard	8	1,697
Excel Dates [email protected]	by [email protected]	1	1,336
Help with IF function Michelle	by [email protected]	14	2,762
Dynamic Range Name that's driving me nuts [email protected]	by GS[_6_]	8	1,690
First day of the next bi-weekly Sunday to Saturday payroll period after a given date ElizabethWells	by GS[_6_]	6	1,598
Need Function that returns active sheet name arcibald tuttle	by Claus Busch	1	1,460
sum last N rows not being a weekend [email protected]	by [email protected]	3	1,194
Calculating Date of next birthday Ken Lumley	by [email protected]	8	3,281
How to calculate hours based on certain criteria [email protected]	by [email protected]	6	1,223
Excel POWER Function \| What's the formula for Punjabi Mathematician	by Punjabi Mathematician	3	1,514
If function with lookup alphanull	by alphanull	4	1,158
Error in Calculating investment return in Excel using IRR or XRR [email protected]	by ltomama0945	2	1,884
Future Value with Interest the compounds every 3 years AdmiralAJ	by LeHuonngh2	2	1,444
How can i calculate the first sunday of each month [email protected]	by [email protected]	1	1,182
If statement to compare time cell to a time Z-Man-Cek	by Tindien3579pro	16	5,567
Extracting only birthday and month from ID number Hannes Basson	by ssixsl	4	1,345
How to detect negative value cells from large size of data [email protected]	by Claus Busch	2	1,201
Require help with PROPER function in excel [email protected]	by Claus Busch	1	1,415
Nested IF AND returning #VALUE! Paul Doucette	by Paul Doucette	11	2,732
I'm trying to use COUNTIFS to count how many times someone attendedtutoring, but in a data range such as 4-9 or 2-3 [email protected]	by Claus Busch	1	1,135
Calculate Interest that compounds every 3 Years AdmiralAJ	by AdmiralAJ	0	1,007
Edit & Paste link help Martin ©¿©¬[_4_]	by Martin ©¿©¬[_4_]	0	1,015
combining MIN and MAX formulas... DUV	by GS[_6_]	5	1,264
Using the IF and VLOOKUP Function to calculate the tax rates and tax deducted nerrawsl	by GS[_6_]	3	6,019
Need formula to test if cell is a multiple of 28, but not including 28 Wazzel	by Wazzel	4	1,924
left, search mid [email protected]	by Claus Busch	3	2,040
Countifs between a certain value [email protected]	by Claus Busch	3	1,397
Need Formula For Extracting Part Numbers tb	by tb	3	1,492
Index / Match with condition b_nuruddin	by b_nuruddin	2	1,575
Using the Time function with an IF statement Allison Mazurek	by Claus Busch	5	1,400
Formula to get the dynnamic date of the month shiva_reshs	by Claus Busch	1	1,365
Dupes in a range L. Howard	by GS[_6_]	7	1,649
Join two functions b_nuruddin	by b_nuruddin	2	1,394
Convert QuickBooks time format to excel to calculate Misty May	by [email protected]	3	2,403
How do I calculate variance between numbers? copitta	by [email protected]	5	3,191