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,486
H and V lookup or match? excelrookie	by Bernard Liengme[_2_]	2	684
Sumif for unique values Graham H[_2_]	by T. Valko	10	3,719
Need to copy and match data from one workbook to another workbook clc_80	by David Biddulph[_2_]	1	952
Inserting a calculated field in a Pivot Table in Excel 2003 Nadine	by Nadine	1	751
cell selection Mich	by Mike H	1	450
data jocabemx	by jocabemx	0	451
excel 2007 filter 3 text values at the same time from the same co. Ivanka	by Gord Dibben	1	756
Creating macro Jamie	by Gord Dibben	9	561
How to stop time format changing when I merge cell contents? CatKween	by Bernard Liengme[_2_]	3	1,096
Auto fill mikki	by Eduardo	1	341
Style worksheets differently Nadine	by Gord Dibben	2	590
Calculating Time? Trish	by Gary Brown[_6_]	2	418
Explain INDEX MATCH Nadine	by Eduardo	3	1,694
Dynamic Table Problem Jim	by Roger Govier[_8_]	5	615
Sumproduct error Graham H[_3_]	by Graham H[_3_]	2	429
How do I use 'between' 95% and 100% for a nested IF function? Mary S	by Joe User[_2_]	4	789
calculate diffence between old salary and new salary Felicia Pickett	by Billns	4	1,693
Count Unique text in 3 different columns Vitordf	by Herbert Seidenberg	9	1,091
numbers in a column are not sorting ascending slhiaz	by Glenn	2	1,587
How can I allow users to sort a protected table using dropdowns? Stuart Hodge	by Garreth Lombard	1	626
Help with interpolating values Raj[_2_]	by Ron Rosenfeld	4	495
Sum Indirect BNT1 via OfficeKB.com	by Mike H	3	1,543
lookup help. lookup result based on data in 2 columns lcc	by lcc	3	1,234
Formula assistance required J.Scargill[_2_]	by J.Scargill[_2_]	3	475
VLOOKUP not working with data from PeopleSoft Celia[_3_]	by T. Valko	3	1,635
How do I find the minimum value in a range while ignoring zeros? Ted B.	by FSt1	4	1,018
Vlookup formula combining two columns casdaq	by Dave Peterson	1	2,414
Trying to calculate # of times text string is displayed data_entry	by data_entry	0	494
How to consolidate data from different files? Khoshravan	by Khoshravan	2	528
Match Account ID from combining street names and numbers Pierre	by Pierre	1	471
Need help with ISNA, INDEX, MATCH Nadine	by Nadine	2	949
Date Format tvh	by Paul C	2	483
copy excel spread sheet & graph to word doc without formulas tucker	by Nadine	1	862
VLOOKUP & Hyperlinks Dan Cummins	by Dave Peterson	1	1,601
Excel 2007 - Personal Macros Susan	by Otto Moehrbach[_2_]	1	474
don't know what function to use excelrookie	by excelrookie	2	443
Complex If PAL	by Rick Rothstein	6	509
Weeknum formula exalan	by exalan	2	832
Using multiple IF statements KMBOhio	by Joe User[_2_]	1	504
Time difference calculation Sandy	by Sandy	2	1,104
Coloring Elton Law[_2_]	by Jim Thomlinson	2	560
Address of cell in VBA G.P.N.L. c.v.a.	by G.P.N.L. c.v.a.	11	1,075
Formula Assistance - Vlookup Bigfoot17	by Bigfoot17	4	519
Cell selection - turn it off Kris	by Eduardo	1	552
How to combine Combo Box function with Vlookup function KH	by JLatham	2	6,986
WHEN ENTER NUMBER , DISPLAY IN WARDS ? numbers in words	by Stefi	1	895
Automate calculation... XKruodo	by Niek Otten	1	430
function to populate a cell where formula is NOT located Jim	by Bernd P	6	1,228
Countifs for multiple worksheets JodySmithPharmD	by Ashish Mathur[_2_]	4	3,938
Text to Number format Janet	by Ashish Mathur[_2_]	5	603
eliminate duplicates on a sheet C. Brown	by Ashish Mathur[_2_]	3	518
SUMIF returns no value EricB	by Fred Smith[_4_]	2	736
Simple Consolidation of Worksheets nonapp2	by Ashish Mathur[_2_]	2	772
Round formula Khaled[_2_]	by Ashish Mathur[_2_]	5	451
VLOOKUP PAL	by OssieMac	1	427
Multiple IF statment help Mark D[_2_]	by Joe User[_2_]	3	489
total point nordiyu	by JLatham	5	483
Calculations Arul	by Rick Rothstein	1	482
Drop down list Lost Cluster	by Lost Cluster	2	451
Time Functions Caz	by Rick Rothstein	3	532
hiding rows with an if statement Larry Fitch	by Larry Fitch	0	676
referencing in tables Amin	by tompl	1	518
Measure on the date different Sky[_2_]	by Sky[_2_]	4	447
rearranging_names via135 via OfficeKB.com	by via135 via OfficeKB.com	6	481
rearranging_names via135	by via135	10	779
I have a complex formula where I need to build in a MAX function Nicole Schmidt	by Bernd P	4	579
New to VLOOKUP ...merge addresses? JLatham	by JLatham	0	560
Data moving 2 climate	by climate	7	458
Follow up question about consolidating dups and sums TriciaZ	by tompl	11	1,049
MS excell 2007 Data verification list rmar	by Gord Dibben	1	1,388
consolidating duplicate values and summing their corresponding val TriciaZ	by Don Guillett[_2_]	4	1,129
Excell mistake in addition mlv	by Joe User[_2_]	2	470
cell vlue based on cell back colour Esradekan	by David Biddulph[_2_]	7	518
Count dates until complete or Cancel Pat	by Bob Phillips[_4_]	5	572