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	501
Function or formula to use yguan	by Suleman Peerzade[_2_]	2	468
Formula to display last entry in a column populated with #N/As T. Duprex	by Stefi	4	493
Conditions zvroom	by Rick Rothstein	3	527
Need help with filtering & inserting information :( Desper84AnAnswer	by Fred Smith[_4_]	5	536
Which function should I use drnlds	by drnlds	4	422
Number of rows/columns occupied Will	by Shane Devenshire[_2_]	4	594
How to get a value of data from the last rows of a table Eddie	by Shane Devenshire[_2_]	4	520
Setting up protection on a workbook brown1965	by Shane Devenshire[_2_]	2	625
Need help about function yguan	by Shane Devenshire[_2_]	3	454
Insert a blank row after change in data Genghis2k3	by Per Jessen[_2_]	3	1,015
Is Visual Basic the same as Visual Studio 2008? Mike Stewart	by Bob Phillips[_3_]	5	1,120
Inserting dates function ArthurN	by Rick Rothstein	4	495
edit data connection properties karenj900	by Joel	1	941
Occurences between 2 dates Bernie	by Bob Phillips[_3_]	6	608
Linking Multiple Worksheets and Cells Lkap	by Ron de Bruin	1	567
IF AND functions Mary-Anne	by T. Valko	7	542
Errors with 5-10 users in Shared Workbook veggies27	by quietgirl	1	537
delete duplicate values - leaving unique records only i.e. recordspresent once only Jonny Ross	by Ashish Mathur[_2_]	4	907
IF Statement Liz C	by Liz C	6	386
IF Statement nt	by nt	6	1,305
AUTO ROW HEIGHT manutt	by Shane Devenshire[_2_]	2	1,067
WHICH FUNCTION Malcolm Austin	by Shane Devenshire[_2_]	4	406
EDATE returns #NA Error when Excel opened again richard flavell	by Shane Devenshire[_2_]	2	662
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	477
Separate parts of a name into three cells Liz C	by Mike H	3	951
ISBLANK IF STATEMENT PDUB	by xlmate	7	1,756
MATCH problem Smallweed	by Chip Pearson	3	425
My New Blog ! MaNi	by MaNi	0	327
My New Blog ! MaNi	by MaNi	0	360
transfer stock on condition bestman21	by bestman21	2	505
Calculate 'exact' age in EXCEL Zanny Garbett	by Niek Otten	4	2,258
Maintaining a cells value once a target is achieved cliff18	by Max	9	735
Vlookup to total hours billed Steve[_16_]	by T. Valko	1	571
DO NOT WANT ROW NUMBER IN FORMULA TO CHANGE Angie G.	by T. Valko	3	454
code module? Kat	by Max	2	653
dynamic cell number Dr. S[_2_]	by T. Valko	2	1,711
Connecting drop down list selection to data hypnogic	by hypnogic	4	754
Protection PAL	by Harlan Grove[_2_]	1	459
SUM 2 cells only if there is a value in both milt	by David Biddulph[_2_]	3	590
Data Validation Formula Q Seanie	by Max	14	1,046
count entries based on criteria in a different column ccKennedy	by ccKennedy	2	611
Goal Seeker Brad	by Brad	0	394
delete data -not formula Lisa F	by Lisa F	3	1,003
Updating an Auto-Filter depending on cell value JAbels001	by Gord Dibben	5	1,416
Amortization Schedule Trish	by joeu2004	11	2,383
Problem entering numbers Martyn Tindall	by Martyn Tindall	3	435
"IN Operator" using Match function.... [email protected]	by Spiky	2	646
Three same Formulas John[_22_]	by Spiky	2	410
count entries based on criteria in a different column ccKennedy	by ccKennedy	2	793
Vlookup Richard	by Pete_UK	3	466
How do I permanently remove external data connections? DOUBLEB	by DOUBLEB	0	3,090
next row formula emm	by T. Valko	7	3,550
How do I calculate a difference in work days? Work Days	by Gord Dibben	17	1,422
Finding Problems in Comma Separated List Daren	by Daren	5	634
Returning Sorted Values Kevin Mulvaney	by Pete_UK	3	459
Find and replace in a different cell PointerMan	by Luke M	1	732
Date sensitive calculation refresh Dave_in_gva	by Dave_in_gva	7	564
Auto Ranking a 2x2 table with equal values LiAD	by LiAD	6	594
Conditional formatting Q Seanie	by Seanie	2	367
IF funtion to result in cell colouring Peta	by Eduardo	1	425
Format dates from English to Spanish FA	by David Biddulph[_2_]	2	2,769
Need help with formula WLMPilot	by WLMPilot	3	475
Ranking Equal Values LiAD	by LiAD	1	596
increment cell reference in a formula MarkW1307	by Pete_UK	3	2,074
Using the RANK function question. Skip	by LiAD	4	635
excell'de grafik gÃ¶rÃ¼ntÃ¼ deÄŸerini artÄ±rma Ramazan	by Ramazan	0	367
make sumproduct lookup case sensitive PBcorn	by Pete_UK	1	748
counting the number of attributes/numbers in a cell Mortir	by Mortir	3	340
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,337
Data Validation Lists Problem Steve	by Debra Dalgleish	3	357
Pivot Table - Row subtotals Alex Mackenzie	by Debra Dalgleish	3	377