Excel Worksheet Functions - Page 661

Thread / Thread Starter	Last Post	Replies	Views
HELP COUNTING Pat Brewington	by Bob Phillips	6	511
How to determine color of a cell? KW	by KW	2	949
Lookup value in table BONITA	by Biff	5	599
Forecast using 2 data sets goofy11	by Mike Middleton	1	432
Excel VBA bug? markx	by Ron de Bruin	1	461
Keep cursor in 1 cell Greg	by Niek Otten	5	403
meaning of : IF(Switch; Average(array A, array B); array A) DXAT	by Bernard Liengme	1	1,536
Counting multiple values within single cells Terry Bennett	by Kevin Vaughn	5	1,283
Formula Help Erika	by Dave F	1	456
Worksheet function: last saved date Tieske	by Jim Thomlinson	1	560
How can I sort or search the sheet tabs? spippin	by Dave Peterson	3	460
=IF(B1,"",SUMPRODUCT(--(B$1:B$5=""),--(A1<A$1:A$5))+1), Biff formula Rasoul Khoshravan	by Kevin Vaughn	1	828
Extract Symbol Karen	by Karen	9	395
Rearranging Data Within a Cell LDL	by LDL	5	566
Calculating time increments from dates during working hours S Davis	by S Davis	0	828
Passwords in macros Julian Glass	by Paul B	1	433
Automatically display filter range in report header in Excel Kjetil	by Kjetil	3	648
Cell to cell hyperlinking does not work, please help Trevor	by Bernard Liengme	1	344
Count months away betwwen a strat and end date by month JY	by Bernard Liengme	1	875
SUMPRODUCT, SUM(IF(...), or some combination? [email protected]	by RobertH	2	771
HOW TO ASSIGN NUMERICAL VALUES TO LETTERS IN EXCEL teacherpaul	by teacherpaul	5	1,464
Hyperlink using a variable destination Christos T	by Bernie Deitrick	1	714
advantage of Database functions Rasoul Khoshravan	by Rasoul Khoshravan	0	1,009
Change Tab colour using Macro Rajat	by Rajat	4	573
Need to Color Record in Duplicates nirod	by nirod	0	567
How do I summarise what I want.... lee	by lee	0	370
Lookup Tables Craig McK	by Craig McK	0	392
measure calculation time for multiplication of two matrices Rasoul Khoshravan	by Rasoul Khoshravan	0	718
Can I increase the length data from a formula in a cell? John	by John	0	434
annual growing rate formula or funtion needed!! Ivan	by Niek Otten	1	565
what does { and } mean in an Excel formula? Marcus Sparcus	by Pete_UK	2	1,098
AND function? fish	by fish	4	409
How do I match up two tables of data with one column in common Zman	by Ken Wright	1	770
add text in a cell to trigger a calculation noddy47	by Pete_UK	3	428
hyperlink to .png file bobby binx	by bobby binx	0	1,549
Nexted if()s are limited to Seven What other functions can I use? dan	by JLatham	8	575
Dsum date based on selection of months [email protected]	by Biff	1	608
Formulae Help, should be easy... legs	by JMB	2	381
I need a template for my supply inventory kmatthews	by Juan	4	3,745
5 minutes intervals april	by Pete_UK	2	903
Copy a table from a web site, then manipulate the data? Confused Rookie	by Don Guillett	1	513
automation autosave .xls as .txt jim sturtz	by JLatham	5	1,934
FUNCTION STABILITY romelsb	by romelsb	5	423
matching two worksheets and return to different value dan	by smw226 via OfficeKB.com	2	851
my mouse pointer locks on a cell in excel teach3's	by Dave Peterson	4	1,493
VBA language question. Rob	by Sandy	1	791
Lookup multiple values return one value corresponding value Excel DP7	by Biff	1	6,298
Parameters question TR	by romelsb	5	437
change tab colour when using conditional formatting in a cell julie s	by julie s	6	1,612
how do i make negative numbers equal zero benny1	by Elkar	2	1,383
How can I check for dupes in more than one column in excel? latwood	by Teethless mama	2	604
Round to up to a threshold jeffbert	by jeffbert	6	1,153
How to return value from functions in other sheets? TR	by TR	3	606
Cell contents in header/footer mdavison	by mdavison	5	747
REVERSE SINGLE CELL TEXT STRING Tammy	by Biff	2	1,007
Vlookup formula criteria gmunro	by Biff	3	472
Whats wrong with this OR formula? Mark	by Pete_UK	4	542
Unhide and hide columns [email protected]	by Dave Peterson	1	640
Create a List by formula from other data Kim Shelton at PDC	by Biff	1	396
reference with variable row number ? Arc_K	by Biff	7	1,013
Default to zero currency value SITCFanTN	by Dave F	1	477
how do i highlight a date that is 4+ days old in excel? Picodillo	by romelsb	3	1,911
Function across multiple worksheet phil	by Biff	7	388
and < for Array Sumif ({}) Kiwi Matt	by Bernie Deitrick	6	652
PLEASE PLEASE INDEX MATCH OR SOMETHING ELSE ?? MichelleS	by MichelleS	0	321
Dividing hours to give days SueJB	by SueJB	2	1,164
How do I prevent entering duplicate numbers in an excel worksheet Bran5956	by Jim Thomlinson	1	613
Adding sheets to workbook Susan	by Susan	4	543
Excel formula for golf score to handicap RFGC	by Gord Dibben	1	2,445
aging Rina	by Rina	2	2,162
How to Input date & Time [NOW()], then stop it updating? jonathandr	by Gord Dibben	3	1,719
Microsoft Excel Formula Help Munchkin 76	by Ron Coderre	6	565
if, then formula with conditional formating Rex	by Rex	4	530
add numbers in different cells , but ignore cell with #VALUE! to t Steved	by Steved	0	563
Help with MATCH function Philip	by vezerid	5	413