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	493
Function or formula to use yguan	by Suleman Peerzade[_2_]	2	460
Formula to display last entry in a column populated with #N/As T. Duprex	by Stefi	4	478
Conditions zvroom	by Rick Rothstein	3	519
Need help with filtering & inserting information :( Desper84AnAnswer	by Fred Smith[_4_]	5	522
Which function should I use drnlds	by drnlds	4	404
Number of rows/columns occupied Will	by Shane Devenshire[_2_]	4	578
How to get a value of data from the last rows of a table Eddie	by Shane Devenshire[_2_]	4	503
Setting up protection on a workbook brown1965	by Shane Devenshire[_2_]	2	581
Need help about function yguan	by Shane Devenshire[_2_]	3	441
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,083
Inserting dates function ArthurN	by Rick Rothstein	4	481
edit data connection properties karenj900	by Joel	1	928
Occurences between 2 dates Bernie	by Bob Phillips[_3_]	6	601
Linking Multiple Worksheets and Cells Lkap	by Ron de Bruin	1	559
IF AND functions Mary-Anne	by T. Valko	7	537
Errors with 5-10 users in Shared Workbook veggies27	by quietgirl	1	526
delete duplicate values - leaving unique records only i.e. recordspresent once only Jonny Ross	by Ashish Mathur[_2_]	4	895
IF Statement Liz C	by Liz C	6	380
IF Statement nt	by nt	6	1,298
AUTO ROW HEIGHT manutt	by Shane Devenshire[_2_]	2	1,033
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	652
filter for unlocked cells in protected Excell 2007 sheet olegb	by OssieMac	1	1,329
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	938
ISBLANK IF STATEMENT PDUB	by xlmate	7	1,750
MATCH problem Smallweed	by Chip Pearson	3	418
My New Blog ! MaNi	by MaNi	0	320
My New Blog ! MaNi	by MaNi	0	354
transfer stock on condition bestman21	by bestman21	2	498
Calculate 'exact' age in EXCEL Zanny Garbett	by Niek Otten	4	2,246
Maintaining a cells value once a target is achieved cliff18	by Max	9	726
Vlookup to total hours billed Steve[_16_]	by T. Valko	1	561
DO NOT WANT ROW NUMBER IN FORMULA TO CHANGE Angie G.	by T. Valko	3	445
code module? Kat	by Max	2	641
dynamic cell number Dr. S[_2_]	by T. Valko	2	1,693
Connecting drop down list selection to data hypnogic	by hypnogic	4	735
Protection PAL	by Harlan Grove[_2_]	1	451
SUM 2 cells only if there is a value in both milt	by David Biddulph[_2_]	3	581
Data Validation Formula Q Seanie	by Max	14	1,033
count entries based on criteria in a different column ccKennedy	by ccKennedy	2	584
Goal Seeker Brad	by Brad	0	390
delete data -not formula Lisa F	by Lisa F	3	993
Updating an Auto-Filter depending on cell value JAbels001	by Gord Dibben	5	1,384
Amortization Schedule Trish	by joeu2004	11	2,350
Problem entering numbers Martyn Tindall	by Martyn Tindall	3	427
"IN Operator" using Match function.... [email protected]	by Spiky	2	635
Three same Formulas John[_22_]	by Spiky	2	388
count entries based on criteria in a different column ccKennedy	by ccKennedy	2	770
Vlookup Richard	by Pete_UK	3	460
How do I permanently remove external data connections? DOUBLEB	by DOUBLEB	0	3,065
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,403
Finding Problems in Comma Separated List Daren	by Daren	5	623
Returning Sorted Values Kevin Mulvaney	by Pete_UK	3	449
Find and replace in a different cell PointerMan	by Luke M	1	724
Date sensitive calculation refresh Dave_in_gva	by Dave_in_gva	7	556
Auto Ranking a 2x2 table with equal values LiAD	by LiAD	6	583
Conditional formatting Q Seanie	by Seanie	2	358
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,745
Need help with formula WLMPilot	by WLMPilot	3	464
Ranking Equal Values LiAD	by LiAD	1	586
increment cell reference in a formula MarkW1307	by Pete_UK	3	2,049
Using the RANK function question. Skip	by LiAD	4	631
excell'de grafik gÃ¶rÃ¼ntÃ¼ deÄŸerini artÄ±rma Ramazan	by Ramazan	0	362
make sumproduct lookup case sensitive PBcorn	by Pete_UK	1	740
counting the number of attributes/numbers in a cell Mortir	by Mortir	3	331
Indirect.EXT download dosn't exist DontPanic	by David Biddulph[_2_]	3	2,164
Showing formula references in other worksheets Daz	by Daz	0	462
Cell change event causing EXCEL to crash Ashish	by Ashish	3	1,319
Data Validation Lists Problem Steve	by Debra Dalgleish	3	348
Pivot Table - Row subtotals Alex Mackenzie	by Debra Dalgleish	3	371