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	391
VBLookup - need help Syed Rizvi	by Syed Rizvi	2	494
Switch lookup function to another sheet New2Macros	by Arvi Laanemets	2	692
Opening multiple templets in two monitors Morgan	by Gord Dibben	3	678
How to get SUMPRODUCT on filtered cells Sam.D[_2_]	by Gary''s Student	1	874
Summarizing with multiple conditions - Formula solution needed Daniel	by Max	2	446
Need Formula to solve my problem romen	by Stefi	1	441
Excel date intervals look up adam smith	by Jacob Skaria	1	737
Find value in a Range of Cells and perform Conditional Formatting Kamlesh	by Kamlesh	6	678
USING "IF" STATEMENTS FOR MONTHS OF YEAR(IF 1=JANUARY) Tina	by Rick Rothstein	6	4,927
Excel 2002 always rounds up automatically Kent	by Kent	3	582
Sum J Walia	by Jacob Skaria	2	489
Deleting worksheets in a macro Donna[_2_]	by Jacob Skaria	2	631
help with Conditional formatting pairs of cells Parish Pete	by Ando	1	612
Date Functions & Formatting goskerz	by Ron Rosenfeld	9	502
Vlookup, sumproduct, if, sumif... erggg! Serendipity	by Don Guillett[_2_]	1	605
Import external data into Excel 2007 so I can subtotal it Denise	by Ashish Mathur[_2_]	2	3,018
How to add time from multiple cells & date Cells & machine type c Peter Gonzalez[_2_]	by Ashish Mathur[_2_]	3	1,337
NEED FORMULA HELP brushtec	by Lars-Åke Aspelin[_2_]	1	419
Function for odd even numbers petedacook	by Rick Rothstein	4	2,128
Max number of consectutive blanks in a range Steve	by T. Valko	7	623
reference sheet number not name Al	by Gary''s Student	1	3,136
Calculated Item in Pivot table Yogesh Gupta	by Debra Dalgleish	1	1,273
Calculate total metric based on sum of metric over specific time f StaceyB	by Bernard Liengme[_2_]	1	705
I have a file that is 4mb. Cleared all formating...still big JDH	by Gord Dibben	4	686
Why doesn't "Replace" function find value I know exists? UHAAdminAsst	by Gord Dibben	4	1,569
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,344
SEARCH DaveMoore	by Don Guillett[_2_]	1	351
Find last cell in a column, Delete its contents and make it active George	by Don Guillett[_2_]	5	559
Find last cell in a column, Delete its contents and make it ac Don Guillett[_2_]	by George	1	642
Usage of Data Validation with If Condition Mujeeb ur Rehman, FBL-GRW-PK	by Ashish Mathur[_2_]	4	1,651
Use if functions with dates glitterbug99	by Dave Peterson	1	511
Pivot Table Fields not showing Fritz	by Roger Govier[_3_]	2	6,361
How do I reference a worksheet name through a formula? pv6901	by Mike H	3	439
protect cells in excel, but also allow a search in those cells? LindaAlex	by LindaAlex	2	671
Can I invert a matrix in Excel 2007? Roger Hn	by Dave Peterson	2	2,128
formatting excel date list rslc[_3_]	by Pete_UK	5	544
Need help to change a cell color based on conditions Ken	by shail	1	560
Creating Visual Excel Cell Alerts alchemist	by CellShocked	5	905
cannot change datasource of pivotchart Nikki	by Nikki	0	857
Preventing double entry formula Yoli	by Ashish Mathur[_2_]	4	963
Assigning a macro to a button hberg	by Chip Pearson	1	514
HOW CAN I IMPLEMENT SUMIF(D1:D6,"AVERAGE(D1:D6)") Bill Friedman	by bapeltzer	1	404
Time Calculation and formulas needed (2 questions) --Viewpoint	by Teethless mama	1	592
Combo List in Excel Renee	by Gord Dibben	1	637
Summing Data rfhorn	by rfhorn	3	465
MATCH search with text and numbers Patryk	by Teethless mama	1	476
Error message needed if incorrect Date Of Birth (DOB) entered Craig	by Craig	5	791
exclude certain cells from series fill Doug	by Gord Dibben	1	844
remove contain from rows B thur J bill boch	by Eduardo	2	447
bitwise functions vbano	by Joe User[_2_]	3	4,783
if & And condition shajizz[_3_]	by shajizz[_4_]	3	527
command to move to different sheet hberg	by Eduardo	1	667
FIND text within text then sum Dhazmo	by Dhazmo	4	648
LOOKUP problem Lisa Cowan	by Eduardo	8	476
Auto Calculate Monthly Time Pace HeatherJ	by Eduardo	2	963
Reversing a column Don Kline[_2_]	by Don Kline[_2_]	2	370
how do I sumif on a font color in excel 2007? edk	by Teethless mama	1	1,965
Conditional formatting based upon due dates Tracey G	by Jacob Skaria	2	5,028
Matching data in 2 different work sheets Curtis	by Eduardo	3	674
sumif to aggregate month to quarter renegade	by Stefi	16	3,101
Copying a cell if dates match glitterbug99	by Jacob Skaria	2	531
automatic insertion of row renegade	by renegade	3	546
SUM Fuction Suzan Boyle	by Jacob Skaria	2	434
Month wise Sum hsg	by Jacob Skaria	4	1,252
countif with time NEHicks	by Chelsea[_2_]	3	498
some kind of Conditional format? - Baffled :( Dave[_13_]	by &rew	5	405
COUNTIF with adjacent columns Custard Tart	by Ashish Mathur[_2_]	4	1,186
time delay refresh on random number Bertrand[_2_]	by Bernie Deitrick	2	1,297
repeatedly extract a field to create a new list in another file? nut behind the computer	by Bernie Deitrick	1	418
vlookup jude	by jude	3	459
Spreadsheet - Deleting Duplicate Records - Self Checking APV-onlyownerknowinganyIT	by Max	1	477
Limitations on Sumif Calculation TaraD[_2_]	by T. Valko	3	6,060
Is it possible to count the no. of characters in a cell in Excel? karbrown12	by Teethless mama	2	453
Conditional Formula Help Please! CharlieGirl	by CLR	4	410