Excel Worksheet Functions - Page 14

Thread / Thread Starter	Last Post	Replies	Views
Convert Array Formulas to Regular Formulas Domenick	by [email protected]	6	2,830
SUBTOTAL and COUNTIF (or SUMIF) combination DKS	by Claus Busch	3	4,551
delivery time versus pickup time [email protected]	by Claus Busch	1	1,151
Help with months Nitya Satheesh	by Nitya Satheesh	9	1,372
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,243
Round up entire worksheet Jaime	by [email protected]	9	4,523
REPEATING_ROWS_IDENTIFICATION via135	by Claus Busch	7	1,661
If statement to work out time/overtime [email protected]	by MyVeryOwnSelf[_3_]	3	1,760
formula to add space within text Jennifer	by Maurizio Borrelli[_3_]	7	4,442
Convert Julian to Gregorian Date [email protected]	by Hans Terkelsen	1	5,128
filtering data Nitya Satheesh	by Claus Busch	4	1,321
column comparison Nitya Satheesh	by Nitya Satheesh	15	2,970
pivot table Nitya Satheesh	by Nitya Satheesh	2	1,252
Progressing the date one day forward if conditions of time are met: DrDave35	by DrDave35	2	1,605
% of OI and % of vol zoharb	by zoharb	0	1,311
What Function Will Get Me The Result I Need [email protected]	by joeu2004[_2_]	3	1,339
VBA question When I search to replace parentheses in excel it givesme "-" sign [email protected]	by [email protected]	4	1,654
INDIRECT Function and adding cells across multiple sheets Jade Sheldon	by MyVeryOwnSelf[_3_]	2	1,647
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,483
IF Statement return wrong comparison Don B[_2_]	by Howard Silcock	1	1,201
IF statement returns false when statment is True [email protected]	by Don B[_2_]	4	3,356
Progress / Completion bars. Help if you like a challenge! Callum	by Claus Busch	6	1,162
Copy non empty cells into one designated. [email protected]	by [email protected]	0	907
Date function Nitya Satheesh	by Nitya Satheesh	9	1,363
Countif and Sumproduct Multiple Sheets Nean	by Ron Rosenfeld[_2_]	1	987
Add data every 14 days? Kevin Coleman	by Michael Graubart	2	3,874
IFERROR function with Hyperlink [email protected]	by [email protected]	0	3,074
Find Date Between? [email protected]	by Howard Silcock	2	1,199
Inserting rows to linked Workbooks Todd Gerdy	by GS[_6_]	6	1,626
Using Vllookup with OFFSET or ??? [email protected]	by [email protected]	0	891
Find duplicates w/3 criteria [email protected]	by Claus Busch	3	1,276
Vlookup and Countif [email protected]	by Claus Busch	1	1,101
Convert YY[julian day] to dd-mmm-yy - Julian Date.xls (0/1) Phrank	by Phrank	2	1,517
Compare numbers based by day of the week and month Emilio Guerra	by trantrongtb	2	1,182
Help ASAP with formula! LouisCG3	by LouisCG3	4	1,033
Conditional formating Excel 2010 [email protected]	by [email protected]	0	900
Spreading number evenly over 165 days LightningEclipse	by Don Guillett[_2_]	1	1,104
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,143
CONCATENATE - #VALUE! error sometimes ???? [email protected]	by [email protected]	2	1,533
Excel INDIRECT or CONCATENATE ? [email protected]	by simnamsinh	1	1,222
Returning contents of a cell identified by two logic tests SteveRH	by Claus Busch	3	1,163
Conditional formatting on dynamic named range Håkan Björkström	by Håkan Björkström	2	1,255
offset formula causing Circular reference Fighting Illini Mike	by [email protected]	3	3,758
SUMIFS ? for multiple ranges L. Howard	by L. Howard	4	1,279
How to change the direction of the enter key to go horizontal BManske	by [email protected]	5	5,276
How can I pull certain row info based on column info Netti	by [email protected]	1	1,082
Save Random Number Paul B.	by jester23423	5	3,111
Excel 2013 problems as listed below. Desai Sanket	by [email protected]	1	1,030
Calculating my work hours minus lunch break and then adding forweekly total [email protected]	by Alfred Heiligenbrunner	2	1,907
Excel named tables or dynimac named ranges? Håkan Björkström	by Håkan Björkström	0	1,127
automatically putting in dates like tuesday/thursday [email protected]	by [email protected]	0	1,058
Help With Min/Max Values tb	by Claus Busch	1	1,038
Conditional formatting Håkan Björkström	by Håkan Björkström	1	972
Counting specific number following decimal point in a row [email protected]	by Claus Busch	2	1,089
Extract parts of cells to new columns shani1975	by Claus Busch	1	975
Adding up to a whole number Aaron R	by Claus Busch	1	976
Check box linked cell = TRUE then J5 valued reduced by 1 L. Howard	by L. Howard	16	2,214
How to Calculate the average Daily price within a time period San[_4_]	by Alfred Heiligenbrunner	6	1,466
how to convert arabic numbers to english text format in excel? ANURAG ARPAN	by Gabreilla	2	2,522
Help with time/text format [email protected]	by [email protected]	3	979
Cell value reference for ROW in a formula L. Howard	by L. Howard	9	1,239
Find and reference the contents of a cell using multiple criteria James3873	by GS[_2_]	1	930
Mac based trying to hyperlink folder on server nfcurro	by nfcurro	0	898
Using dynamic sheet name in formula [email protected]	by [email protected]	1	1,032
using DGET, help please Terri Hall	by Terri Hall	0	875
automatic transfer of values montypython	by montypython	0	944
change cell value based on another cell set99	by Gord Dibben[_2_]	1	1,051
vLookup returns formula and not result cmc4	by [email protected]	5	1,434
SUMIF Wild Card formula for two words in cell L. Howard	by Claus Busch	9	1,136
Comparing grade data across sheets compelly	by GS[_2_]	1	976
Min / Max together KristyAlison	by KristyAlison	6	1,262
Days in the month Quilp	by Quilp	8	1,488