Excel Worksheet Functions - Page 8

Thread / Thread Starter	Last Post	Replies	Views
Arrayformulas with either/or nested to sumproduct if eitherconditions are true Jonathan Pence	by Claus Busch	13	1,872
A consolidating formula? L. Howard	by Claus Busch	7	977
Format the cells pkedward	by Claus Busch	1	870
Selecting rows. Mandeep Baluja	by Claus Busch	3	974
How to count the maximum number flanked by zeros Tez[_2_]	by [email protected]	9	1,048
Invisible typing!! MikeC2909	by Claus Busch	5	1,053
Changing Sum Range Based on Date Chosen from Drop Down List [email protected]	by Claus Busch	1	1,107
Help With Sorting tb	by tb	2	1,233
SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel. [email protected]	by [email protected]	1	2,212
Shift Differential TimeSheet Formulas Sophia	by dksweeney	9	7,242
TRANSPOSE a row to Uneven column [email protected]	by Ron Rosenfeld[_2_]	1	1,654
Break Total (SUM question) [email protected]	by GS[_2_]	3	1,373
Complex Filtering Formula SalientAnimal	by SalientAnimal	0	843
Help with an Excel formula problem rdjohnsons	by SUDHIR VERMA	5	1,196
Excel gives me false IRR values\|How do I find the real IRR on this investment LaWhore Mama	by joeu2004[_2_]	3	1,703
Problem with looking up a value. Jan Kronsell[_5_]	by Jan Kronsell[_5_]	2	842
If Formula Davidgberg	by Claus Busch	2	918
How to sum adjacent cells based on values of each cell? redlegend	by redlegend	4	1,765
Can Excel trigger Outlook reminder? Andee39	by [email protected]	9	5,020
numbering [email protected]	by Auric__	1	1,062
Conditional formatting on a dynamic range - workaround Håkan Björkström	by GS[_2_]	1	2,070
How to feed master W/S into two JasonL	by Claus Busch	8	3,259
SUMIF across multiple sheets Jan Kronsell[_5_]	by Jan Kronsell[_5_]	6	1,333
Formula for sum of alternate cells John Blackwell	by [email protected]	14	3,477
Help with an Array / Average Question please? a.c.sanchez	by vfphaitrieua	1	1,218
Proper Formula is stuck and does not work Diggsy	by [email protected]	6	2,219
Subtracting based on 2 conditions [email protected]	by [email protected]	3	1,103
RETURN VALUE OF ROW 1 Chris Smith[_5_]	by Chris Smith[_5_]	0	720
Match a UK postcode from a table of postcodes Chris Smith[_5_]	by Chris Smith[_5_]	0	1,184
is it posible to have a formula for factorial via vba code? thread	by [email protected]	4	1,611
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous to that San[_4_]	by San[_4_]	12	2,220
An Eye for an Eye Are Are \| Excel IRR_NEW function Discounted Dollar	by Discounted Dollar	0	1,815
Dynamic col_index_num in VLOOKUP? tb	by San[_4_]	5	2,765
How do I get Rid of the Circumflex Accent (Caret) tb	by Gord Dibben[_2_]	2	2,536
Upgrade question Colin Hayes	by joeu2004[_2_]	3	1,674
Need a formula which shows the table.. akinkaraman	by akinkaraman	3	1,836
If/Then functions Grimsgrin	by Ron Rosenfeld[_2_]	1	1,796
Autofill Formulas edwinhwhw87	by Walter Briscoe	5	2,249
#N/A In Cells tb	by tb	7	1,813
Can I use solver for this?? ulna	by ulna	0	1,455
Those who cheat SuckSeed Negrovich Hunt	by Negrovich Hunt	0	1,581
SUMIF, 3D FORMULA, EXCEL FORMULA HELP [email protected]	by Claus Busch	1	1,886
Sum of Result formula six777	by six777	0	748
ADVANCED: Need to sum values in different worksheets based on a rowand column criteria. [email protected]	by [email protected]	0	814
Return Min & Cell address L. Howard	by L. Howard	7	954
non repeating Random number generation [email protected]	by [email protected]	0	733
Time Zone Conversions Jeff Kohl	by Claus Busch	4	1,485
Excel Macros help [email protected]	by [email protected]	0	991
How do I update my worksheet? Need Help [email protected]	by [email protected]	0	1,042
What formula would i need for this?? samshepcap	by joeu2004[_2_]	1	1,106
Complex search and replace macro based on input variables. Colin Hayes	by GS[_2_]	12	1,653
Convert Decimal fractions to binary and vice versa [email protected]	by Ron Rosenfeld[_2_]	2	3,612
Really need some help with a multi conditional SumProduct Keelin George	by [email protected]	1	742
Weighted average till sum of exposure reaches a threshold [email protected]	by [email protected]	0	835
difference between two cells jeromeUAE	by jeromeUAE	2	724
Rounding value from millions to decimal places Bagia	by Whydidjuly	7	3,259
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS [email protected]	by Ron Rosenfeld[_2_]	2	1,294
Google Adsense Account Approval Tricks [email protected]	by [email protected]	0	803
How to insert infinity symbol in excel? Zhead	by Cloud Strife[_3_]	6	8,835
return a value of specific text within a sentence top00001	by Claus Busch	1	734
Is it possible to make Excel assume a time happens after another time? [email protected]	by Howard Silcock	1	912
Check for two sheets. Add or subtract as necessary. Colin Hayes	by Colin Hayes	2	575
want to track time while paste value in multiple column of same roe [email protected]	by GS[_2_]	1	786
Is multiple IF statements what I'm looking for? Synapses	by joeu2004[_2_]	2	606
Augmenting an integer in a column to reflect duplicates in another Colin Hayes	by Colin Hayes	23	2,159
Count multiple specific terms masking	by Claus Busch	1	604
Insert/ delete row in protected worksheet [email protected]	by [email protected]	0	721
Two spreadsheets, filling data from one to the other. [email protected]	by [email protected]	0	593
How to add straight line from cell value in pivot table chart. mehmood	by mehmood	0	656
EAN/UCC-14 Barcode: set Excel column widths based on a cell value? d	by derek054	1	1,039
Cell Auto Lock Moideen	by Gord Dibben[_2_]	2	730
worksheet is not open and copy ataur rahman rony	by ataur rahman rony	0	565
If Date In Cell Is Greater Than Todays CRAIGJACK	by CptnRsk	3	20,794
hidden rows problem ataur rahman rony	by ataur rahman rony	7	672
Converting formula from Lotus123 to Excel Lisa V	by joeu2004[_2_]	2	565