Excel Worksheet Functions - Page 15

Thread / Thread Starter	Last Post	Replies	Views
Countifs across multiple columns using OR [email protected]	by Alfred Heiligenbrunner	2	1,004
INDIRECT.EXT function, PULL function [email protected]	by [email protected]	0	1,679
Comparison of columns using Conditional Formatting Andrea[_12_]	by MyVeryOwnSelf[_3_]	3	1,027
converting Dates torpido	by [email protected]	2	1,268
Ranking by MS-Excel Function Ivan Peeler	by Ivan Peeler	3	846
Determine if time is within a windoww Travis	by Claus Busch	2	761
INDEX and MATCH functions - too many arguments Gooch	by GS[_2_]	1	964
With F1 value, look at A, if match or partial match return B L. Howard	by L. Howard	5	987
Update cell value based on name and specific date Leo111	by [email protected]	1	979
Payroll calculations Gracin	by GS[_2_]	1	1,044
note/coinage converter??? Gotjoy!	by Gotjoy!	0	833
Data consistency Walter Briscoe	by GS[_2_]	1	953
check digit number Benny123	by Claus Busch	6	1,280
Using Intersecting Values on another sheet greenemm	by greenemm	2	813
Count entries in the column translating to minutes. L. Howard	by L. Howard	5	1,020
Advanvnce formula and function ataur rahman rony	by Mandeep Baluja	1	1,061
Colouring text in a conditional format Quilp	by Claus Busch	1	848
SUM a Vlookup Array Formula Dave011070	by Claus Busch	4	1,125
Dependent drop down dynamic range formula, off sheet. L. Howard	by GS[_2_]	7	1,116
sum up a column ignoring values coloured red Quilp	by Quilp	6	1,262
Vlookup Match and Index Assistance Jeremy Odenbrett	by Mandeep Baluja	2	1,111
Vlookups not working [email protected]	by Mandeep Baluja	2	1,063
No save function if Jeff Owen	by Jeff Owen	7	1,074
Formula (or code) return the largest number of duplicates in a list. L. Howard	by L. Howard	16	1,902
Applicability of LBT Navneet Agarwal	by Navneet Agarwal	0	850
Percentage Increase tb	by Gord Dibben[_2_]	13	2,149
Arrayformulas with either/or nested to sumproduct if eitherconditions are true Jonathan Pence	by Claus Busch	13	2,059
A consolidating formula? L. Howard	by Claus Busch	7	1,066
Format the cells pkedward	by Claus Busch	1	957
Selecting rows. Mandeep Baluja	by Claus Busch	3	1,033
How to count the maximum number flanked by zeros Tez[_2_]	by [email protected]	9	1,165
Invisible typing!! MikeC2909	by Claus Busch	5	1,166
Changing Sum Range Based on Date Chosen from Drop Down List [email protected]	by Claus Busch	1	1,187
Help With Sorting tb	by tb	2	1,304
SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel. [email protected]	by [email protected]	1	2,281
TRANSPOSE a row to Uneven column [email protected]	by Ron Rosenfeld[_2_]	1	1,750
Break Total (SUM question) [email protected]	by GS[_2_]	3	1,457
Complex Filtering Formula SalientAnimal	by SalientAnimal	0	910
Help with an Excel formula problem rdjohnsons	by SUDHIR VERMA	5	1,310
Excel gives me false IRR values\|How do I find the real IRR on this investment LaWhore Mama	by joeu2004[_2_]	3	1,772
Problem with looking up a value. Jan Kronsell[_5_]	by Jan Kronsell[_5_]	2	905
If Formula Davidgberg	by Claus Busch	2	1,010
How to sum adjacent cells based on values of each cell? redlegend	by redlegend	4	1,835
Can Excel trigger Outlook reminder? Andee39	by [email protected]	9	5,131
numbering [email protected]	by Auric__	1	1,130
Conditional formatting on a dynamic range - workaround Håkan Björkström	by GS[_2_]	1	2,170
How to feed master W/S into two JasonL	by Claus Busch	8	3,368
SUMIF across multiple sheets Jan Kronsell[_5_]	by Jan Kronsell[_5_]	6	1,464
Formula for sum of alternate cells John Blackwell	by [email protected]	14	3,619
Help with an Array / Average Question please? a.c.sanchez	by vfphaitrieua	1	1,294
Proper Formula is stuck and does not work Diggsy	by [email protected]	6	2,313
Subtracting based on 2 conditions [email protected]	by [email protected]	3	1,163
RETURN VALUE OF ROW 1 Chris Smith[_5_]	by Chris Smith[_5_]	0	778
Match a UK postcode from a table of postcodes Chris Smith[_5_]	by Chris Smith[_5_]	0	1,251
is it posible to have a formula for factorial via vba code? thread	by [email protected]	4	1,719
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous to that San[_4_]	by San[_4_]	12	2,391
An Eye for an Eye Are Are \| Excel IRR_NEW function Discounted Dollar	by Discounted Dollar	0	1,923
Dynamic col_index_num in VLOOKUP? tb	by San[_4_]	5	2,833
How do I get Rid of the Circumflex Accent (Caret) tb	by Gord Dibben[_2_]	2	2,832
Upgrade question Colin Hayes	by joeu2004[_2_]	3	1,773
Need a formula which shows the table.. akinkaraman	by akinkaraman	3	1,912
If/Then functions Grimsgrin	by Ron Rosenfeld[_2_]	1	1,856
Autofill Formulas edwinhwhw87	by Walter Briscoe	5	2,335
#N/A In Cells tb	by tb	7	1,877
Can I use solver for this?? ulna	by ulna	0	1,519
Those who cheat SuckSeed Negrovich Hunt	by Negrovich Hunt	0	1,637
SUMIF, 3D FORMULA, EXCEL FORMULA HELP [email protected]	by Claus Busch	1	2,002
Sum of Result formula six777	by six777	0	790
ADVANCED: Need to sum values in different worksheets based on a rowand column criteria. [email protected]	by [email protected]	0	894
Return Min & Cell address L. Howard	by L. Howard	7	1,229
non repeating Random number generation [email protected]	by [email protected]	0	784
Time Zone Conversions Jeff Kohl	by Claus Busch	4	1,658
Excel Macros help [email protected]	by [email protected]	0	1,054
How do I update my worksheet? Need Help [email protected]	by [email protected]	0	1,103
What formula would i need for this?? samshepcap	by joeu2004[_2_]	1	1,186