Excel Worksheet Functions - Page 1171

Thread / Thread Starter	Last Post	Replies	Views
Number values CP514	by CP514	3	1,384
stock sheet montypython	by GS[_6_]	1	1,527
Multiplying a Number Found in an Alphanumeric String Randomerz	by Claus Busch	9	2,350
Excel to oracle copy paste [email protected]	by [email protected]	0	1,543
Obtain the value in a cell offset form the first cell of a named range [email protected]	by [email protected]	7	1,699
permanent conversion of 1904 date format to 1900 date format Jos	by Agostino Banchi	4	5,417
Validation list source is a list of comma separated values in asingle cell [email protected]	by GS[_6_]	8	1,794
Calculating a running Average between dates San[_4_]	by San[_4_]	2	1,961
Want to Improve Formula tb	by tb	0	1,593
Change order of string GavinS	by Claus Busch	6	1,526
Formula for Win/Lose Streak [email protected]	by Vuko Strugar	3	1,541
Help With Sorting tb	by Claus Busch	5	1,347
Total Number of shifts calculation Smirre	by Kevin@Radstock	4	1,564
Round dollars SpikerzZ	by Vicky Jorwal	1	1,733
How do I copy formulas from one wkb to another w/out linkng them? tomcat	by [email protected]	10	3,326
Concatenate Strings And Values To Create Formula tb	by GS[_6_]	8	2,678
Conditional Formatting with VLookup and Offset functions Phrank	by Claus Busch	2	1,846
Books Brian	by Brian	5	1,285
oFFSET [email protected]	by Claus Busch	1	1,217
Extract number value from a String. 4'6'' to 4.5 [email protected]	by [email protected]	2	1,243
Custom Number jal111	by [email protected]	18	4,838
If a cell contains a text (unspicified text) then return thespecified text [email protected]	by Claus Busch	5	1,470
How do I "not" enter slashes for dates and add "x" number of days to date entered? yeto	by Claus Busch	1	1,319
Add Company Holidays to Formula Calculation tb	by tb	0	1,279
Can't insert a new worksheet [email protected]	by [email protected]	0	1,353
Combinations [email protected]	by [email protected]	0	1,164
Margins and cell widths Brian	by Brian	8	1,432
Pivot table - Data Extract TheExpat Wanderer	by TheExpat Wanderer	0	1,129
how to replace #N/A with my Vlookup [email protected]	by Claus Busch	1	1,283
Sumprouct with Indext? [email protected]	by [email protected]	2	1,273
IF statement to show Late Arrival [email protected]	by Claus Busch	1	1,409
FINDING OUT SATURDAYS AND SUNDAYS via135	by via135	4	1,409
alpha numeric data validation for excel [email protected]	by comin	24	5,996
excel 2003: how do I fix: "Style 'Comma' not found" jrp9206	by [email protected]	4	4,617
CONVERSION OF TEXT TO DATE via135	by wabbleknee	3	1,588
Upload an image depending on the value of cells luis vejarano	by luis vejarano	2	1,456
Odd results from SUMPRODUCT variance formula JamesM1986	by JamesM1986	0	2,377
How do I sort IP addresses is ascending numerical order? [email protected]	by [email protected]	0	2,410
Productivity Statistics ANoline	by ANoline	0	1,473
Productivity Log drew	by ANoline	3	3,000
Can't insert a new worksheet [email protected]	by [email protected]	0	1,313
Date Functions ahmed[_4_]	by ahmed[_4_]	4	1,360
Date function expanded ahmed[_4_]	by ahmed[_4_]	5	1,593
data analysis Nitya Satheesh	by Nitya Satheesh	12	2,975
Can't insert a new worksheet [email protected]	by [email protected]	0	1,664
time decision for open file in Excel [email protected]	by [email protected]	3	2,628
Min function pull down formula L. Howard	by L. Howard	4	1,777
SUMIFS linked to other workbook, returns #VALUE! GijsKijlstra	by GijsKijlstra	2	1,918
Displaying all combinations of a range of numbers Mally	by mpokos	5	3,337
data arrangement Nitya Satheesh	by Nitya Satheesh	4	1,803
How do I calculate variance between numbers? copitta	by [email protected]	5	3,134
Convert QuickBooks time format to excel to calculate Misty May	by [email protected]	3	2,394
Join two functions b_nuruddin	by b_nuruddin	2	1,382
Dupes in a range L. Howard	by GS[_6_]	7	1,641
Formula to get the dynnamic date of the month shiva_reshs	by Claus Busch	1	1,347
Using the Time function with an IF statement Allison Mazurek	by Claus Busch	5	1,391
Index / Match with condition b_nuruddin	by b_nuruddin	2	1,559
Need Formula For Extracting Part Numbers tb	by tb	3	1,480
Countifs between a certain value [email protected]	by Claus Busch	3	1,385
left, search mid [email protected]	by Claus Busch	3	2,028
Need formula to test if cell is a multiple of 28, but not including 28 Wazzel	by Wazzel	4	1,897
Using the IF and VLOOKUP Function to calculate the tax rates and tax deducted nerrawsl	by GS[_6_]	3	5,938
combining MIN and MAX formulas... DUV	by GS[_6_]	5	1,257
Edit & Paste link help Martin ©¿©¬[_4_]	by Martin ©¿©¬[_4_]	0	1,006
Calculate Interest that compounds every 3 Years AdmiralAJ	by AdmiralAJ	0	1,000
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,122
Nested IF AND returning #VALUE! Paul Doucette	by Paul Doucette	11	2,679
Require help with PROPER function in excel [email protected]	by Claus Busch	1	1,407
How to detect negative value cells from large size of data [email protected]	by Claus Busch	2	1,190
Extracting only birthday and month from ID number Hannes Basson	by ssixsl	4	1,295
If statement to compare time cell to a time Z-Man-Cek	by Tindien3579pro	16	5,520
How can i calculate the first sunday of each month [email protected]	by [email protected]	1	1,171
Future Value with Interest the compounds every 3 years AdmiralAJ	by LeHuonngh2	2	1,435
Error in Calculating investment return in Excel using IRR or XRR [email protected]	by ltomama0945	2	1,857
If function with lookup alphanull	by alphanull	4	1,149