Excel Worksheet Functions - Page 865

Thread / Thread Starter	Last Post	Replies	Views
how to activate controls in protected sheet Novice	by Novice	2	3,889
Is there an AVERAGEIF function similar to COUNTIF - how do I do i. John Emhof	by John Emhof	3	640
Autofill cels based on two dates in adjacent cels William2	by William2	3	710
Compare multiple column of data and list out common and unique component in adj columns kuansheng	by Max	15	2,264
Removing unwanted rows sroe9738	by sroe9738	0	659
re-produce/loate auto filter list Sin	by Debra Dalgleish	2	547
color of filter arrows Tanguy Huysmans	by Debra Dalgleish	1	598
Data Validation ArthurJ	by Debra Dalgleish	4	455
Text and Function Formulas HRMSN	by SVC	2	472
HOW CAN I RECOVER MY OVERWRITTEN DOCUMENT? SAVED MISTAKE	by Harlan Grove	2	1,012
I used Lotus Help for regressions in MS Excel 99. Now what? Hawkeye	by Jerry W. Lewis	1	425
problem with macro on Excel Captain Picard	by Captain Picard	0	361
Please Help! - Need Help pulling data from one spreadsheet to anot dhwinters	by dhwinters	1	682
How can I copy text from one worksheet to another Kendra	by Kendra	7	845
Time function L_n_da	by Dave Peterson	1	486
calculate percent met (comparing 2 date columns) Cobra	by Cobra	2	641
copying specific data from 1 wrksht to another flrty	by Pete	1	469
Need help with formula to give 0 if value is negative or answer is Sharona77	by Sharona77	0	593
Autofilter SORT that Ignores Forced Blanks ("") bryhogan	by Pete	7	861
Forecasting KrunoG	by KrunoG	0	807
How do I find the last instance of data in a column IJ Rosenblum	by Biff	1	691
Modifying an If Statement carl	by Bob Phillips	1	459
Vlookup problem Graham Haughs	by CLR	3	585
Querying a range within Excel David Wright	by David Wright	0	685
why doesn't sort work when it's choosen before protecting sheet Mearll	by Ron de Bruin	1	734
INFORMATION ON FUNCTIONS IN EXCEL (EX. "IF", VALUE LOOKUP) skye1971	by Ron de Bruin	1	561
Count Occurrences and Print Total Lilbit	by Lilbit	3	471
How can I view color coordinated formulas M&A_Jack	by vezerid	1	406
How can I set up week to date report? Liz	by Liz	0	435
COUNTIF according to presence of string within text Ingeniero1	by Ingeniero1	5	1,206
isnumber multiple criteria. cbanks	by Bob Phillips	2	2,158
Convert text string to date AK	by David Billigmeier	1	605
How do I advance filter to multiple locations at once? imills	by Ron de Bruin	3	1,065
Random Number generator Neil M	by [email protected]	2	1,083
How do you convert an entire column into absolute value? Lorraine	by Gary''s Student	1	6,075
Double lookup formula Steve	by Kevin Vaughn	4	625
"New Web Query" always refreshes data from website (3 times) Matt Suppa	by [email protected]	1	471
how do I count with multiple arguments Chris G	by Bob Phillips	1	770
Tabbing to the next cell katlane	by katlane	2	438
highlighting duplicates alex	by alex	2	541
Combining 2 or more worksheets Steve Lewington	by KemS	3	605
paste special - formulas bjw10	by bjw10	6	830
help with a table TAZGALSINH	by Jim Cone	1	321
Nested function - what key strokes to save and return a value? beancounter	by beancounter	0	671
How to format a number cell to auto count 1 up on file open Joevee	by Joevee	0	514
Ranking based on frequency mac_see	by mac_see	2	546
Conditional DAY [email protected]	by [email protected]	4	517
Pivot Table/Report in Shared workbooks PSikes	by PSikes	1	1,173
Macro code error; machine dependent SJC	by SJC	4	958
Protest sheet but allow sort Pete Walburn	by REVA	4	401
Setting borders for two rows and all columns on spread sheet R OLEJAR	by R OLEJAR	0	573
Dsum will not work DEI	by Ron Coderre	1	382
special formatting adds extra zeroes nosnil14	by nosnil14	0	611
Macro to highlight cells based on content JimDerDog	by vezerid	1	1,898
3D Interpolation EStewart	by EStewart	0	2,265
PivotTable - Calculated Field Matt M HMS	by Matt M HMS	0	532
IF Function Alma	by Alma	6	334
Text string inverting cagolden2003	by Gerrit-Jan Linker	3	387
Display worksheet protection status in a cell? Geoff C	by Geoff C	2	743
I need a Lookup to return more than 1 result joe1182	by vezerid	8	613
Adding hours minutes and seconds WannaChevy03	by WannaChevy03	5	887
Copying a worksheet witrh protected cells to a new worksheet John	by John	2	1,422
workbook1 data to workbook2 data raisin	by CLR	1	358
Postman kuansheng	by Max	1	330
Using INDEX and MATCH to find data in 2 different sheets RMF	by Domenic	5	1,770
EC Excel User Conference This week registration giveaway Damon Longworth	by Damon Longworth	0	870
quirky array not working BorisS	by Bob Phillips	3	534
Adding months to dates should account for 28-30-31 day months Graham	by Ron Rosenfeld	3	999
How do I get a count of dates within a range..? cmharri123	by Bruno Campanini	2	342
Sumproduct question RJS76 via OfficeKB.com	by RJS76 via OfficeKB.com	5	458
Web scraping mickbarry	by [email protected]	2	668
If Function - Multiple Arguements? andyp161	by Arvi Laanemets	4	356
Elements and Arrays in Excel Lighthouseman	by NES	6	736
Conditional Format - Outline Border Drahos	by Drahos	2	980
how to put the subtotal of the sum and count in one spreadhseet? SM	by Bob Phillips	1	490