Excel Worksheet Functions - Page 271

Thread / Thread Starter	Last Post	Replies	Views
excel function help fabien	by Bob Phillips	1	437
Found a SERIOUS bug in Excel !!! irresistible007	by Bob Phillips	2	466
Custom Format alphanumberic value with spaces Bruce	by Ron Rosenfeld	2	576
How do I change data spacing in a column Manthelan	by JE McGimpsey	1	627
Please help me with a formula Smeeg	by Smeeg	7	397
What formula can I set up to do a cross lookup in an Excel table? grigorovag	by William Horton	1	888
Data validation issue mevetts	by mevetts	4	514
SUMIF INDIRECT Alectrical	by Alectrical	8	851
i forget my Microsoft Excel files password tell me the solution danish	by JE McGimpsey	1	734
i forget my Microsoft Excel files password tell me the solution danish	by JE McGimpsey	1	885
What formula captures specified rows of data? Brian G Scully	by DOR	3	440
Need help again :D Smeeg	by Smeeg	4	358
Excel should have a formula for amortization. BugTracker	by noyb	2	409
COUNTIF or SUMIF or ?? croakingtoad	by bpeltzer	2	641
Formulas across worksheets do not update surg4u1975	by Daigle	2	473
Sort by Location ecohen1	by DOR	1	426
How do I include only visible cells in a range? Frequent User	by JE McGimpsey	1	610
Help with using range names in sum function soteman2005	by Niek Otten	2	1,499
move cusor to the next unprotected cell RS	by Connie Martin	2	716
Excel Function weller	by SteveG	3	480
in formulas how can I use contents of a cell? Soo	by Bob Phillips	3	364
sum number of cells based on letter/title criteria chazmac	by Bob Phillips	2	474
selecting every eg 5th cell in a worksheet stephen	by Don Guillett	2	1,275
It seems to me that I need an event Macro, nick s	by David McRitchie	8	633
Event Macro adjustment needed - need to change font color also nick s	by nick s	2	1,108
matching multiples fields in 1 row Hobochunk	by Hobochunk	0	520
using lookup to return more than one answer in date format Geni Slaughter	by Geni Slaughter	4	800
EXTRACT NUMBERS FROM TEXT STRING fiber_doc	by Roger Govier	4	2,349
One worksheet to calulate different items simultaneously John	by Niek Otten	4	1,129
Stop Loss Formulas for Stock Trading zmr325	by David McRitchie	1	1,531
Modifying A Sumproduct Formula carl	by Bob Phillips	1	502
GESTEP Moatsem	by Gord Dibben	1	1,392
Formula - Count multi filter ??? ecohen1	by ecohen1	5	695
linear regression Jason - MR	by pdberger	1	781
Nested Formula MichaelS	by Biff	6	645
Problem with lists TooBaaaadd	by Gord Dibben	1	521
Dispalcement, Vlookup problems. Paul987	by DOR	5	596
Data falls in a range +/-1 SMac	by Bernard Liengme	3	677
Filter problem [email protected]	by DOR	1	604
MCONCAT lehigh46	by Laurent Longre	4	1,101
macro dtmd	by dtmd	0	438
How do I change the date format when importing a txt file? vpuckett	by Peo Sjoblom	2	661
How do you do a VLookup with two conditions? ryesworld	by Dave Peterson	8	1,025
I get error messages in Excel cells once I save a file JeffJake	by Gord Dibben	1	703
Can anyone help me Create Excel list of files in windows folders solrac1956	by Chip Pearson	1	887
How to keep cell font setting after inserting hyperlink come_mon_come_mon!	by Ed Ferrero	8	564
Hiding Columns lehigh46	by PeterAtherton	2	501
how do i combine IF and OR function Marcel	by Marcel	5	724
Average of top 3 numbers. Belzbub	by Ron Coderre	26	1,804
How do I disable "Get Pivot Data" when working from pivot tables? Frustrated excel 2003 user	by Ron Coderre	2	1,509
Simple password generator ckroon	by FinRazel	2	534
Calculating basic averages...a question stew1901	by stew1901	5	973
Vlookup max value only n_gineer	by Ashish Mathur	4	823
CONDITIONAL FORMAT John	by John	12	767
True or False Krish	by Ashish Mathur	3	651
Indexing/Matching True/False results drvortex	by DOR	5	476
the answer to appear in more than one cell LHorse	by LHorse	4	506
Best way to tackle this problem... Lee Harris	by Lee Harris	1	552
Calculating averages excluding outliers...a question stew1901	by Ron Rosenfeld	4	2,328
set a cell up in a 'calculator' type formula< x+1+1+1+1=x+3 g_moss	by g_moss	0	383
conditional formatting using contains nic4asu	by B. R.Ramachandran	2	462
Formula reading formula instead of cell content roy.okinawa	by roy.okinawa	1	508
turn off auto subtotal jenn	by Debra Dalgleish	1	580
How do I pull a random sample of people from a list in excel? PM	by Alan	6	2,365
Zero replaces blank field when paste special is used Baseball Greg	by Jerry W. Lewis	5	862
minimum from various columns without zeroes joie	by Peo Sjoblom	5	482
in excel conditional formatting find the greatest value in 4rows prac g	by Biff	1	751
Locking Sheets / Hiding Sheets Lee Harris	by Arvi Laanemets	4	889
auto insert invoice number that increases by one each time opened Michael HPSC	by Michael HPSC	3	2,004
combining conditional statements wrosie	by [email protected]	4	1,018
How can I count cells of a specific colour (pattern)? Nick@Durham	by Gary''s Student	1	730
Force format change in excel Benson	by Max	5	3,162
Text Strings Swap Mzansi	by Bob Phillips	1	468
Weird problem Sue	by Sue	2	467
number convert to text MBPC	by Bob Phillips	2	436