Excel Worksheet Functions - Page 165

Thread / Thread Starter	Last Post	Replies	Views
Display multiple results based on one cell Cul	by Teethless mama	5	944
cell matching issue totalnatal	by Lars-Åke Aspelin[_2_]	1	354
View sheets (pages) horizontally Herb[_2_]	by Herb[_2_]	3	1,229
SUMPRODUCT Srikanth[_5_]	by Abdul[_2_]	1	385
Linking spreadsheet Saintsman	by Ashish Mathur[_2_]	1	428
Format Number 000000 00000 000000 Abdul[_2_]	by Abdul[_2_]	0	1,270
Highlight the cell based on selected value Max	by Max	2	494
I need a formula......... Keith D.B.	by Keith D.B.	4	492
conditional formatte date in a1 calculate the date in A2 jcurran1ma	by Shane Devenshire[_2_]	3	464
what is the Function for reducing balance depriciation? zamant	by Shane Devenshire[_2_]	1	840
sumif? Scott A[_2_]	by Shane Devenshire[_2_]	3	500
New 2007 Sumifs formula - is there a new multiple criteria vlookup westy	by Shane Devenshire[_2_]	2	1,441
Please Help - Trouble with counting occurrences in external file dz	by dz	2	407
Relationship between number Damon Cavanagh	by Damon Cavanagh	0	458
Correlation between 2 variables Damon Cavanagh	by Damon Cavanagh	0	549
Moved workbook-File name, minimize, maximize and close are not vis KELC-F/A	by Shane Devenshire[_2_]	2	948
how do you have 2 criterias be picked up in a lookup? N. Vu	by Shane Devenshire[_2_]	5	578
Excel - text in one cell oMaLLey	by Gord Dibben	2	513
calculate average from non contiguous column, ignoring (0) values Jesse	by Harlan Grove[_2_]	3	3,239
COUNTIF( {local cells}, {number from other sheet}) ShadoShryke	by Harlan Grove[_2_]	6	636
Need help sorting data Yookaroo	by Yookaroo	4	593
How can I validate my Excel password against a INI file Andrea	by jaf	1	522
MAX IF? Tami	by Ken	5	494
Average while using SumProduct Srikanth[_5_]	by Srikanth[_5_]	0	423
Trying to make averages AND sums of one spreadsheet of information E[_2_]	by E[_2_]	0	486
Combining 2 percentages into one cell and displaying as % format RLind	by Shane Devenshire[_2_]	5	2,748
Function to add 3 column (of YES) to give a total % complete preyesone	by Ken	7	529
Number of Specific Day within Dates Shane Devenshire[_2_]	by Shane Devenshire[_2_]	0	481
Array formulas not working in Excel 2003. kamelone	by Shane Devenshire[_2_]	2	1,776
Combining two functions preyesone	by Ken	13	1,292
Worksheet Limit in Workbook Ron	by Ron	2	426
Number of Specific Day within Dates Teethless mama	by Teethless mama	0	380
Number of Specific Day within Dates Alan McQ via OfficeKB.com	by Alan McQ via OfficeKB.com	0	406
Logical Function excel 2003 Denver	by Shane Devenshire[_2_]	4	446
Help Rum	by Teethless mama	4	588
Index Formula Cow Girl	by Teethless mama	9	499
sum function dannyboy8	by Rick Rothstein	3	366
How to not get '0' or '#DIV/0!' in a cell with a percentage formul Rum	by Jacob Skaria	7	637
How to return a value from another workbook Narnimar	by Jacob Skaria	1	806
Rearreng Manualy in Pivottable LHM	by Roger Govier[_3_]	2	409
How to return a value from another workbook Narnimar	by Narnimar	0	648
countifs JRD	by Shane Devenshire[_2_]	5	929
Conditional format entire column JC	by Shane Devenshire[_2_]	3	574
Weekends JRD	by Shane Devenshire[_2_]	6	536
Average of values that need to be looked up from another sheet NLJR	by Shane Devenshire[_2_]	1	377
Make them work on the Each cell Value Steved	by T. Valko	7	476
How can i set a formula which shows 2nd last Monday of the month? J	by Teethless mama	5	803
Conditional formatting dates? ReapeR	by Fred Smith[_4_]	8	541
Need help sorting data Yookaroo	by Yookaroo	0	390
vlookup more then 1 match or how do I magicaldean	by Roger Govier[_3_]	1	372
excel hyperlink text to display and vlookup bluker	by bluker	2	1,618
Sum Value of rows based on two common fields jdg	by jdg	5	1,619
How to set formula for poping up the date of next Wednesday.... J	by Mike H	2	1,369
Assist with formula Soth	by Soth	3	422
Conditional Sum in Array with wild card and between dates Hank01061567	by Hank01061567	3	1,072
Need help displaying odd numbered month Greg L[_3_]	by Sheeloo	3	979
count formula OKY	by OKY	2	356
How can I group and display columns automatically? faraz316	by Ken	3	2,083
Automatically copy from Master worksheet to others Susan S	by Ashish Mathur[_2_]	5	1,634
Skip Rows in Fill Series and Filter to Two different sheets Benjamin	by Ashish Mathur[_2_]	3	1,840
Multiple column filtering faraz316	by Shane Devenshire[_2_]	2	377
SUMIF, IF ? Steve	by Steve	5	374
Using Advanced Filter: How do you MOVE the selected rows... ravif	by Fred Smith[_4_]	3	1,172
How can I get Microsoft excel to calculate increasing number again Anna	by NBVC[_64_]	4	825
Breaking links in Excel brosull	by Shane Devenshire[_2_]	2	429
Help with SUMPRODUCT EricB	by NBVC[_62_]	5	442
Sorting 2 data columns in Pivot Table Alonso[_2_]	by Alonso[_2_]	2	1,918
unable to open protected document I created TBryan	by Harlan Grove[_2_]	2	485
Locking a Spreadsheet but allow inserting Tami	by Tami	5	545
select max value from row of data and column containing max value Jesse	by Shane Devenshire[_2_]	2	1,799
Rolling 12 month total MH	by Lars-Åke Aspelin[_2_]	7	2,031
cell w/ drop down then reference Jackie	by T. Valko	5	462
how do i remove an excel link that break link won't remove brosull	by Shane Devenshire[_2_]	1	2,034
Excel should allow at least 2 vertical and horizontal splits. wmichaux	by Shane Devenshire[_2_]	1	685
Hyperlink to a specific place in a document Al	by Dave Peterson	3	769