Excel Worksheet Functions - Page 6

Thread / Thread Starter	Last Post	Replies	Views
How do I "not" enter slashes for dates and add "x" number of days to date entered? yeto	by Claus Busch	1	1,252
If a cell contains a text (unspicified text) then return thespecified text [email protected]	by Claus Busch	5	1,379
Custom Number jal111	by [email protected]	18	4,635
Extract number value from a String. 4'6'' to 4.5 [email protected]	by [email protected]	2	1,195
oFFSET [email protected]	by Claus Busch	1	1,122
Books Brian	by Brian	5	1,156
Conditional Formatting with VLookup and Offset functions Phrank	by Claus Busch	2	1,727
Concatenate Strings And Values To Create Formula tb	by GS[_6_]	8	2,583
How do I copy formulas from one wkb to another w/out linkng them? tomcat	by [email protected]	10	3,130
Round dollars SpikerzZ	by Vicky Jorwal	1	1,672
Total Number of shifts calculation Smirre	by [email protected]	4	1,465
Help With Sorting tb	by Claus Busch	5	1,241
Formula for Win/Lose Streak [email protected]	by Vuko Strugar	3	1,446
Change order of string GavinS	by Claus Busch	6	1,457
Want to Improve Formula tb	by tb	0	1,538
Calculating a running Average between dates San[_4_]	by San[_4_]	2	1,908
Validation list source is a list of comma separated values in asingle cell [email protected]	by GS[_6_]	8	1,731
permanent conversion of 1904 date format to 1900 date format Jos	by Agostino Banchi	4	4,870
Obtain the value in a cell offset form the first cell of a named range [email protected]	by [email protected]	7	1,622
Excel to oracle copy paste [email protected]	by [email protected]	0	1,454
Multiplying a Number Found in an Alphanumeric String Randomerz	by Claus Busch	9	2,264
stock sheet montypython	by GS[_6_]	1	1,478
Number values CP514	by CP514	3	1,316
FREQUENCY FORMULA rhhince[_2_]	by abmmusic4	3	1,279
Need Help With dates and linking it Jaddo92	by Jaddo92	0	1,245
Static date not working using VBA Joe Clarke	by Claus Busch	1	1,546
Help With Extracting Text String tb	by tb	2	1,179
Conditional Formatting not working right Christopher Jack	by Christopher Jack	1	1,550
How to save random numbers? Rangemaster	by [email protected]	7	2,192
Converting google flights results to Excel [email protected]	by [email protected]	0	1,989
Help with Multiple VLOOKUPs in an IF statement dakota park	by MyVeryOwnSelf[_3_]	2	1,303
Variable Page Break Christopher Jack	by Claus Busch	5	1,348
Formula for Cochran's Critical Values Dave Curtis[_2_]	by [email protected]	8	6,309
Update of two cells from a cell. luis vejarano	by luis vejarano	0	1,170
countifs and wildcards to count dates [email protected]	by [email protected]	2	1,393
SUMIFS returning #DIV/0! [email protected]	by [email protected]	0	1,057
How to calculate a "current week" when it doesn't 'start' on a Sundayor Monday? [email protected]	by [email protected]	2	1,231
COUNTIF? Malcolm Austin	by Claus Busch	2	1,221
Using if in calculating hours [email protected]	by [email protected]	4	1,034
Sumifs within Offset Match ITexcelNY	by Claus Busch	2	3,214
sum for count formula please... driller3_banter	by driller3_banter	0	1,162
Permanently Group Worksheets Krysta Davis	by GS[_6_]	1	2,407
Advanced Excel Functions Ebook robert	by jack1090	2	2,729
How to add prefix to names in a column [email protected]	by Claus Busch	1	1,442
Help With SUMIF Function tb	by tb	2	1,080
need adsense account seller from USA [email protected]	by [email protected]	1	1,125
count if three colums match . [email protected]	by [email protected]	0	992
Replace #N/A via sctipt [email protected]	by [email protected]	0	1,148
Convert Array Formulas to Regular Formulas Domenick	by [email protected]	6	2,638
SUBTOTAL and COUNTIF (or SUMIF) combination DKS	by Claus Busch	3	4,282
delivery time versus pickup time [email protected]	by Claus Busch	1	1,064
Help with months Nitya Satheesh	by Nitya Satheesh	9	1,281
Auto Repeat of columns sheet 2, not sheet 3, 4, 5 [email protected]	by GS[_6_]	5	1,361
How to return column header contents when a cell in the column has a value [email protected]	by Claus Busch	1	1,128
Round up entire worksheet Jaime	by [email protected]	9	4,397
REPEATING_ROWS_IDENTIFICATION via135	by Claus Busch	7	1,576
If statement to work out time/overtime [email protected]	by MyVeryOwnSelf[_3_]	3	1,632
formula to add space within text Jennifer	by Maurizio Borrelli[_3_]	7	4,361
Convert Julian to Gregorian Date [email protected]	by Hans Terkelsen	1	1,666
filtering data Nitya Satheesh	by Claus Busch	4	1,232
column comparison Nitya Satheesh	by Nitya Satheesh	15	2,799
pivot table Nitya Satheesh	by Nitya Satheesh	2	1,162
Progressing the date one day forward if conditions of time are met: DrDave35	by DrDave35	2	1,519
% of OI and % of vol zoharb	by zoharb	0	1,186
What Function Will Get Me The Result I Need [email protected]	by joeu2004[_2_]	3	1,231
VBA question When I search to replace parentheses in excel it givesme "-" sign [email protected]	by [email protected]	4	1,542
INDIRECT Function and adding cells across multiple sheets Jade Sheldon	by MyVeryOwnSelf[_3_]	2	1,555
Any Way To Specify XIRR Values and Dates Without Using Array? W	by joeu2004[_2_]	1	1,716
Can anyone help with this formula? dawn48313	by dawn48313	4	1,328
IF Statement return wrong comparison Don B[_2_]	by Howard Silcock	1	1,106
IF statement returns false when statment is True [email protected]	by Don B[_2_]	4	3,090
Progress / Completion bars. Help if you like a challenge! Callum	by Claus Busch	6	1,065
Copy non empty cells into one designated. [email protected]	by [email protected]	0	817
Date function Nitya Satheesh	by Nitya Satheesh	9	1,247
Countif and Sumproduct Multiple Sheets Nean	by Ron Rosenfeld[_2_]	1	903