Excel Worksheet Functions - Page 661

Thread / Thread Starter	Last Post	Replies	Views
HELP COUNTING Pat Brewington	by Bob Phillips	6	501
How to determine color of a cell? KW	by KW	2	946
Lookup value in table BONITA	by Biff	5	596
Forecast using 2 data sets goofy11	by Mike Middleton	1	424
Excel VBA bug? markx	by Ron de Bruin	1	453
Keep cursor in 1 cell Greg	by Niek Otten	5	401
meaning of : IF(Switch; Average(array A, array B); array A) DXAT	by Bernard Liengme	1	1,531
Counting multiple values within single cells Terry Bennett	by Kevin Vaughn	5	1,269
Formula Help Erika	by Dave F	1	451
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	392
Rearranging Data Within a Cell LDL	by LDL	5	564
Calculating time increments from dates during working hours S Davis	by S Davis	0	819
Passwords in macros Julian Glass	by Paul B	1	430
Automatically display filter range in report header in Excel Kjetil	by Kjetil	3	637
Cell to cell hyperlinking does not work, please help Trevor	by Bernard Liengme	1	338
Count months away betwwen a strat and end date by month JY	by Bernard Liengme	1	874
SUMPRODUCT, SUM(IF(...), or some combination? [email protected]	by RobertH	2	762
HOW TO ASSIGN NUMERICAL VALUES TO LETTERS IN EXCEL teacherpaul	by teacherpaul	5	1,456
Hyperlink using a variable destination Christos T	by Bernie Deitrick	1	704
advantage of Database functions Rasoul Khoshravan	by Rasoul Khoshravan	0	1,001
Change Tab colour using Macro Rajat	by Rajat	4	564
Need to Color Record in Duplicates nirod	by nirod	0	565
How do I summarise what I want.... lee	by lee	0	369
Lookup Tables Craig McK	by Craig McK	0	389
measure calculation time for multiplication of two matrices Rasoul Khoshravan	by Rasoul Khoshravan	0	711
Can I increase the length data from a formula in a cell? John	by John	0	429
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,091
AND function? fish	by fish	4	400
How do I match up two tables of data with one column in common Zman	by Ken Wright	1	761
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,543
Nexted if()s are limited to Seven What other functions can I use? dan	by JLatham	8	572
Dsum date based on selection of months [email protected]	by Biff	1	605
Formulae Help, should be easy... legs	by JMB	2	380
I need a template for my supply inventory kmatthews	by Juan	4	3,745
5 minutes intervals april	by Pete_UK	2	900
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,930
FUNCTION STABILITY romelsb	by romelsb	5	420
matching two worksheets and return to different value dan	by smw226 via OfficeKB.com	2	841
my mouse pointer locks on a cell in excel teach3's	by Dave Peterson	4	1,493
VBA language question. Rob	by Sandy	1	781
Lookup multiple values return one value corresponding value Excel DP7	by Biff	1	6,289
Parameters question TR	by romelsb	5	427
change tab colour when using conditional formatting in a cell julie s	by julie s	6	1,611
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	594
Round to up to a threshold jeffbert	by jeffbert	6	1,146
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	997
Vlookup formula criteria gmunro	by Biff	3	471
Whats wrong with this OR formula? Mark	by Pete_UK	4	540
Unhide and hide columns [email protected]	by Dave Peterson	1	634
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	467
how do i highlight a date that is 4+ days old in excel? Picodillo	by romelsb	3	1,901
Function across multiple worksheet phil	by Biff	7	388
and < for Array Sumif ({}) Kiwi Matt	by Bernie Deitrick	6	644
PLEASE PLEASE INDEX MATCH OR SOMETHING ELSE ?? MichelleS	by MichelleS	0	316
Dividing hours to give days SueJB	by SueJB	2	1,163
How do I prevent entering duplicate numbers in an excel worksheet Bran5956	by Jim Thomlinson	1	602
Adding sheets to workbook Susan	by Susan	4	535
Excel formula for golf score to handicap RFGC	by Gord Dibben	1	2,445
aging Rina	by Rina	2	2,155
How to Input date & Time [NOW()], then stop it updating? jonathandr	by Gord Dibben	3	1,718
Microsoft Excel Formula Help Munchkin 76	by Ron Coderre	6	560
if, then formula with conditional formating Rex	by Rex	4	520
add numbers in different cells , but ignore cell with #VALUE! to t Steved	by Steved	0	558
Help with MATCH function Philip	by vezerid	5	404