Excel Worksheet Functions - Page 14

Thread / Thread Starter	Last Post	Replies	Views
Convert Array Formulas to Regular Formulas Domenick	by [email protected]	6	2,737
SUBTOTAL and COUNTIF (or SUMIF) combination DKS	by Claus Busch	3	4,479
delivery time versus pickup time [email protected]	by Claus Busch	1	1,117
Help with months Nitya Satheesh	by Nitya Satheesh	9	1,334
Auto Repeat of columns sheet 2, not sheet 3, 4, 5 [email protected]	by GS[_6_]	5	1,412
How to return column header contents when a cell in the column has a value [email protected]	by Claus Busch	1	1,206
Round up entire worksheet Jaime	by [email protected]	9	4,484
REPEATING_ROWS_IDENTIFICATION via135	by Claus Busch	7	1,633
If statement to work out time/overtime [email protected]	by MyVeryOwnSelf[_3_]	3	1,711
formula to add space within text Jennifer	by Maurizio Borrelli[_3_]	7	4,394
Convert Julian to Gregorian Date [email protected]	by Hans Terkelsen	1	5,088
filtering data Nitya Satheesh	by Claus Busch	4	1,293
column comparison Nitya Satheesh	by Nitya Satheesh	15	2,926
pivot table Nitya Satheesh	by Nitya Satheesh	2	1,225
Progressing the date one day forward if conditions of time are met: DrDave35	by DrDave35	2	1,579
% of OI and % of vol zoharb	by zoharb	0	1,264
What Function Will Get Me The Result I Need [email protected]	by joeu2004[_2_]	3	1,303
VBA question When I search to replace parentheses in excel it givesme "-" sign [email protected]	by [email protected]	4	1,627
INDIRECT Function and adding cells across multiple sheets Jade Sheldon	by MyVeryOwnSelf[_3_]	2	1,618
Any Way To Specify XIRR Values and Dates Without Using Array? W	by joeu2004[_2_]	1	1,814
Can anyone help with this formula? dawn48313	by dawn48313	4	1,429
IF Statement return wrong comparison Don B[_2_]	by Howard Silcock	1	1,160
IF statement returns false when statment is True [email protected]	by Don B[_2_]	4	3,292
Progress / Completion bars. Help if you like a challenge! Callum	by Claus Busch	6	1,132
Copy non empty cells into one designated. [email protected]	by [email protected]	0	880
Date function Nitya Satheesh	by Nitya Satheesh	9	1,316
Countif and Sumproduct Multiple Sheets Nean	by Ron Rosenfeld[_2_]	1	958
Add data every 14 days? Kevin Coleman	by Michael Graubart	2	3,809
IFERROR function with Hyperlink [email protected]	by [email protected]	0	2,976
Find Date Between? [email protected]	by Howard Silcock	2	1,163
Inserting rows to linked Workbooks Todd Gerdy	by GS[_6_]	6	1,553
Using Vllookup with OFFSET or ??? [email protected]	by [email protected]	0	867
Find duplicates w/3 criteria [email protected]	by Claus Busch	3	1,227
Vlookup and Countif [email protected]	by Claus Busch	1	1,082
Convert YY[julian day] to dd-mmm-yy - Julian Date.xls (0/1) Phrank	by Phrank	2	1,487
Compare numbers based by day of the week and month Emilio Guerra	by trantrongtb	2	1,157
Help ASAP with formula! LouisCG3	by LouisCG3	4	999
Conditional formating Excel 2010 [email protected]	by [email protected]	0	870
Spreading number evenly over 165 days LightningEclipse	by Don Guillett[_2_]	1	1,079
Cannot bring out the month & year from a date San[_4_]	by San[_4_]	3	1,032
Multiple returns with one lookup value L. Howard	by L. Howard	2	1,098
CONCATENATE - #VALUE! error sometimes ???? [email protected]	by [email protected]	2	1,512
Excel INDIRECT or CONCATENATE ? [email protected]	by simnamsinh	1	1,189
Returning contents of a cell identified by two logic tests SteveRH	by Claus Busch	3	1,144
Conditional formatting on dynamic named range Håkan Björkström	by Håkan Björkström	2	1,237
offset formula causing Circular reference Fighting Illini Mike	by [email protected]	3	3,732
SUMIFS ? for multiple ranges L. Howard	by L. Howard	4	1,248
How to change the direction of the enter key to go horizontal BManske	by [email protected]	5	5,159
How can I pull certain row info based on column info Netti	by [email protected]	1	1,060
Save Random Number Paul B.	by jester23423	5	3,094
Excel 2013 problems as listed below. Desai Sanket	by [email protected]	1	1,014
Calculating my work hours minus lunch break and then adding forweekly total [email protected]	by Alfred Heiligenbrunner	2	1,878
Excel named tables or dynimac named ranges? Håkan Björkström	by Håkan Björkström	0	1,097
automatically putting in dates like tuesday/thursday [email protected]	by [email protected]	0	1,026
Help With Min/Max Values tb	by Claus Busch	1	1,015
Conditional formatting Håkan Björkström	by Håkan Björkström	1	939
Counting specific number following decimal point in a row [email protected]	by Claus Busch	2	1,047
Extract parts of cells to new columns shani1975	by Claus Busch	1	956
Adding up to a whole number Aaron R	by Claus Busch	1	946
Check box linked cell = TRUE then J5 valued reduced by 1 L. Howard	by L. Howard	16	2,179
How to Calculate the average Daily price within a time period San[_4_]	by Alfred Heiligenbrunner	6	1,438
how to convert arabic numbers to english text format in excel? ANURAG ARPAN	by Gabreilla	2	2,468
Help with time/text format [email protected]	by [email protected]	3	953
Cell value reference for ROW in a formula L. Howard	by L. Howard	9	1,220
Find and reference the contents of a cell using multiple criteria James3873	by GS[_2_]	1	907
Mac based trying to hyperlink folder on server nfcurro	by nfcurro	0	876
Using dynamic sheet name in formula [email protected]	by [email protected]	1	991
using DGET, help please Terri Hall	by Terri Hall	0	860
automatic transfer of values montypython	by montypython	0	923
change cell value based on another cell set99	by Gord Dibben[_2_]	1	1,020
vLookup returns formula and not result cmc4	by [email protected]	5	1,389
SUMIF Wild Card formula for two words in cell L. Howard	by Claus Busch	9	1,108
Comparing grade data across sheets compelly	by GS[_2_]	1	955
Min / Max together KristyAlison	by KristyAlison	6	1,233
Days in the month Quilp	by Quilp	8	1,462