Excel Worksheet Functions - Page 341

Thread / Thread Starter	Last Post	Replies	Views
Find matching values in two different columns lmarstin	by T. Valko	5	6,204
Validation function with helper column XKruodo	by XKruodo	0	419
Count IF Romanli	by Dave Peterson	6	366
If statements looking for nonblank cells Mok721	by T. Valko	1	403
Dynamic Scatter Charts Neweirs	by Neweirs	0	407
Excel 2007 Conditional Formatting only copies absolute Rob	by Spiky	3	1,617
Sort Chart Values Alex	by Alex	0	818
Average time bpc	by Lars-Åke Aspelin[_2_]	15	1,390
How can I choose more than one item from list in a form in Excel? Jolly	by Rick Rothstein \(MVP - VB\)[_909_]	7	869
Counting data in a range Glenn L.	by T. Valko	7	577
PERCENTILE exceeding 8191 points mtrain32000	by Bernard Liengme	1	821
Sum of continous cell Man	by T. Valko	3	437
INDIRECT INDIRECT	by Harlan Grove[_2_]	6	498
edit data in multiple cells Ask MS[_2_]	by Jarek Kujawa[_2_]	5	645
Duplicate ramdom sampling Lee Mathew	by Lee Mathew	2	301
controlling pivot table mrc1986 via OfficeKB.com	by mrc1986 via OfficeKB.com	0	368
Pivot Chart Formating bayo2008	by Debra Dalgleish	1	361
Subtotalling taking long time to complete AndyV	by AndyV	4	6,838
vlookup not returning a match even when there is one karen	by karen	6	1,784
circular reference where sumif and vlookup overlap mining north	by John C[_2_]	9	974
how to change font in form contollers Steven Jones	by Max	2	500
Peak call times/hours Ber	by Ber	2	889
Selecting cells with the mouse Mark	by Mark	0	421
clear cell based on text in opposing column [email protected]	by [email protected]	2	506
Flying Hours Loadmaster	by Ron Rosenfeld	5	421
Link transposed data from one sheet to another for DB purposes Tina	by YMTEO	16	984
Extact minutes from text field? Lenchik	by Lenchik	4	524
Lock or Unlock Range of Cells on Worksheet_Change Event Grahame Coyle	by Grahame Coyle	3	2,900
VLookup in a form [email protected]	by NoodNutt	1	403
Weekly Totals Based on Dates JerryS	by Ed Ferrero[_2_]	1	353
Return to a default state??? lost and confused in excel-land[_2_]	by NoodNutt	1	407
Can I Use A Count If Function With A Forward Slash? mommy2kh	by T. Valko	8	3,851
how to have auto calc cells be blank unless entry made miss sass	by daddylonglegs	2	1,716
how to convert number to words Nikhil Jain	by Nikhil Jain[_2_]	3	943
Auto populate a cell by comparing lists Ken[_2_]	by Ken[_2_]	2	571
Replacing Part of a Cell's Content mommy2kh	by daddylonglegs	5	736
<= Formula ? AJ	by daddylonglegs	6	401
sum between a range of dates H. Nissen[_2_]	by H. Nissen[_2_]	2	570
date problem or is it me? zekni	by zekni	3	383
Ranking Fuzzy	by Fuzzy	2	385
Populate cell range lost and confused in excel-land[_2_]	by lost and confused in excel-land[_2_]	1	501
insert column header in cell below result of max FUNCTION mark s	by T. Valko	2	536
conditional formatting or VB Brian	by Dave Peterson	3	374
Excell Formula KW2K	by Max	5	596
Excel Loan Repayment Schedule template. stevegg	by ryguy7272	3	6,112
Hiding blank cells within a Pivot Table Shams	by ryguy7272	1	1,422
sumif < date David	by Rick Rothstein \(MVP - VB\)[_888_]	5	567
spreadsheet to keep track of phone numbers Eamon	by recrit	1	385
keep old cell value and new cell value bebazza	by Otto Moehrbach[_2_]	2	440
If statements in Data Validation lost and confused in excel-land[_2_]	by T. Valko	7	1,049
Calculating values based on selection from a drop-down list in Exc Razzamatazz	by Gord Dibben	3	1,006
Finding quantity that falls within a range or Tier Mimi	by Ron Rosenfeld	3	717
Count Non-Blank Values in a Table but only for a range GCRDelphi	by Pete_UK	3	503
test Eamon	by Eamon	0	366
Test_12_07_08 Eamon	by Eamon	0	300
vlookup refering to a cell to get wookbook name Jonathan	by Bob Phillips	1	393
Compare and get the best value Satya Nanduri[_2_]	by Satya Nanduri[_2_]	2	393
Comparing Addresses from 2 different Worksheets AAH	by Max	7	499
Multiple calculations within cell? Writing in Excel 2000, using inExcel 2003 robzrob	by John C[_2_]	6	912
Tying names to different values month to month. rzimmerman22	by rzimmerman22	0	368
Copy Info from 1 sheet to another within same workbook Julie	by Gord Dibben	1	507
want to automatically skip certain cells when you hit enter Deedarling1960	by Gord Dibben	2	1,166
Printing Dave	by Gord Dibben	2	334
Data Validation and combination UTResearchAnalyst	by Gord Dibben	3	517
Filtering [email protected]	by Gord Dibben	1	279
Average of Day and Time Jarod	by Bob Phillips[_3_]	3	863
sumif or if or something else???? durrienz	by durrienz	2	332
multiple IF formulas JayDee	by T. Valko	8	364
FONT COLOUR CHANGE natasha90	by Jan Bolluyt	3	479
Multiple pie charts in one printout? Researcher08	by Researcher08	0	573
CONCATENATE within SUMPRODUCT Icarus	by PCLIVE	14	6,418
Already exists on the destination workbook ChrisP	by Dave Peterson	3	4,047
Table help K	by K	0	369
Formulas that refer to a cell in the last row JBoyer	by JBoyer	3	430
Quday001-Conditional Formatting Udayan	by Pete_UK	1	263