Excel Worksheet Functions - Page 165

Thread / Thread Starter	Last Post	Replies	Views
Display multiple results based on one cell Cul	by Teethless mama	5	928
cell matching issue totalnatal	by Lars-Åke Aspelin[_2_]	1	340
View sheets (pages) horizontally Herb[_2_]	by Herb[_2_]	3	1,221
SUMPRODUCT Srikanth[_5_]	by Abdul[_2_]	1	370
Linking spreadsheet Saintsman	by Ashish Mathur[_2_]	1	414
Format Number 000000 00000 000000 Abdul[_2_]	by Abdul[_2_]	0	1,235
Highlight the cell based on selected value Max	by Max	2	469
I need a formula......... Keith D.B.	by Keith D.B.	4	480
conditional formatte date in a1 calculate the date in A2 jcurran1ma	by Shane Devenshire[_2_]	3	451
what is the Function for reducing balance depriciation? zamant	by Shane Devenshire[_2_]	1	822
sumif? Scott A[_2_]	by Shane Devenshire[_2_]	3	489
New 2007 Sumifs formula - is there a new multiple criteria vlookup westy	by Shane Devenshire[_2_]	2	1,424
Please Help - Trouble with counting occurrences in external file dz	by dz	2	391
Relationship between number Damon Cavanagh	by Damon Cavanagh	0	447
Correlation between 2 variables Damon Cavanagh	by Damon Cavanagh	0	533
Moved workbook-File name, minimize, maximize and close are not vis KELC-F/A	by Shane Devenshire[_2_]	2	934
how do you have 2 criterias be picked up in a lookup? N. Vu	by Shane Devenshire[_2_]	5	556
Excel - text in one cell oMaLLey	by Gord Dibben	2	501
calculate average from non contiguous column, ignoring (0) values Jesse	by Harlan Grove[_2_]	3	3,173
COUNTIF( {local cells}, {number from other sheet}) ShadoShryke	by Harlan Grove[_2_]	6	611
Need help sorting data Yookaroo	by Yookaroo	4	571
How can I validate my Excel password against a INI file Andrea	by jaf	1	511
MAX IF? Tami	by Ken	5	483
Average while using SumProduct Srikanth[_5_]	by Srikanth[_5_]	0	406
Trying to make averages AND sums of one spreadsheet of information E[_2_]	by E[_2_]	0	466
Combining 2 percentages into one cell and displaying as % format RLind	by Shane Devenshire[_2_]	5	2,711
Function to add 3 column (of YES) to give a total % complete preyesone	by Ken	7	517
Number of Specific Day within Dates Shane Devenshire[_2_]	by Shane Devenshire[_2_]	0	476
Array formulas not working in Excel 2003. kamelone	by Shane Devenshire[_2_]	2	1,759
Combining two functions preyesone	by Ken	13	1,268
Worksheet Limit in Workbook Ron	by Ron	2	400
Number of Specific Day within Dates Teethless mama	by Teethless mama	0	369
Number of Specific Day within Dates Alan McQ via OfficeKB.com	by Alan McQ via OfficeKB.com	0	388
Logical Function excel 2003 Denver	by Shane Devenshire[_2_]	4	433
Help Rum	by Teethless mama	4	572
Index Formula Cow Girl	by Teethless mama	9	484
sum function dannyboy8	by Rick Rothstein	3	357
How to not get '0' or '#DIV/0!' in a cell with a percentage formul Rum	by Jacob Skaria	7	618
How to return a value from another workbook Narnimar	by Jacob Skaria	1	789
Rearreng Manualy in Pivottable LHM	by Roger Govier[_3_]	2	402
How to return a value from another workbook Narnimar	by Narnimar	0	642
countifs JRD	by Shane Devenshire[_2_]	5	920
Conditional format entire column JC	by Shane Devenshire[_2_]	3	560
Weekends JRD	by Shane Devenshire[_2_]	6	510
Average of values that need to be looked up from another sheet NLJR	by Shane Devenshire[_2_]	1	367
Make them work on the Each cell Value Steved	by T. Valko	7	454
How can i set a formula which shows 2nd last Monday of the month? J	by Teethless mama	5	786
Conditional formatting dates? ReapeR	by Fred Smith[_4_]	8	521
Need help sorting data Yookaroo	by Yookaroo	0	374
vlookup more then 1 match or how do I magicaldean	by Roger Govier[_3_]	1	352
excel hyperlink text to display and vlookup bluker	by bluker	2	1,601
Sum Value of rows based on two common fields jdg	by jdg	5	1,593
How to set formula for poping up the date of next Wednesday.... J	by Mike H	2	1,263
Assist with formula Soth	by Soth	3	399
Conditional Sum in Array with wild card and between dates Hank01061567	by Hank01061567	3	1,062
Need help displaying odd numbered month Greg L[_3_]	by Sheeloo	3	965
count formula OKY	by OKY	2	350
How can I group and display columns automatically? faraz316	by Ken	3	2,061
Automatically copy from Master worksheet to others Susan S	by Ashish Mathur[_2_]	5	1,579
Skip Rows in Fill Series and Filter to Two different sheets Benjamin	by Ashish Mathur[_2_]	3	1,826
Multiple column filtering faraz316	by Shane Devenshire[_2_]	2	354
SUMIF, IF ? Steve	by Steve	5	358
Using Advanced Filter: How do you MOVE the selected rows... ravif	by Fred Smith[_4_]	3	1,154
How can I get Microsoft excel to calculate increasing number again Anna	by NBVC[_64_]	4	799
Breaking links in Excel brosull	by Shane Devenshire[_2_]	2	418
Help with SUMPRODUCT EricB	by NBVC[_62_]	5	436
Sorting 2 data columns in Pivot Table Alonso[_2_]	by Alonso[_2_]	2	1,898
unable to open protected document I created TBryan	by Harlan Grove[_2_]	2	469
Locking a Spreadsheet but allow inserting Tami	by Tami	5	513
select max value from row of data and column containing max value Jesse	by Shane Devenshire[_2_]	2	1,670
Rolling 12 month total MH	by Lars-Åke Aspelin[_2_]	7	2,003
cell w/ drop down then reference Jackie	by T. Valko	5	447
how do i remove an excel link that break link won't remove brosull	by Shane Devenshire[_2_]	1	2,012
Excel should allow at least 2 vertical and horizontal splits. wmichaux	by Shane Devenshire[_2_]	1	666
Hyperlink to a specific place in a document Al	by Dave Peterson	3	743