Excel Worksheet Functions - Page 249

Thread / Thread Starter	Last Post	Replies	Views
Find the numbers used in a range MIK	by Suleman Peerzade[_2_]	4	516
Function or formula to use yguan	by Suleman Peerzade[_2_]	2	479
Formula to display last entry in a column populated with #N/As T. Duprex	by Stefi	4	501
Conditions zvroom	by Rick Rothstein	3	533
Need help with filtering & inserting information :( Desper84AnAnswer	by Fred Smith[_4_]	5	549
Which function should I use drnlds	by drnlds	4	433
Number of rows/columns occupied Will	by Shane Devenshire[_2_]	4	605
How to get a value of data from the last rows of a table Eddie	by Shane Devenshire[_2_]	4	532
Setting up protection on a workbook brown1965	by Shane Devenshire[_2_]	2	637
Need help about function yguan	by Shane Devenshire[_2_]	3	466
Insert a blank row after change in data Genghis2k3	by Per Jessen[_2_]	3	1,021
Is Visual Basic the same as Visual Studio 2008? Mike Stewart	by Bob Phillips[_3_]	5	1,128
Inserting dates function ArthurN	by Rick Rothstein	4	507
edit data connection properties karenj900	by Joel	1	949
Occurences between 2 dates Bernie	by Bob Phillips[_3_]	6	618
Linking Multiple Worksheets and Cells Lkap	by Ron de Bruin	1	570
IF AND functions Mary-Anne	by T. Valko	7	554
Errors with 5-10 users in Shared Workbook veggies27	by quietgirl	1	550
delete duplicate values - leaving unique records only i.e. recordspresent once only Jonny Ross	by Ashish Mathur[_2_]	4	922
IF Statement Liz C	by Liz C	6	393
IF Statement nt	by nt	6	1,318
AUTO ROW HEIGHT manutt	by Shane Devenshire[_2_]	2	1,072
WHICH FUNCTION Malcolm Austin	by Shane Devenshire[_2_]	4	418
EDATE returns #NA Error when Excel opened again richard flavell	by Shane Devenshire[_2_]	2	675
filter for unlocked cells in protected Excell 2007 sheet olegb	by OssieMac	1	1,336
Add a nr in each row in a column Kristian	by Kristian	5	489
Separate parts of a name into three cells Liz C	by Mike H	3	959
ISBLANK IF STATEMENT PDUB	by xlmate	7	1,769
MATCH problem Smallweed	by Chip Pearson	3	437
My New Blog ! MaNi	by MaNi	0	330
My New Blog ! MaNi	by MaNi	0	363
transfer stock on condition bestman21	by bestman21	2	515
Calculate 'exact' age in EXCEL Zanny Garbett	by Niek Otten	4	2,270
Maintaining a cells value once a target is achieved cliff18	by Max	9	749
Vlookup to total hours billed Steve[_16_]	by T. Valko	1	572
DO NOT WANT ROW NUMBER IN FORMULA TO CHANGE Angie G.	by T. Valko	3	469
code module? Kat	by Max	2	665
dynamic cell number Dr. S[_2_]	by T. Valko	2	1,722
Connecting drop down list selection to data hypnogic	by hypnogic	4	762
Protection PAL	by Harlan Grove[_2_]	1	460
SUM 2 cells only if there is a value in both milt	by David Biddulph[_2_]	3	603
Data Validation Formula Q Seanie	by Max	14	1,059
count entries based on criteria in a different column ccKennedy	by ccKennedy	2	624
Goal Seeker Brad	by Brad	0	394
delete data -not formula Lisa F	by Lisa F	3	1,013
Updating an Auto-Filter depending on cell value JAbels001	by Gord Dibben	5	1,424
Amortization Schedule Trish	by joeu2004	11	2,384
Problem entering numbers Martyn Tindall	by Martyn Tindall	3	448
"IN Operator" using Match function.... [email protected]	by Spiky	2	652
Three same Formulas John[_22_]	by Spiky	2	422
count entries based on criteria in a different column ccKennedy	by ccKennedy	2	800
Vlookup Richard	by Pete_UK	3	466
How do I permanently remove external data connections? DOUBLEB	by DOUBLEB	0	3,095
next row formula emm	by T. Valko	7	3,560
How do I calculate a difference in work days? Work Days	by Gord Dibben	17	1,428
Finding Problems in Comma Separated List Daren	by Daren	5	647
Returning Sorted Values Kevin Mulvaney	by Pete_UK	3	468
Find and replace in a different cell PointerMan	by Luke M	1	741
Date sensitive calculation refresh Dave_in_gva	by Dave_in_gva	7	576
Auto Ranking a 2x2 table with equal values LiAD	by LiAD	6	604
Conditional formatting Q Seanie	by Seanie	2	375
IF funtion to result in cell colouring Peta	by Eduardo	1	434
Format dates from English to Spanish FA	by David Biddulph[_2_]	2	2,773
Need help with formula WLMPilot	by WLMPilot	3	485
Ranking Equal Values LiAD	by LiAD	1	603
increment cell reference in a formula MarkW1307	by Pete_UK	3	2,081
Using the RANK function question. Skip	by LiAD	4	648
excell'de grafik gÃ¶rÃ¼ntÃ¼ deÄŸerini artÄ±rma Ramazan	by Ramazan	0	369
make sumproduct lookup case sensitive PBcorn	by Pete_UK	1	752
counting the number of attributes/numbers in a cell Mortir	by Mortir	3	356
Indirect.EXT download dosn't exist DontPanic	by David Biddulph[_2_]	3	2,192
Showing formula references in other worksheets Daz	by Daz	0	470
Cell change event causing EXCEL to crash Ashish	by Ashish	3	1,350
Data Validation Lists Problem Steve	by Debra Dalgleish	3	370
Pivot Table - Row subtotals Alex Mackenzie	by Debra Dalgleish	3	377