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	492
Function or formula to use yguan	by Suleman Peerzade[_2_]	2	459
Formula to display last entry in a column populated with #N/As T. Duprex	by Stefi	4	477
Conditions zvroom	by Rick Rothstein	3	518
Need help with filtering & inserting information :( Desper84AnAnswer	by Fred Smith[_4_]	5	520
Which function should I use drnlds	by drnlds	4	401
Number of rows/columns occupied Will	by Shane Devenshire[_2_]	4	563
How to get a value of data from the last rows of a table Eddie	by Shane Devenshire[_2_]	4	502
Setting up protection on a workbook brown1965	by Shane Devenshire[_2_]	2	579
Need help about function yguan	by Shane Devenshire[_2_]	3	438
Insert a blank row after change in data Genghis2k3	by Per Jessen[_2_]	3	994
Is Visual Basic the same as Visual Studio 2008? Mike Stewart	by Bob Phillips[_3_]	5	1,077
Inserting dates function ArthurN	by Rick Rothstein	4	473
edit data connection properties karenj900	by Joel	1	926
Occurences between 2 dates Bernie	by Bob Phillips[_3_]	6	595
Linking Multiple Worksheets and Cells Lkap	by Ron de Bruin	1	554
IF AND functions Mary-Anne	by T. Valko	7	537
Errors with 5-10 users in Shared Workbook veggies27	by quietgirl	1	523
delete duplicate values - leaving unique records only i.e. recordspresent once only Jonny Ross	by Ashish Mathur[_2_]	4	894
IF Statement Liz C	by Liz C	6	377
IF Statement nt	by nt	6	1,297
AUTO ROW HEIGHT manutt	by Shane Devenshire[_2_]	2	1,011
WHICH FUNCTION Malcolm Austin	by Shane Devenshire[_2_]	4	394
EDATE returns #NA Error when Excel opened again richard flavell	by Shane Devenshire[_2_]	2	651
filter for unlocked cells in protected Excell 2007 sheet olegb	by OssieMac	1	1,328
Add a nr in each row in a column Kristian	by Kristian	5	468
Separate parts of a name into three cells Liz C	by Mike H	3	936
ISBLANK IF STATEMENT PDUB	by xlmate	7	1,748
MATCH problem Smallweed	by Chip Pearson	3	412
My New Blog ! MaNi	by MaNi	0	317
My New Blog ! MaNi	by MaNi	0	350
transfer stock on condition bestman21	by bestman21	2	496
Calculate 'exact' age in EXCEL Zanny Garbett	by Niek Otten	4	2,221
Maintaining a cells value once a target is achieved cliff18	by Max	9	718
Vlookup to total hours billed Steve[_16_]	by T. Valko	1	558
DO NOT WANT ROW NUMBER IN FORMULA TO CHANGE Angie G.	by T. Valko	3	443
code module? Kat	by Max	2	638
dynamic cell number Dr. S[_2_]	by T. Valko	2	1,669
Connecting drop down list selection to data hypnogic	by hypnogic	4	729
Protection PAL	by Harlan Grove[_2_]	1	448
SUM 2 cells only if there is a value in both milt	by David Biddulph[_2_]	3	578
Data Validation Formula Q Seanie	by Max	14	1,031
count entries based on criteria in a different column ccKennedy	by ccKennedy	2	578
Goal Seeker Brad	by Brad	0	387
delete data -not formula Lisa F	by Lisa F	3	991
Updating an Auto-Filter depending on cell value JAbels001	by Gord Dibben	5	1,383
Amortization Schedule Trish	by joeu2004	11	2,350
Problem entering numbers Martyn Tindall	by Martyn Tindall	3	423
"IN Operator" using Match function.... [email protected]	by Spiky	2	632
Three same Formulas John[_22_]	by Spiky	2	386
count entries based on criteria in a different column ccKennedy	by ccKennedy	2	756
Vlookup Richard	by Pete_UK	3	459
How do I permanently remove external data connections? DOUBLEB	by DOUBLEB	0	3,063
next row formula emm	by T. Valko	7	3,545
How do I calculate a difference in work days? Work Days	by Gord Dibben	17	1,401
Finding Problems in Comma Separated List Daren	by Daren	5	622
Returning Sorted Values Kevin Mulvaney	by Pete_UK	3	443
Find and replace in a different cell PointerMan	by Luke M	1	723
Date sensitive calculation refresh Dave_in_gva	by Dave_in_gva	7	553
Auto Ranking a 2x2 table with equal values LiAD	by LiAD	6	579
Conditional formatting Q Seanie	by Seanie	2	355
IF funtion to result in cell colouring Peta	by Eduardo	1	421
Format dates from English to Spanish FA	by David Biddulph[_2_]	2	2,743
Need help with formula WLMPilot	by WLMPilot	3	461
Ranking Equal Values LiAD	by LiAD	1	582
increment cell reference in a formula MarkW1307	by Pete_UK	3	2,049
Using the RANK function question. Skip	by LiAD	4	630
excell'de grafik gÃ¶rÃ¼ntÃ¼ deÄŸerini artÄ±rma Ramazan	by Ramazan	0	361
make sumproduct lookup case sensitive PBcorn	by Pete_UK	1	737
counting the number of attributes/numbers in a cell Mortir	by Mortir	3	327
Indirect.EXT download dosn't exist DontPanic	by David Biddulph[_2_]	3	2,131
Showing formula references in other worksheets Daz	by Daz	0	457
Cell change event causing EXCEL to crash Ashish	by Ashish	3	1,316
Data Validation Lists Problem Steve	by Debra Dalgleish	3	347
Pivot Table - Row subtotals Alex Mackenzie	by Debra Dalgleish	3	371