Excel Worksheet Functions - Page 85

Thread / Thread Starter	Last Post	Replies	Views
difference of 2 cells from 2 sheets to appear on sheet 3? wzkm123	by trip_to_tokyo[_3_]	2	377
VBLookup - need help Syed Rizvi	by Syed Rizvi	2	473
Switch lookup function to another sheet New2Macros	by Arvi Laanemets	2	669
Opening multiple templets in two monitors Morgan	by Gord Dibben	3	649
How to get SUMPRODUCT on filtered cells Sam.D[_2_]	by Gary''s Student	1	863
Summarizing with multiple conditions - Formula solution needed Daniel	by Max	2	418
Need Formula to solve my problem romen	by Stefi	1	425
Excel date intervals look up adam smith	by Jacob Skaria	1	709
Find value in a Range of Cells and perform Conditional Formatting Kamlesh	by Kamlesh	6	656
USING "IF" STATEMENTS FOR MONTHS OF YEAR(IF 1=JANUARY) Tina	by Rick Rothstein	6	4,808
Excel 2002 always rounds up automatically Kent	by Kent	3	556
Sum J Walia	by Jacob Skaria	2	468
Deleting worksheets in a macro Donna[_2_]	by Jacob Skaria	2	604
help with Conditional formatting pairs of cells Parish Pete	by Ando	1	581
Date Functions & Formatting goskerz	by Ron Rosenfeld	9	485
Vlookup, sumproduct, if, sumif... erggg! Serendipity	by Don Guillett[_2_]	1	583
Import external data into Excel 2007 so I can subtotal it Denise	by Ashish Mathur[_2_]	2	2,993
How to add time from multiple cells & date Cells & machine type c Peter Gonzalez[_2_]	by Ashish Mathur[_2_]	3	1,316
NEED FORMULA HELP brushtec	by Lars-Åke Aspelin[_2_]	1	394
Function for odd even numbers petedacook	by Rick Rothstein	4	2,056
Max number of consectutive blanks in a range Steve	by T. Valko	7	604
reference sheet number not name Al	by Gary''s Student	1	3,116
Calculated Item in Pivot table Yogesh Gupta	by Debra Dalgleish	1	1,243
Calculate total metric based on sum of metric over specific time f StaceyB	by Bernard Liengme[_2_]	1	692
I have a file that is 4mb. Cleared all formating...still big JDH	by Gord Dibben	4	676
Why doesn't "Replace" function find value I know exists? UHAAdminAsst	by Gord Dibben	4	1,551
move a row of data from one work sheet to another using a formula Need formula help, Excel 2007, Thanks	by Don Guillett[_2_]	1	1,320
SEARCH DaveMoore	by Don Guillett[_2_]	1	344
Find last cell in a column, Delete its contents and make it active George	by Don Guillett[_2_]	5	534
Find last cell in a column, Delete its contents and make it ac Don Guillett[_2_]	by George	1	625
Usage of Data Validation with If Condition Mujeeb ur Rehman, FBL-GRW-PK	by Ashish Mathur[_2_]	4	1,609
Use if functions with dates glitterbug99	by Dave Peterson	1	497
Pivot Table Fields not showing Fritz	by Roger Govier[_3_]	2	6,335
How do I reference a worksheet name through a formula? pv6901	by Mike H	3	417
protect cells in excel, but also allow a search in those cells? LindaAlex	by LindaAlex	2	630
Can I invert a matrix in Excel 2007? Roger Hn	by Dave Peterson	2	2,105
formatting excel date list rslc[_3_]	by Pete_UK	5	510
Need help to change a cell color based on conditions Ken	by shail	1	536
Creating Visual Excel Cell Alerts alchemist	by CellShocked	5	877
cannot change datasource of pivotchart Nikki	by Nikki	0	837
Preventing double entry formula Yoli	by Ashish Mathur[_2_]	4	947
Assigning a macro to a button hberg	by Chip Pearson	1	474
HOW CAN I IMPLEMENT SUMIF(D1:D6,"AVERAGE(D1:D6)") Bill Friedman	by bapeltzer	1	377
Time Calculation and formulas needed (2 questions) --Viewpoint	by Teethless mama	1	566
Combo List in Excel Renee	by Gord Dibben	1	609
Summing Data rfhorn	by rfhorn	3	396
MATCH search with text and numbers Patryk	by Teethless mama	1	435
Error message needed if incorrect Date Of Birth (DOB) entered Craig	by Craig	5	760
exclude certain cells from series fill Doug	by Gord Dibben	1	823
remove contain from rows B thur J bill boch	by Eduardo	2	434
bitwise functions vbano	by Joe User[_2_]	3	4,746
if & And condition shajizz[_3_]	by shajizz[_4_]	3	499
command to move to different sheet hberg	by Eduardo	1	636
FIND text within text then sum Dhazmo	by Dhazmo	4	628
LOOKUP problem Lisa Cowan	by Eduardo	8	458
Auto Calculate Monthly Time Pace HeatherJ	by Eduardo	2	944
Reversing a column Don Kline[_2_]	by Don Kline[_2_]	2	350
how do I sumif on a font color in excel 2007? edk	by Teethless mama	1	1,937
Conditional formatting based upon due dates Tracey G	by Jacob Skaria	2	4,986
Matching data in 2 different work sheets Curtis	by Eduardo	3	643
sumif to aggregate month to quarter renegade	by Stefi	16	3,074
Copying a cell if dates match glitterbug99	by Jacob Skaria	2	504
automatic insertion of row renegade	by renegade	3	520
SUM Fuction Suzan Boyle	by Jacob Skaria	2	410
Month wise Sum hsg	by Jacob Skaria	4	1,238
countif with time NEHicks	by Chelsea[_2_]	3	485
some kind of Conditional format? - Baffled :( Dave[_13_]	by &rew	5	379
COUNTIF with adjacent columns Custard Tart	by Ashish Mathur[_2_]	4	1,161
time delay refresh on random number Bertrand[_2_]	by Bernie Deitrick	2	1,269
repeatedly extract a field to create a new list in another file? nut behind the computer	by Bernie Deitrick	1	397
vlookup jude	by jude	3	445
Spreadsheet - Deleting Duplicate Records - Self Checking APV-onlyownerknowinganyIT	by Max	1	446
Limitations on Sumif Calculation TaraD[_2_]	by T. Valko	3	6,000
Is it possible to count the no. of characters in a cell in Excel? karbrown12	by Teethless mama	2	425
Conditional Formula Help Please! CharlieGirl	by CLR	4	383