Excel Worksheet Functions - Page 954

Thread / Thread Starter	Last Post	Replies	Views
count on condition / Formula SAM ONG	by Bob Phillips	1	490
Copy & Cut different animated boundaries Sam Prince	by Sam Prince	0	391
change data source for many queries at once? Sam Raymond	by Sam Raymond	0	719
Losing Data From Formulas When Cell Variable Changes Sam Spade	by GS[_2_]	7	906
SUMPRODUCT - (amended) Exclude LAST Row of Matched Criteria (Month & Year) Sam via OfficeKB.com	by Sam via OfficeKB.com	2	1,005
Returning Numeric Results across a Single Row in Consecutive Cells Sam via OfficeKB.com	by Sam via OfficeKB.com	8	632
SUMPRODUCT - Exclude LAST Row of Matched Criteria (Month & Year) Sam via OfficeKB.com	by Sam via OfficeKB.com	10	1,513
Return Matched Numeric Labels across Single Row Sam via OfficeKB.com	by Max	4	613
Return Matched Numeric Values across Rows Sam via OfficeKB.com	by Sam via OfficeKB.com	2	982
Return Numeric Labels that have Values =4 across Single Row Sam via OfficeKB.com	by T. Valko	3	561
Return Maximum value for Specific Month(s) Sam via OfficeKB.com	by T. Valko	5	746
Return Numeric Labels that have different Numeric Values Sam via OfficeKB.com	by T. Valko	8	957
Calculate MEDIAN of Last x Rows in a Column Sam via OfficeKB.com	by Sam via OfficeKB.com	6	804
Return across Row Numeric Values Matching EXACT Month & Year for Criteria Sam via OfficeKB.com	by Sam via OfficeKB.com	8	899
Return Numeric Values Matching EXACT Date for Criteria Sam via OfficeKB.com	by Sam via OfficeKB.com	4	1,073
Search Column Data and Return Multiple Values across Row Sam via OfficeKB.com	by JMB	3	842
Count Filtered Visible Items that Match Numeric Criteria between two ranges Sam via OfficeKB.com	by Sam via OfficeKB.com	4	984
Find and Return Numeric Label based on (Numeric Value) Criterion Sam via OfficeKB.com	by Sam via OfficeKB.com	2	926
Find and Count Frequency of Numeric Value in Non-Contiguous Rows Sam via OfficeKB.com	by Sam via OfficeKB.com	2	817
Return Min & Max value of Conditional Formatted cells Sam via OfficeKB.com	by Domenic	20	1,948
Search /Filter vertical Numeric pattern (down single column) Sam via OfficeKB.com	by Sam via OfficeKB.com	0	983
Return Numeric Value to their Matched Value Position in Single Column Sam via OfficeKB.com	by vezerid	3	648
Match Multiple Criteria and Return values positioned above the zero Sam via OfficeKB.com	by Sam via OfficeKB.com	6	754
Average Last 100 Filtered Visible rows Sam via OfficeKB.com	by T. Valko	4	561
MATCH Multiple Criteria & Return Previous / Penultimate Match Sam via OfficeKB.com	by Sam via OfficeKB.com	27	3,726
Return Formula results to specific row of matched criteria Sam via OfficeKB.com	by macropod	3	715
SUMPRODUCT - Tweak Sam via OfficeKB.com	by Sam via OfficeKB.com	2	446
Return Row Number of PREVIOUS Numeric Consecutive Duplicate in Column Sam via OfficeKB.com	by Sam via OfficeKB.com	3	1,116
Conditional Formatting - Draw Line every 10th Row Sam via OfficeKB.com	by vezerid	16	1,579
Conditional Format - Outline Border Sam via OfficeKB.com	by T. Valko	12	1,518
Return Unique Duplicate Numeric Values across Single Row Sam via OfficeKB.com	by T. Valko	7	891
(Part 3) - Retrieve Numeric Label for Max Value by Criteria across Single Row Sam via OfficeKB.com	by Sam via OfficeKB.com	2	526
(Part 2) - Retrieve Numeric Label for Max Value by Specific Day & Month Sam via OfficeKB.com	by Sam via OfficeKB.com	4	469
Retrieve Numeric Label for Max Value by Specific Month Sam via OfficeKB.com	by T. Valko	8	480
SUMPRODUCT - 2 Criteria Sam via OfficeKB.com	by Sam via OfficeKB.com	23	1,574
Using Formula based Cell Content Return Unique Consecutive Duplicate Values Sam via OfficeKB.com	by Sam via OfficeKB.com	8	1,063
Count & Sum Consecutive (2x) appearance of Specific Numeric Values Sam via OfficeKB.com	by Sam via OfficeKB.com	2	897
Return Unique Consecutive Duplicate Values across Single Row Sam via OfficeKB.com	by Sam via OfficeKB.com	22	2,126
Conditional Formatting - 2 Worksheets one Named Range Sam via OfficeKB.com	by Max	5	772
Return Consecutive Values Sam via OfficeKB.com	by Sam via OfficeKB.com	14	1,738
Test IF Two Numeric Values Match (from two separate Dynamic Ranges) Sam via OfficeKB.com	by Biff	3	606
Error Handling #N/A with AVERAGE Function - Average of values in Row Sam via OfficeKB.com	by Sam via OfficeKB.com	13	2,648
Count Intervals of Filtered TEXT values in Column and Return Count across a Row Sam via OfficeKB.com	by Sam via OfficeKB.com	9	2,064
Index Row and return data in a Single Column Sam via OfficeKB.com	by Bob Phillips	6	594
Arithmetical Mode Value for Filtered cells in Multiple Non-Adjacent columns Sam via OfficeKB.com	by Sam via OfficeKB.com	19	1,918
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns Sam via OfficeKB.com	by Sam via OfficeKB.com	4	1,547
Sum Count of Single Criteria in Multiple Non-Adjacent columns Sam via OfficeKB.com	by Sam via OfficeKB.com	9	1,227
Return Consecutive Values - Pairs Sam via OfficeKB.com	by Domenic	6	954
Return Single Instance of Numeric Values from a Column Sam via OfficeKB.com	by Sam via OfficeKB.com	4	1,431
Count Position of Filtered TEXT cells in a column Sam via OfficeKB.com	by Sam via OfficeKB.com	8	1,941
Count Position of Filtered TEXT cells in a column Sam via OfficeKB.com	by Sam via OfficeKB.com	0	1,920
Help to adapt Formula syntax to work with Dynamic Named Ranges Sam via OfficeKB.com	by Sam via OfficeKB.com	13	1,412
Return Count for LAST NonBlank Cell in each Row Sam via OfficeKB.com	by Sam via OfficeKB.com	12	4,146
Summing Returned Positions using MATCH Sam via OfficeKB.com	by Sam via OfficeKB.com	10	1,209
Match Last Occurrence of two numbers and Count to Previous Occurence Sam via OfficeKB.com	by Max	33	5,291
Match Last Occurrence of two numbers and Return Date Sam via OfficeKB.com	by Daniel.M	6	2,157
Count and Sum Total occurrances of two specific numbers Sam via OfficeKB.com	by Sam via OfficeKB.com	10	2,651
Total Summed Count of Numeric Repeat (Paired /Double Instance) Criteria Sam via OfficeKB.com	by Domenic	2	779
Two-Way Lookup Array Formula Sam via OfficeKB.com	by Sam via OfficeKB.com	2	1,096
Return Row Number of LAST Numeric Consecutive Duplicate in Column Sam via OfficeKB.com	by Sam via OfficeKB.com	10	1,067
Retrieve / Return LAST Row of Autofiltered data Sam via OfficeKB.com	by Sam via OfficeKB.com	4	745
Find Multiple instances of Single Criterion in Row & Return To a Single Col Sam via OfficeKB.com	by Peo Sjoblom	16	1,958
Find Numeric Criterion in Column & Return the Numeric Value from Row above Sam via OfficeKB.com	by sam518 via OfficeKB.com	6	837
Sum Count of Numeric Criterion for LAST 5 Rows Sam via OfficeKB.com	by Sam via OfficeKB.com	5	447
Return Summed Count of Multiple Consecutive Numeric Values Sam via OfficeKB.com	by Sam via OfficeKB.com	4	1,839
Match 3 Criteria and Return Lowest Numeric Value Sam via OfficeKB.com	by Sam via OfficeKB.com	16	1,813
Search Multiple columns for criterion asterisk (*) and Return Numeric Label Sam via OfficeKB.com	by Sam via OfficeKB.com	8	895
Count Intervals of 2 Numeric values in same Row and Return Count across Row Sam via OfficeKB.com	by Sam via OfficeKB.com	12	1,927
Sum Count of Numeric Criterion Sam via OfficeKB.com	by Sam via OfficeKB.com	2	404
AVERAGE Row of Numbers and Return Corresponding Numeric Label Sam via OfficeKB.com	by Ron Rosenfeld	14	1,729
Sum Count of Two Numbers in the same Row Sam via OfficeKB.com	by Sam via OfficeKB.com	8	783
Help to adapt Formula syntax to work with Visible Filtered Cells Sam via OfficeKB.com	by Sam via OfficeKB.com	6	943
Arithmetical Mode Value for Filtered cells in Multiple Adjacent columns Sam via OfficeKB.com	by Sam via OfficeKB.com	4	558
SUMPRODUCT Help Sam via OfficeKB.com	by Sam via OfficeKB.com	2	500
SUMPRODUCT Help Sam via OfficeKB.com	by Sam via OfficeKB.com	2	574