Excel Worksheet Functions - Page 865

Thread / Thread Starter	Last Post	Replies	Views
how to activate controls in protected sheet Novice	by Novice	2	3,850
Is there an AVERAGEIF function similar to COUNTIF - how do I do i. John Emhof	by John Emhof	3	628
Autofill cels based on two dates in adjacent cels William2	by William2	3	692
Compare multiple column of data and list out common and unique component in adj columns kuansheng	by Max	15	2,225
Removing unwanted rows sroe9738	by sroe9738	0	604
re-produce/loate auto filter list Sin	by Debra Dalgleish	2	530
color of filter arrows Tanguy Huysmans	by Debra Dalgleish	1	580
Data Validation ArthurJ	by Debra Dalgleish	4	426
Text and Function Formulas HRMSN	by SVC	2	458
HOW CAN I RECOVER MY OVERWRITTEN DOCUMENT? SAVED MISTAKE	by Harlan Grove	2	985
I used Lotus Help for regressions in MS Excel 99. Now what? Hawkeye	by Jerry W. Lewis	1	413
problem with macro on Excel Captain Picard	by Captain Picard	0	339
Please Help! - Need Help pulling data from one spreadsheet to anot dhwinters	by dhwinters	1	663
How can I copy text from one worksheet to another Kendra	by Kendra	7	829
Time function L_n_da	by Dave Peterson	1	473
calculate percent met (comparing 2 date columns) Cobra	by Cobra	2	620
copying specific data from 1 wrksht to another flrty	by Pete	1	447
Need help with formula to give 0 if value is negative or answer is Sharona77	by Sharona77	0	577
Autofilter SORT that Ignores Forced Blanks ("") bryhogan	by Pete	7	851
Forecasting KrunoG	by KrunoG	0	791
How do I find the last instance of data in a column IJ Rosenblum	by Biff	1	666
Modifying an If Statement carl	by Bob Phillips	1	438
Vlookup problem Graham Haughs	by CLR	3	560
Querying a range within Excel David Wright	by David Wright	0	650
why doesn't sort work when it's choosen before protecting sheet Mearll	by Ron de Bruin	1	718
INFORMATION ON FUNCTIONS IN EXCEL (EX. "IF", VALUE LOOKUP) skye1971	by Ron de Bruin	1	536
Count Occurrences and Print Total Lilbit	by Lilbit	3	450
How can I view color coordinated formulas M&A_Jack	by vezerid	1	386
How can I set up week to date report? Liz	by Liz	0	424
COUNTIF according to presence of string within text Ingeniero1	by Ingeniero1	5	1,186
isnumber multiple criteria. cbanks	by Bob Phillips	2	2,140
Convert text string to date AK	by David Billigmeier	1	588
How do I advance filter to multiple locations at once? imills	by Ron de Bruin	3	1,044
Random Number generator Neil M	by [email protected]	2	955
How do you convert an entire column into absolute value? Lorraine	by Gary''s Student	1	6,055
Double lookup formula Steve	by Kevin Vaughn	4	607
"New Web Query" always refreshes data from website (3 times) Matt Suppa	by [email protected]	1	449
how do I count with multiple arguments Chris G	by Bob Phillips	1	747
Tabbing to the next cell katlane	by katlane	2	428
highlighting duplicates alex	by alex	2	524
Combining 2 or more worksheets Steve Lewington	by KemS	3	597
paste special - formulas bjw10	by bjw10	6	804
help with a table TAZGALSINH	by Jim Cone	1	303
Nested function - what key strokes to save and return a value? beancounter	by beancounter	0	639
How to format a number cell to auto count 1 up on file open Joevee	by Joevee	0	493
Ranking based on frequency mac_see	by mac_see	2	533
Conditional DAY [email protected]	by [email protected]	4	497
Pivot Table/Report in Shared workbooks PSikes	by PSikes	1	1,146
Macro code error; machine dependent SJC	by SJC	4	939
Protest sheet but allow sort Pete Walburn	by REVA	4	383
Setting borders for two rows and all columns on spread sheet R OLEJAR	by R OLEJAR	0	553
Dsum will not work DEI	by Ron Coderre	1	377
special formatting adds extra zeroes nosnil14	by nosnil14	0	539
Macro to highlight cells based on content JimDerDog	by vezerid	1	1,864
3D Interpolation EStewart	by EStewart	0	2,245
PivotTable - Calculated Field Matt M HMS	by Matt M HMS	0	512
IF Function Alma	by Alma	6	323
Text string inverting cagolden2003	by Gerrit-Jan Linker	3	373
Display worksheet protection status in a cell? Geoff C	by Geoff C	2	734
I need a Lookup to return more than 1 result joe1182	by vezerid	8	598
Adding hours minutes and seconds WannaChevy03	by WannaChevy03	5	872
Copying a worksheet witrh protected cells to a new worksheet John	by John	2	1,380
workbook1 data to workbook2 data raisin	by CLR	1	348
Postman kuansheng	by Max	1	325
Using INDEX and MATCH to find data in 2 different sheets RMF	by Domenic	5	1,750
EC Excel User Conference This week registration giveaway Damon Longworth	by Damon Longworth	0	848
quirky array not working BorisS	by Bob Phillips	3	496
Adding months to dates should account for 28-30-31 day months Graham	by Ron Rosenfeld	3	971
How do I get a count of dates within a range..? cmharri123	by Bruno Campanini	2	327
Sumproduct question RJS76 via OfficeKB.com	by RJS76 via OfficeKB.com	5	454
Web scraping mickbarry	by [email protected]	2	654
If Function - Multiple Arguements? andyp161	by Arvi Laanemets	4	338
Elements and Arrays in Excel Lighthouseman	by NES	6	699
Conditional Format - Outline Border Drahos	by Drahos	2	942
how to put the subtotal of the sum and count in one spreadhseet? SM	by Bob Phillips	1	457