Excel Worksheet Functions - Page 8

Thread / Thread Starter	Last Post	Replies	Views
'if' formula selecting a cell from a table Aaron Hodson \(Coversure\)	by Aaron Hodson \(Coversure\)	3	522
find & select Aaron Hodson \(Coversure\)	by Aaron Hodson \(Coversure\)	2	526
conditional formatting - repeat formula Aaron Hodson \(Coversure\)	by Bob Phillips	7	679
IF formula help - incorporate greater than & smaller than Aaron Hodson \(Coversure\)	by PCLIVE	10	1,616
export information from excel to word doc template Aaron Hodson \(Coversure\)	by Aaron Hodson \(Coversure\)	5	1,042
hyperlink - clicking on hyper link to select cell in another sheet Aaron Hodson \(Coversure\)	by Ian[_4_]	3	526
IF formula with 3 possible outcomes Aaron Hodson \(Coversure\)	by JE McGimpsey	8	2,192
INDEX FORMULAS & MULTIPLE TABLES Aaron Hodson \(Coversure\)	by Aaron Hodson \(Coversure\)	9	759
using 3 tables in one spreadsheet and utilising index formula to retrieve information Aaron Hodson \(Coversure\)	by Aaron Hodson \(Coversure\)	2	377
locate data from a chart by inserting data into a cell Aaron Hodson \(Coversure\)	by Gav123	3	450
Text to dictate colour of the cell and/or row Aaron Hodson \(Coversure\)	by Aaron Hodson \(Coversure\)	2	471
Conditional Formatting - further assistance required Aaron Hodson \(Coversure\)	by Aaron Hodson \(Coversure\)	2	707
sumif? countif? Aaron Hodson \(Coversure\)	by Pete_UK	3	421
SUMPRODUCT in earlier verions Aaron Hodson \(Coversure\)	by Aaron Hodson \(Coversure\)	5	428
countif compatibility 2007 and earlier versions Aaron Hodson \(Coversure\)	by Shane Devenshire[_2_]	2	873
sumproduct and countif in one formula Aaron Hodson \(Coversure\)	by Aaron Hodson \(Coversure\)	2	642
2007 excel options 'greyed out' Aaron Hodson \(Coversure\)	by Shane Devenshire[_2_]	2	2,410
countifs on earlier version of excel Aaron Hodson \(Coversure\)	by Aaron Hodson \(Coversure\)	5	888
Counting months Aaron Howe	by Aaron Howe	5	560
ISBLANK Aaron Neunz	by Frank Kabel	3	834
EXCEL AUTOFILTER Aaron Neunz	by Frank Kabel	1	541
Adding up to a whole number Aaron R	by Claus Busch	1	946
how do I link cells between two different two different workbooks. Aaron The Young	by Aaron The Young	0	978
Using Solver with the 'Frequency Array' Function Aaron West	by Aaron West	0	451
Limitation on MID function? - very large string Aaron Z	by Peo Sjoblom	4	504
Counting using OR? [email protected]	by Bernd	6	372
Restructuring records into a list [email protected]	by mcg	2	368
COUNTIFS, MULTIPLY BY QUANTITY [email protected]	by [email protected]	2	2,658
In Excel can you merge two columns i.e. street numbers and addres. Aaronhaus	by Pierre	1	995
Data Validation AaronMcG	by Kassie	1	353
Top half of covariance matrix aaronmsl	by ExcelBanter AI	2	7,805
AVERAGE with multiple conditions AaronR	by Wilbur Chua	3	1,137
Formula help Aaron[_3_]	by Pete_UK	3	580
can i delete "lookup" from right-click in excel 2003? aarria	by Ron de Bruin	1	932
Compare and count if data elements on two worksheets are similar aascasacspas	by Teethless mama	1	759
how do I create a macro to auto insert rows? aashish	by Gary''s Student	1	680
need help with networkdays formula aashishtaneja	by Mike H	1	620
Counting total for multiple criteria [email protected]	by [email protected]	2	545
first ten and last ten averages aazharr	by Bernie Deitrick	2	584
vlookup not working on calculated time aa_Steve	by aa_Steve	4	582
entering same formula in multiple sheets AB	by Paul B	1	634
how do i write a macro AB	by Dave F	1	578
Time sheet calculations ab	by ab	3	419
=+(NUMBER OF CELL) IN A CELL, WHAT DOES IT MEAN?example =+D101 AB	by Spiky	2	491
weird problem with LOOKUP function ab	by Jerry W. Lewis	1	454
How to save a 15 digit # in CSV without it changing to a formula? Ab	by David Biddulph[_2_]	1	765
dealer evaluation AB	by PC	1	653
Lookup references Ab	by T. Valko	3	404
Dynamic contents of commens box AB	by Dave Peterson	2	550
Formula between sheets. AB Lighting	by Roger Govier[_3_]	3	615
Drop Down list predicated on other drop down lists ab-original	by Shane Devenshire	2	563
subtotal formatting ab3d4u	by Pete_UK	1	349
Adding VBA Codes ab3d4u[_11_]	by ab3d4u[_12_]	3	435
VLOOKUP may be? ab3d4u[_15_]	by ab3d4u[_16_]	2	309
Formatting? may be ab3d4u[_18_]	by RyGuy	1	335
Excel 2007 ab3d4u[_20_]	by ilia	2	341
Multiple ifs ab3d4u[_22_]	by ab3d4u[_23_]	4	422
IF problem ab3d4u[_24_]	by JMB	1	281
Nested if ab3d4u[_25_]	by CLR	5	573
Restricted Cells ab3d4u[_26_]	by ryguy7272	1	378
at if "delete" formula ab3d4u[_27_]	by Lt. Dan	3	417
let's try it one more time ab3d4u[_28_]	by Jim	1	412
Calculation ab3d4u[_29_]	by David Biddulph[_2_]	3	354
Add, subtract time ab3d4u[_2_]	by Tevuna	2	677
Row protection ab3d4u[_30_]	by Max	1	609
Subtotal sorting ab3d4u[_3_]	by ab3d4u[_4_]	2	496
Count Occurance ab3d4u[_5_]	by ab3d4u[_6_]	2	569
Mutiple Spread Sheets ABA	by ABA	0	537
Don Where do I put the VBA Code? ABA	by Mike H	4	462
Need VBA Code/Marcos To Hide Less than zero amounts. Not a filter ABA	by Don Guillett	1	703
Look Ups and Matches, Sorry if current thread exists- Clueless ABA	by ABA	5	361
Auto Insert/Auto Formula? Abacus	by Robert	1	714
How to display empty text boxes abad351	by Max StenbÃ¤ck	2	394
Vlookup in pivot tables abakay	by abakay	0	432
series of formulas to get to one formula Abanky	by Abanky	1	593