Excel Worksheet Functions - Page 955

Thread / Thread Starter	Last Post	Replies	Views
Sum Count of Numeric Duplicates: appears x2 in any Row Sam via OfficeKB.com	by T. Valko	19	1,294
Count Consecutive Numbers in a Row Sam via OfficeKB.com	by Sam via OfficeKB.com	5	2,593
Exclude #N/A values and Return Numeric values to consecutive cells in Single Row Sam via OfficeKB.com	by T. Valko	5	1,149
Match Criteria & Return Sequential Count Sam via OfficeKB.com	by Sam via OfficeKB.com	8	984
MODE - Second most frequent value Sam via OfficeKB.com	by Sam via OfficeKB.com	2	2,225
Count Longest Consecutive Sequence of zeros Sam via OfficeKB.com	by MartinW[_2_]	12	6,650
Match Multiple Criteria & Return Numeric Labels across single row Sam via OfficeKB.com	by Max	8	772
Change Boolean / Logical Operator using Input Cell Sam via OfficeKB.com	by Sam via OfficeKB.com	2	737
Return Last 10 rows in reverse row order. Sam via OfficeKB.com	by Roger Govier[_3_]	9	744
Return MAX value Offset 1 Row from Criterion and count occurrence Sam via OfficeKB.com	by Domenic	5	757
SUMPRODUCT Adaptation Sam via OfficeKB.com	by Sam via OfficeKB.com	4	385
Count x2 Appearance of Numeric Value in any Row Sam via OfficeKB.com	by JP[_4_]	9	660
Massaging duplicates [email protected]	by Aladin Akyurek	6	450
How to get SUMPRODUCT on filtered cells Sam.D[_2_]	by Gary''s Student	1	866
the sum of all bolded numbers Sam12345	by DOR	5	773
Calculating Overtime sam13484 via OfficeKB.com	by	1	557
Creating Drop Down lists Sam151	by Larry	4	479
SUMIF between 2 amounts, eg 51>x> -51 sam158963	by Harlan Grove	3	478
Formula to get values between 8 and 15 Sam510	by Sam510	3	601
Seperate First and Last Name into different cells Sam555	by Rajesh HR, BAngalore	5	1,043
OR & IF Functions Together sam74	by Raju Boine.	3	427
Excel formula help sam8	by sam8	7	464
Count Dates in a range based on Column Header Id without using sum-product sam999	by zvkmpw	1	939
Using Comma in customise option samahoque	by Niek Otten	1	696
Run Macro for all worksheets saman110 via OfficeKB.com	by saman110 via OfficeKB.com	2	1,987
how can I have Excel total a column of # that were derived by form Samantha	by Max	2	444
How do I convert from U.S. currency to Canadian? Samantha	by Gord Dibben	4	670
vlookup formula error Samantha	by Dave Peterson	2	543
how to convert 357646 seconds into hh:mm:ss format? Samantha	by Fred Smith	6	963
vlookup i think samantha	by Ms-Exl-Learner	3	486
vlookup help samantha	by Pete_UK	1	434
Transferring CERTAIN Data from one worksheet to another Samantha	by Herbert Seidenberg	1	382
Sharing data from one worksheet to another Samantha	by Samantha	0	721
vlookup error!! Samantha	by JulieD	1	597
data structure and my problem samantha	by Arvi Laanemets	2	546
Yes or No buttons,list,or Combo box Samantha	by JulieD	3	432
convert date of birth to mos. old now, 30 and 60 days Samantha	by Ron Rosenfeld	1	690
calculate a date X number of days before/after given date Samantha	by T. Valko	1	3,309
Auto Running Numbers in worksheets or workbooks Samantha	by Samantha	0	577
Match name not exact Samantha	by Aladin Akyurek	3	922
With formulas does anyone know the order of precedence BOMDAS Samantha	by Daminc	9	833
HOW DUPLICATE TEXT ON ALL PAGES OF WORKSHEET FROM ONE CELL Samantha Stevenson	by Samantha Stevenson	2	397
Ratio Function Samantha0310	by Bernie Deitrick	2	446
How to know Rank Of FieldName ?? Samary	by Samary	0	410
VLOOKUP function with embedded LEFT SamB	by David Biddulph[_2_]	7	2,677
MORE THAN 8 IF CONDITION IN A FORMULA IS NOT ACCEPTING SAMBASIVARAO RAVI	by macropod	3	1,196
weekly time sheet for the whole team?(6 members) sambasov	by Pete_UK	3	797
Printing only certain rows? sambles28	by Don Guillett	1	459
Comparing dates from VLOOKUP functions not working right Sambonator	by Max	2	3,081
Date comparisons within AND() functions Sambonator	by Bernie Deitrick	1	555
Adding the total # of characters in multiple cells SAMCAT	by Shane Devenshire[_2_]	3	994
HELP!!!! Cell Value in a Cell Address samccaskill	by swatsp0p	4	587
Using a Cell Value in another Cell Address samccaskill	by RagDyer	2	448
Have column of nums, need qty of each? samckitt	by Arvi Laanemets	3	424
Combining multiple files in Excel [email protected]	by Ron de Bruin	1	444
Issues in Data Tables Sameer Achan	by Sameer Achan	2	442
need to make 4 typical entries regularly in excel sameer adhikari	by Ashish Mathur[_2_]	3	393
How to change a MS Word file to an Excel file Sameera	by Anne Troy	1	484
Excell Page setup Sameer[_3_]	by Jock	1	560
convert arbic numbers to arabic text Sameh	by Sameh	0	1,660
shortcuts in Excel SamelaD	by Peo Sjoblom	1	391
How do you consolidate tables contianing text? samenvoegen van sheets	by samenvoegen van sheets	0	595
consolidation of tables in excel with text and figures samenvoegen van sheets	by Ron Coderre	8	2,292
Vlookup when more than one possiblity samenvoegen van sheets	by Dav	1	453
msgbox / inputbox etc samenvoegen van sheets	by Dave Peterson	2	453
Unable to run Macro in an Add-in [email protected]	by [email protected]	0	353
Best way to get a list of unique entries in a field [email protected]	by Biff	2	688
Excel won't update/calculate a single cell in a workbook [email protected]	by [email protected]	2	1,273
Sumif function with two criteria from different columns SamFortMyers	by SamFortMyers	4	602
Formula to delete blank cells across multiple columns? SamFunMail	by Max	2	2,104
Need a formula that finds the last used cell in a range samfw	by Peo Sjoblom	4	1,414
How do I set up a value (34.7) to value (34) in excel? sami	by Ragdyer	2	376
auto-insert colon when entering times sami	by Gord Dibben	1	2,015
Excel becomes slow Sami	by David McRitchie	1	409
COUNTIF and multiple conditions Sami	by Roger Govier	1	400