Excel Worksheet Functions - Page 14

Thread / Thread Starter	Last Post	Replies	Views
Convert Array Formulas to Regular Formulas Domenick	by [email protected]	6	2,813
SUBTOTAL and COUNTIF (or SUMIF) combination DKS	by Claus Busch	3	4,538
delivery time versus pickup time [email protected]	by Claus Busch	1	1,138
Help with months Nitya Satheesh	by Nitya Satheesh	9	1,359
Auto Repeat of columns sheet 2, not sheet 3, 4, 5 [email protected]	by GS[_6_]	5	1,439
How to return column header contents when a cell in the column has a value [email protected]	by Claus Busch	1	1,238
Round up entire worksheet Jaime	by [email protected]	9	4,508
REPEATING_ROWS_IDENTIFICATION via135	by Claus Busch	7	1,656
If statement to work out time/overtime [email protected]	by MyVeryOwnSelf[_3_]	3	1,749
formula to add space within text Jennifer	by Maurizio Borrelli[_3_]	7	4,431
Convert Julian to Gregorian Date [email protected]	by Hans Terkelsen	1	5,121
filtering data Nitya Satheesh	by Claus Busch	4	1,315
column comparison Nitya Satheesh	by Nitya Satheesh	15	2,965
pivot table Nitya Satheesh	by Nitya Satheesh	2	1,250
Progressing the date one day forward if conditions of time are met: DrDave35	by DrDave35	2	1,603
% of OI and % of vol zoharb	by zoharb	0	1,309
What Function Will Get Me The Result I Need [email protected]	by joeu2004[_2_]	3	1,328
VBA question When I search to replace parentheses in excel it givesme "-" sign [email protected]	by [email protected]	4	1,652
INDIRECT Function and adding cells across multiple sheets Jade Sheldon	by MyVeryOwnSelf[_3_]	2	1,643
Any Way To Specify XIRR Values and Dates Without Using Array? W	by joeu2004[_2_]	1	1,858
Can anyone help with this formula? dawn48313	by dawn48313	4	1,464
IF Statement return wrong comparison Don B[_2_]	by Howard Silcock	1	1,181
IF statement returns false when statment is True [email protected]	by Don B[_2_]	4	3,354
Progress / Completion bars. Help if you like a challenge! Callum	by Claus Busch	6	1,149
Copy non empty cells into one designated. [email protected]	by [email protected]	0	904
Date function Nitya Satheesh	by Nitya Satheesh	9	1,342
Countif and Sumproduct Multiple Sheets Nean	by Ron Rosenfeld[_2_]	1	985
Add data every 14 days? Kevin Coleman	by Michael Graubart	2	3,869
IFERROR function with Hyperlink [email protected]	by [email protected]	0	3,070
Find Date Between? [email protected]	by Howard Silcock	2	1,189
Inserting rows to linked Workbooks Todd Gerdy	by GS[_6_]	6	1,619
Using Vllookup with OFFSET or ??? [email protected]	by [email protected]	0	889
Find duplicates w/3 criteria [email protected]	by Claus Busch	3	1,270
Vlookup and Countif [email protected]	by Claus Busch	1	1,099
Convert YY[julian day] to dd-mmm-yy - Julian Date.xls (0/1) Phrank	by Phrank	2	1,512
Compare numbers based by day of the week and month Emilio Guerra	by trantrongtb	2	1,176
Help ASAP with formula! LouisCG3	by LouisCG3	4	1,019
Conditional formating Excel 2010 [email protected]	by [email protected]	0	899
Spreading number evenly over 165 days LightningEclipse	by Don Guillett[_2_]	1	1,092
Cannot bring out the month & year from a date San[_4_]	by San[_4_]	3	1,058
Multiple returns with one lookup value L. Howard	by L. Howard	2	1,128
CONCATENATE - #VALUE! error sometimes ???? [email protected]	by [email protected]	2	1,531
Excel INDIRECT or CONCATENATE ? [email protected]	by simnamsinh	1	1,217
Returning contents of a cell identified by two logic tests SteveRH	by Claus Busch	3	1,156
Conditional formatting on dynamic named range Håkan Björkström	by Håkan Björkström	2	1,252
offset formula causing Circular reference Fighting Illini Mike	by [email protected]	3	3,753
SUMIFS ? for multiple ranges L. Howard	by L. Howard	4	1,269
How to change the direction of the enter key to go horizontal BManske	by [email protected]	5	5,251
How can I pull certain row info based on column info Netti	by [email protected]	1	1,077
Save Random Number Paul B.	by jester23423	5	3,108
Excel 2013 problems as listed below. Desai Sanket	by [email protected]	1	1,026
Calculating my work hours minus lunch break and then adding forweekly total [email protected]	by Alfred Heiligenbrunner	2	1,903
Excel named tables or dynimac named ranges? Håkan Björkström	by Håkan Björkström	0	1,116
automatically putting in dates like tuesday/thursday [email protected]	by [email protected]	0	1,050
Help With Min/Max Values tb	by Claus Busch	1	1,033
Conditional formatting Håkan Björkström	by Håkan Björkström	1	959
Counting specific number following decimal point in a row [email protected]	by Claus Busch	2	1,082
Extract parts of cells to new columns shani1975	by Claus Busch	1	973
Adding up to a whole number Aaron R	by Claus Busch	1	965
Check box linked cell = TRUE then J5 valued reduced by 1 L. Howard	by L. Howard	16	2,205
How to Calculate the average Daily price within a time period San[_4_]	by Alfred Heiligenbrunner	6	1,458
how to convert arabic numbers to english text format in excel? ANURAG ARPAN	by Gabreilla	2	2,507
Help with time/text format [email protected]	by [email protected]	3	973
Cell value reference for ROW in a formula L. Howard	by L. Howard	9	1,234
Find and reference the contents of a cell using multiple criteria James3873	by GS[_2_]	1	923
Mac based trying to hyperlink folder on server nfcurro	by nfcurro	0	894
Using dynamic sheet name in formula [email protected]	by [email protected]	1	1,026
using DGET, help please Terri Hall	by Terri Hall	0	872
automatic transfer of values montypython	by montypython	0	943
change cell value based on another cell set99	by Gord Dibben[_2_]	1	1,037
vLookup returns formula and not result cmc4	by [email protected]	5	1,427
SUMIF Wild Card formula for two words in cell L. Howard	by Claus Busch	9	1,124
Comparing grade data across sheets compelly	by GS[_2_]	1	967
Min / Max together KristyAlison	by KristyAlison	6	1,260
Days in the month Quilp	by Quilp	8	1,479