Excel Worksheet Functions - Page 60

Thread / Thread Starter	Last Post	Replies	Views
How to use VLookup with a range of numbers? Snake	by Snake	3	1,496
H and V lookup or match? excelrookie	by Bernard Liengme[_2_]	2	690
Sumif for unique values Graham H[_2_]	by T. Valko	10	3,781
Need to copy and match data from one workbook to another workbook clc_80	by David Biddulph[_2_]	1	1,007
Inserting a calculated field in a Pivot Table in Excel 2003 Nadine	by Nadine	1	759
cell selection Mich	by Mike H	1	460
data jocabemx	by jocabemx	0	452
excel 2007 filter 3 text values at the same time from the same co. Ivanka	by Gord Dibben	1	759
Creating macro Jamie	by Gord Dibben	9	571
How to stop time format changing when I merge cell contents? CatKween	by Bernard Liengme[_2_]	3	1,108
Auto fill mikki	by Eduardo	1	354
Style worksheets differently Nadine	by Gord Dibben	2	606
Calculating Time? Trish	by Gary Brown[_6_]	2	453
Explain INDEX MATCH Nadine	by Eduardo	3	1,701
Dynamic Table Problem Jim	by Roger Govier[_8_]	5	629
Sumproduct error Graham H[_3_]	by Graham H[_3_]	2	437
How do I use 'between' 95% and 100% for a nested IF function? Mary S	by Joe User[_2_]	4	803
calculate diffence between old salary and new salary Felicia Pickett	by Billns	4	1,713
Count Unique text in 3 different columns Vitordf	by Herbert Seidenberg	9	1,106
numbers in a column are not sorting ascending slhiaz	by Glenn	2	1,612
How can I allow users to sort a protected table using dropdowns? Stuart Hodge	by Garreth Lombard	1	634
Help with interpolating values Raj[_2_]	by Ron Rosenfeld	4	503
Sum Indirect BNT1 via OfficeKB.com	by Mike H	3	1,554
lookup help. lookup result based on data in 2 columns lcc	by lcc	3	1,295
Formula assistance required J.Scargill[_2_]	by J.Scargill[_2_]	3	485
VLOOKUP not working with data from PeopleSoft Celia[_3_]	by T. Valko	3	1,648
How do I find the minimum value in a range while ignoring zeros? Ted B.	by FSt1	4	1,026
Vlookup formula combining two columns casdaq	by Dave Peterson	1	2,420
Trying to calculate # of times text string is displayed data_entry	by data_entry	0	508
How to consolidate data from different files? Khoshravan	by Khoshravan	2	536
Match Account ID from combining street names and numbers Pierre	by Pierre	1	477
Need help with ISNA, INDEX, MATCH Nadine	by Nadine	2	963
Date Format tvh	by Paul C	2	490
copy excel spread sheet & graph to word doc without formulas tucker	by Nadine	1	882
VLOOKUP & Hyperlinks Dan Cummins	by Dave Peterson	1	1,605
Excel 2007 - Personal Macros Susan	by Otto Moehrbach[_2_]	1	492
don't know what function to use excelrookie	by excelrookie	2	453
Complex If PAL	by Rick Rothstein	6	513
Weeknum formula exalan	by exalan	2	837
Using multiple IF statements KMBOhio	by Joe User[_2_]	1	512
Time difference calculation Sandy	by Sandy	2	1,110
Coloring Elton Law[_2_]	by Jim Thomlinson	2	571
Address of cell in VBA G.P.N.L. c.v.a.	by G.P.N.L. c.v.a.	11	1,092
Formula Assistance - Vlookup Bigfoot17	by Bigfoot17	4	532
Cell selection - turn it off Kris	by Eduardo	1	562
How to combine Combo Box function with Vlookup function KH	by JLatham	2	7,049
WHEN ENTER NUMBER , DISPLAY IN WARDS ? numbers in words	by Stefi	1	916
Automate calculation... XKruodo	by Niek Otten	1	433
function to populate a cell where formula is NOT located Jim	by Bernd P	6	1,248
Countifs for multiple worksheets JodySmithPharmD	by Ashish Mathur[_2_]	4	3,977
Text to Number format Janet	by Ashish Mathur[_2_]	5	612
eliminate duplicates on a sheet C. Brown	by Ashish Mathur[_2_]	3	531
SUMIF returns no value EricB	by Fred Smith[_4_]	2	737
Simple Consolidation of Worksheets nonapp2	by Ashish Mathur[_2_]	2	786
Round formula Khaled[_2_]	by Ashish Mathur[_2_]	5	456
VLOOKUP PAL	by OssieMac	1	433
Multiple IF statment help Mark D[_2_]	by Joe User[_2_]	3	496
total point nordiyu	by JLatham	5	494
Calculations Arul	by Rick Rothstein	1	488
Drop down list Lost Cluster	by Lost Cluster	2	459
Time Functions Caz	by Rick Rothstein	3	538
hiding rows with an if statement Larry Fitch	by Larry Fitch	0	691
referencing in tables Amin	by tompl	1	527
Measure on the date different Sky[_2_]	by Sky[_2_]	4	452
rearranging_names via135 via OfficeKB.com	by via135 via OfficeKB.com	6	491
rearranging_names via135	by via135	10	796
I have a complex formula where I need to build in a MAX function Nicole Schmidt	by Bernd P	4	588
New to VLOOKUP ...merge addresses? JLatham	by JLatham	0	565
Data moving 2 climate	by climate	7	461
Follow up question about consolidating dups and sums TriciaZ	by tompl	11	1,060
MS excell 2007 Data verification list rmar	by Gord Dibben	1	1,403
consolidating duplicate values and summing their corresponding val TriciaZ	by Don Guillett[_2_]	4	1,136
Excell mistake in addition mlv	by Joe User[_2_]	2	479
cell vlue based on cell back colour Esradekan	by David Biddulph[_2_]	7	531
Count dates until complete or Cancel Pat	by Bob Phillips[_4_]	5	576