Excel Worksheet Functions - Page 7

Thread / Thread Starter	Last Post	Replies	Views
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
Add data every 14 days? Kevin Coleman	by Michael Graubart	2	3,423
IFERROR function with Hyperlink [email protected]	by [email protected]	0	2,634
Find Date Between? [email protected]	by Howard Silcock	2	1,086
Inserting rows to linked Workbooks Todd Gerdy	by GS[_6_]	6	1,439
Using Vllookup with OFFSET or ??? [email protected]	by [email protected]	0	822
Find duplicates w/3 criteria [email protected]	by Claus Busch	3	1,100
Vlookup and Countif [email protected]	by Claus Busch	1	1,022
Convert YY[julian day] to dd-mmm-yy - Julian Date.xls (0/1) Phrank	by Phrank	2	1,444
Compare numbers based by day of the week and month Emilio Guerra	by trantrongtb	2	1,065
Help ASAP with formula! LouisCG3	by LouisCG3	4	948
Conditional formating Excel 2010 [email protected]	by [email protected]	0	825
Spreading number evenly over 165 days LightningEclipse	by Don Guillett[_2_]	1	1,018
Cannot bring out the month & year from a date San[_4_]	by San[_4_]	3	958
Multiple returns with one lookup value L. Howard	by L. Howard	2	1,003
CONCATENATE - #VALUE! error sometimes ???? [email protected]	by [email protected]	2	1,442
Excel INDIRECT or CONCATENATE ? [email protected]	by simnamsinh	1	1,137
Returning contents of a cell identified by two logic tests SteveRH	by Claus Busch	3	1,072
Conditional formatting on dynamic named range Håkan Björkström	by Håkan Björkström	2	1,177
offset formula causing Circular reference Fighting Illini Mike	by [email protected]	3	3,584
SUMIFS ? for multiple ranges L. Howard	by L. Howard	4	1,173
How to change the direction of the enter key to go horizontal BManske	by [email protected]	5	5,000
How can I pull certain row info based on column info Netti	by [email protected]	1	954
Save Random Number Paul B.	by jester23423	5	3,014
Excel 2013 problems as listed below. Desai Sanket	by [email protected]	1	969
Calculating my work hours minus lunch break and then adding forweekly total [email protected]	by Alfred Heiligenbrunner	2	1,748
Excel named tables or dynimac named ranges? Håkan Björkström	by Håkan Björkström	0	1,035
automatically putting in dates like tuesday/thursday [email protected]	by [email protected]	0	980
Help With Min/Max Values tb	by Claus Busch	1	949
Conditional formatting Håkan Björkström	by Håkan Björkström	1	832
Counting specific number following decimal point in a row [email protected]	by Claus Busch	2	940
Can Excel automatically insert current date in a cell? AdrianXing	by [email protected]	24	12,875
Extract parts of cells to new columns shani1975	by Claus Busch	1	915
Adding up to a whole number Aaron R	by Claus Busch	1	901
Check box linked cell = TRUE then J5 valued reduced by 1 L. Howard	by L. Howard	16	2,053
How to Calculate the average Daily price within a time period San[_4_]	by Alfred Heiligenbrunner	6	1,354
how to convert arabic numbers to english text format in excel? ANURAG ARPAN	by Gabreilla	2	2,185
Help with time/text format [email protected]	by [email protected]	3	894
Cell value reference for ROW in a formula L. Howard	by L. Howard	9	1,186
Find and reference the contents of a cell using multiple criteria James3873	by GS[_2_]	1	865
Mac based trying to hyperlink folder on server nfcurro	by nfcurro	0	835
Using dynamic sheet name in formula [email protected]	by [email protected]	1	924
using DGET, help please Terri Hall	by Terri Hall	0	819
automatic transfer of values montypython	by montypython	0	883
change cell value based on another cell set99	by Gord Dibben[_2_]	1	986
vLookup returns formula and not result cmc4	by [email protected]	5	1,289
SUMIF Wild Card formula for two words in cell L. Howard	by Claus Busch	9	1,068
Comparing grade data across sheets compelly	by GS[_2_]	1	898
Min / Max together KristyAlison	by KristyAlison	6	1,177
Days in the month Quilp	by Quilp	8	1,404
Countifs across multiple columns using OR [email protected]	by Alfred Heiligenbrunner	2	924
INDIRECT.EXT function, PULL function [email protected]	by [email protected]	0	1,529
Comparison of columns using Conditional Formatting Andrea[_12_]	by MyVeryOwnSelf[_3_]	3	905
converting Dates torpido	by [email protected]	2	1,171
Ranking by MS-Excel Function Ivan Peeler	by Ivan Peeler	3	769
Determine if time is within a windoww Travis	by Claus Busch	2	674
INDEX and MATCH functions - too many arguments Gooch	by GS[_2_]	1	843
With F1 value, look at A, if match or partial match return B L. Howard	by L. Howard	5	910
Update cell value based on name and specific date Leo111	by [email protected]	1	901
Payroll calculations Gracin	by GS[_2_]	1	953
note/coinage converter??? Gotjoy!	by Gotjoy!	0	771
Data consistency Walter Briscoe	by GS[_2_]	1	860
check digit number Benny123	by Claus Busch	6	1,195
Using Intersecting Values on another sheet greenemm	by greenemm	2	731
Count entries in the column translating to minutes. L. Howard	by L. Howard	5	963
Advanvnce formula and function ataur rahman rony	by Mandeep Baluja	1	979
Colouring text in a conditional format Quilp	by Claus Busch	1	761
SUM a Vlookup Array Formula Dave011070	by Claus Busch	4	1,009