Excel Worksheet Functions - Page 165

Thread / Thread Starter	Last Post	Replies	Views
Display multiple results based on one cell Cul	by Teethless mama	5	954
cell matching issue totalnatal	by Lars-Åke Aspelin[_2_]	1	355
View sheets (pages) horizontally Herb[_2_]	by Herb[_2_]	3	1,239
SUMPRODUCT Srikanth[_5_]	by Abdul[_2_]	1	388
Linking spreadsheet Saintsman	by Ashish Mathur[_2_]	1	430
Format Number 000000 00000 000000 Abdul[_2_]	by Abdul[_2_]	0	1,273
Highlight the cell based on selected value Max	by Max	2	504
I need a formula......... Keith D.B.	by Keith D.B.	4	493
conditional formatte date in a1 calculate the date in A2 jcurran1ma	by Shane Devenshire[_2_]	3	472
what is the Function for reducing balance depriciation? zamant	by Shane Devenshire[_2_]	1	844
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,442
Please Help - Trouble with counting occurrences in external file dz	by dz	2	418
Relationship between number Damon Cavanagh	by Damon Cavanagh	0	464
Correlation between 2 variables Damon Cavanagh	by Damon Cavanagh	0	557
Moved workbook-File name, minimize, maximize and close are not vis KELC-F/A	by Shane Devenshire[_2_]	2	953
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	524
calculate average from non contiguous column, ignoring (0) values Jesse	by Harlan Grove[_2_]	3	3,246
COUNTIF( {local cells}, {number from other sheet}) ShadoShryke	by Harlan Grove[_2_]	6	636
Need help sorting data Yookaroo	by Yookaroo	4	605
How can I validate my Excel password against a INI file Andrea	by jaf	1	532
MAX IF? Tami	by Ken	5	501
Average while using SumProduct Srikanth[_5_]	by Srikanth[_5_]	0	429
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,758
Function to add 3 column (of YES) to give a total % complete preyesone	by Ken	7	537
Number of Specific Day within Dates Shane Devenshire[_2_]	by Shane Devenshire[_2_]	0	491
Array formulas not working in Excel 2003. kamelone	by Shane Devenshire[_2_]	2	1,786
Combining two functions preyesone	by Ken	13	1,292
Worksheet Limit in Workbook Ron	by Ron	2	428
Number of Specific Day within Dates Teethless mama	by Teethless mama	0	389
Number of Specific Day within Dates Alan McQ via OfficeKB.com	by Alan McQ via OfficeKB.com	0	417
Logical Function excel 2003 Denver	by Shane Devenshire[_2_]	4	446
Help Rum	by Teethless mama	4	590
Index Formula Cow Girl	by Teethless mama	9	499
sum function dannyboy8	by Rick Rothstein	3	372
How to not get '0' or '#DIV/0!' in a cell with a percentage formul Rum	by Jacob Skaria	7	638
How to return a value from another workbook Narnimar	by Jacob Skaria	1	814
Rearreng Manualy in Pivottable LHM	by Roger Govier[_3_]	2	409
How to return a value from another workbook Narnimar	by Narnimar	0	658
countifs JRD	by Shane Devenshire[_2_]	5	932
Conditional format entire column JC	by Shane Devenshire[_2_]	3	582
Weekends JRD	by Shane Devenshire[_2_]	6	540
Average of values that need to be looked up from another sheet NLJR	by Shane Devenshire[_2_]	1	383
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	548
Need help sorting data Yookaroo	by Yookaroo	0	401
vlookup more then 1 match or how do I magicaldean	by Roger Govier[_3_]	1	375
excel hyperlink text to display and vlookup bluker	by bluker	2	1,628
Sum Value of rows based on two common fields jdg	by jdg	5	1,629
How to set formula for poping up the date of next Wednesday.... J	by Mike H	2	1,370
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	990
count formula OKY	by OKY	2	356
How can I group and display columns automatically? faraz316	by Ken	3	2,091
Automatically copy from Master worksheet to others Susan S	by Ashish Mathur[_2_]	5	1,644
Skip Rows in Fill Series and Filter to Two different sheets Benjamin	by Ashish Mathur[_2_]	3	1,851
Multiple column filtering faraz316	by Shane Devenshire[_2_]	2	377
SUMIF, IF ? Steve	by Steve	5	379
Using Advanced Filter: How do you MOVE the selected rows... ravif	by Fred Smith[_4_]	3	1,182
How can I get Microsoft excel to calculate increasing number again Anna	by NBVC[_64_]	4	835
Breaking links in Excel brosull	by Shane Devenshire[_2_]	2	435
Help with SUMPRODUCT EricB	by NBVC[_62_]	5	445
Sorting 2 data columns in Pivot Table Alonso[_2_]	by Alonso[_2_]	2	1,929
unable to open protected document I created TBryan	by Harlan Grove[_2_]	2	495
Locking a Spreadsheet but allow inserting Tami	by Tami	5	555
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,034
cell w/ drop down then reference Jackie	by T. Valko	5	472
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	693
Hyperlink to a specific place in a document Al	by Dave Peterson	3	774