Excel Worksheet Functions - Page 101

Thread / Thread Starter	Last Post	Replies	Views
how do I highlight rows based on conditional formatting Honkus	by T. Valko	1	945
Macro for multiple rows sbaby	by sbaby	3	1,419
How to get rid of #Value when multiplying erika rock	by Peo Sjoblom[_3_]	1	2,847
Settign a Maximum and Minimum Row Height Stephen	by Rick Rothstein	1	1,202
Print just the list after performing a "find all" in Excel Office Minion	by Office Minion	0	516
shared workbook issue Brendan Quirk	by Brendan Quirk	0	556
Check for NON-presence of a string in another string G.P.N.L. c.v.a.	by Rick Rothstein	4	761
Subtotal level buttons easton	by easton	0	669
INDEX and MATCH PPL	by T. Valko	3	583
MedianIf multiple range and criteria C.	by T. Valko	5	1,918
Subtotals (outline) features grayed out Rubystarx	by Kelly Gates	2	4,369
Formula to return data using hyperlink? Mohamed	by Mike H	2	600
Lookup and Display Multiple Unique values based on criteria MPI Planner[_2_]	by MPI Planner[_2_]	2	1,657
Excel 2007 HeatherJ	by David Biddulph[_2_]	5	550
Subtraction Function using cells with other functions in them modemers	by Paul C	2	964
3 tier incentive matrix w/ infinite possibilities jjones	by Pete_UK	7	699
Monthly files dimitry scharff	by dimitry scharff	2	604
remove duplicates except blanks jat	by Jacob Skaria	2	1,175
Can conditional formatting be used where ..... Gotroots	by Ms-Exl-Learner	3	527
vlookup based on a different cell Scott A[_2_]	by Pete_UK	3	495
SUM A SINGLE TEXT FROM CELLS INTO ONE BigCarol	by David Biddulph[_2_]	1	641
How do I produce consecutive invoice numbers in Excel? John Z	by John Z[_2_]	4	2,265
Max Cell Value Saskatoon Jerry	by T. Valko	5	571
Text function Howard	by L. Howard Kittle	3	681
Date Format Freshman	by Freshman	3	458
List Disctinct Strings from Range of Cells golddave	by Sunir M S[_2_]	23	2,042
Extract Supplier Name Howard	by Jacob Skaria	2	539
How do I convert dd/mm/yy date format to yyddd Julian date format itzy bitzy[_2_]	by Rick Rothstein	8	5,132
Subtotaling Katie	by Teethless mama	1	466
File Path Max2073	by Max2073	1	520
how do i resize column letters in excel 2007 Debby	by T. Valko	1	817
Boolean Math Art	by Rick Rothstein	8	1,053
Getpivotdata....showing filter Tami	by Tami	0	1,343
Icons on Customized Toolbar Tami	by Tami	2	553
Return Names From List DeeCee	by OtÃ¡vio Alves Ribeiro	2	765
Find & replace window DreamKid	by DreamKid	0	478
sum only if a certain cell contains a date mimsly17	by Fred Smith[_4_]	2	786
Counting only displayed cells in the column CEG_Staffer[_2_]	by Pete_UK	3	519
addding/omitting "x" tleehh	by David Biddulph[_2_]	5	475
Data Lost in Microsoft Query Eva	by Eva	0	724
Microsoft Querry Eva	by Eva	2	506
Lookup value off by one row awalker	by awalker	2	2,835
Returning A Minimum Figure Hammer[_2_]	by Ms-Exl-Learner	3	554
Sumproduct with conditions EZ[_2_]	by EZ[_2_]	0	630
Adding if to Average If Array function Diddy	by Diddy	5	802
Vlookup return Zero if not there Troy[_2_]	by FrankWood	2	653
Multi-condition SUMIF Manuel	by Mohamed	4	813
Concatenate LWilson	by LWilson	5	686
Counting Individuals NOT Occurrences with than one criteria Royegg	by Royegg	5	544
Distribution AK	by Luke M	1	539
Why did I use array formula - help Diddy	by Diddy	7	562
Formula to equal a maximum of 100% Hammer[_2_]	by Ms-Exl-Learner	3	1,874
Microsoft Visio templates - Stencil for Visio to create IT diagrams &network design Betty Carson	by [email protected]	2	2,962
Spredsheet problem wildlife guy	by Joe User[_2_]	4	597
Opening Files - Macro Max2073	by Jacob Skaria	1	578
"Alert" only if 'not contained in' Steve	by T. Valko	3	465
Search for matches in two columns Dingy101	by T. Valko	11	1,020
Excel dates MaryJC	by OssieMac	3	457
IF/VLOOKUP between multiple worksheets Joe	by T. Valko	1	733
Excel Formulas Dianne W	by FSt1	2	455
calculating subtotals for sequential blank cells in 1 column Katie	by Tom Hutchins	1	604
using button to clear contents Charlie	by Dave Peterson	2	1,457
Is there a formula that can do this? gootroots	by Ashish Mathur[_2_]	3	618
Sumif Deviation is positive chg	by Ashish Mathur[_2_]	2	681
Subtotal function is greyed-out - can't insert jmcclain	by Ashish Mathur[_2_]	3	1,611
Help with difficult formula requirement XMan	by Ashish Mathur[_2_]	1	447
Data lost Eva	by Eva	0	503
Changing number to mins/seconds Katie	by Katie	2	443
COUNT TC	by Joe User[_2_]	3	454
Copy down formula macro Eva	by Eva	3	2,130
How do I create a combo box that is tied to another combo box? rosamaria	by ryguy7272	2	626
Conditional Formatting Andie	by Paul C	1	483
Changing number to mins/seconds Mike H	by Mike H	0	423
using countif in a filtered range Mr E	by T. Valko	12	1,377
Return nothing if criteria is not met Gotroots	by Gotroots	7	1,282