Excel Worksheet Functions - Page 165

Thread / Thread Starter	Last Post	Replies	Views
Display multiple results based on one cell Cul	by Teethless mama	5	936
cell matching issue totalnatal	by Lars-Åke Aspelin[_2_]	1	341
View sheets (pages) horizontally Herb[_2_]	by Herb[_2_]	3	1,226
SUMPRODUCT Srikanth[_5_]	by Abdul[_2_]	1	375
Linking spreadsheet Saintsman	by Ashish Mathur[_2_]	1	418
Format Number 000000 00000 000000 Abdul[_2_]	by Abdul[_2_]	0	1,239
Highlight the cell based on selected value Max	by Max	2	476
I need a formula......... Keith D.B.	by Keith D.B.	4	485
conditional formatte date in a1 calculate the date in A2 jcurran1ma	by Shane Devenshire[_2_]	3	455
what is the Function for reducing balance depriciation? zamant	by Shane Devenshire[_2_]	1	824
sumif? Scott A[_2_]	by Shane Devenshire[_2_]	3	490
New 2007 Sumifs formula - is there a new multiple criteria vlookup westy	by Shane Devenshire[_2_]	2	1,426
Please Help - Trouble with counting occurrences in external file dz	by dz	2	396
Relationship between number Damon Cavanagh	by Damon Cavanagh	0	450
Correlation between 2 variables Damon Cavanagh	by Damon Cavanagh	0	537
Moved workbook-File name, minimize, maximize and close are not vis KELC-F/A	by Shane Devenshire[_2_]	2	938
how do you have 2 criterias be picked up in a lookup? N. Vu	by Shane Devenshire[_2_]	5	559
Excel - text in one cell oMaLLey	by Gord Dibben	2	504
calculate average from non contiguous column, ignoring (0) values Jesse	by Harlan Grove[_2_]	3	3,182
COUNTIF( {local cells}, {number from other sheet}) ShadoShryke	by Harlan Grove[_2_]	6	616
Need help sorting data Yookaroo	by Yookaroo	4	574
How can I validate my Excel password against a INI file Andrea	by jaf	1	512
MAX IF? Tami	by Ken	5	484
Average while using SumProduct Srikanth[_5_]	by Srikanth[_5_]	0	411
Trying to make averages AND sums of one spreadsheet of information E[_2_]	by E[_2_]	0	470
Combining 2 percentages into one cell and displaying as % format RLind	by Shane Devenshire[_2_]	5	2,713
Function to add 3 column (of YES) to give a total % complete preyesone	by Ken	7	520
Number of Specific Day within Dates Shane Devenshire[_2_]	by Shane Devenshire[_2_]	0	477
Array formulas not working in Excel 2003. kamelone	by Shane Devenshire[_2_]	2	1,767
Combining two functions preyesone	by Ken	13	1,270
Worksheet Limit in Workbook Ron	by Ron	2	407
Number of Specific Day within Dates Teethless mama	by Teethless mama	0	373
Number of Specific Day within Dates Alan McQ via OfficeKB.com	by Alan McQ via OfficeKB.com	0	392
Logical Function excel 2003 Denver	by Shane Devenshire[_2_]	4	434
Help Rum	by Teethless mama	4	572
Index Formula Cow Girl	by Teethless mama	9	489
sum function dannyboy8	by Rick Rothstein	3	358
How to not get '0' or '#DIV/0!' in a cell with a percentage formul Rum	by Jacob Skaria	7	627
How to return a value from another workbook Narnimar	by Jacob Skaria	1	796
Rearreng Manualy in Pivottable LHM	by Roger Govier[_3_]	2	402
How to return a value from another workbook Narnimar	by Narnimar	0	643
countifs JRD	by Shane Devenshire[_2_]	5	924
Conditional format entire column JC	by Shane Devenshire[_2_]	3	561
Weekends JRD	by Shane Devenshire[_2_]	6	515
Average of values that need to be looked up from another sheet NLJR	by Shane Devenshire[_2_]	1	368
Make them work on the Each cell Value Steved	by T. Valko	7	460
How can i set a formula which shows 2nd last Monday of the month? J	by Teethless mama	5	791
Conditional formatting dates? ReapeR	by Fred Smith[_4_]	8	522
Need help sorting data Yookaroo	by Yookaroo	0	384
vlookup more then 1 match or how do I magicaldean	by Roger Govier[_3_]	1	353
excel hyperlink text to display and vlookup bluker	by bluker	2	1,606
Sum Value of rows based on two common fields jdg	by jdg	5	1,609
How to set formula for poping up the date of next Wednesday.... J	by Mike H	2	1,341
Assist with formula Soth	by Soth	3	412
Conditional Sum in Array with wild card and between dates Hank01061567	by Hank01061567	3	1,066
Need help displaying odd numbered month Greg L[_3_]	by Sheeloo	3	971
count formula OKY	by OKY	2	350
How can I group and display columns automatically? faraz316	by Ken	3	2,069
Automatically copy from Master worksheet to others Susan S	by Ashish Mathur[_2_]	5	1,581
Skip Rows in Fill Series and Filter to Two different sheets Benjamin	by Ashish Mathur[_2_]	3	1,830
Multiple column filtering faraz316	by Shane Devenshire[_2_]	2	369
SUMIF, IF ? Steve	by Steve	5	363
Using Advanced Filter: How do you MOVE the selected rows... ravif	by Fred Smith[_4_]	3	1,161
How can I get Microsoft excel to calculate increasing number again Anna	by NBVC[_64_]	4	808
Breaking links in Excel brosull	by Shane Devenshire[_2_]	2	424
Help with SUMPRODUCT EricB	by NBVC[_62_]	5	436
Sorting 2 data columns in Pivot Table Alonso[_2_]	by Alonso[_2_]	2	1,903
unable to open protected document I created TBryan	by Harlan Grove[_2_]	2	472
Locking a Spreadsheet but allow inserting Tami	by Tami	5	530
select max value from row of data and column containing max value Jesse	by Shane Devenshire[_2_]	2	1,761
Rolling 12 month total MH	by Lars-Åke Aspelin[_2_]	7	2,017
cell w/ drop down then reference Jackie	by T. Valko	5	452
how do i remove an excel link that break link won't remove brosull	by Shane Devenshire[_2_]	1	2,017
Excel should allow at least 2 vertical and horizontal splits. wmichaux	by Shane Devenshire[_2_]	1	672
Hyperlink to a specific place in a document Al	by Dave Peterson	3	744