Excel Worksheet Functions - Page 168

Thread / Thread Starter	Last Post	Replies	Views
Headers on every worksheet lockwood33	by Anne Troy	1	411
using sumif formula: but requiring satisfying 2 if statements karenm	by Bernard Liengme	1	603
What does 'cell("color",A1)' do? ExcelNovice	by Biff	2	843
Quick Little Function Help... Brian07002	by Brian07002	2	395
Comments Not Always Printing At End Carl Bowman	by Anne Troy	1	526
Extracting Text from the right L Ellis	by Ron Coderre	6	415
Convert "800" to "8:00" or "08:00" CPK	by Flintstone	5	2,711
Excel JTGray1	by Niek Otten	1	356
Imported Date & Time format with calcs. managed in excel from imrp Todd F.	by Todd F.	0	1,765
Repositioning the tabs Mr Mike	by Anne Troy	1	692
create list of unique values from a column with repeated values? Chad Schaben	by Anne Troy	1	1,211
What Excel Formula = finding dup records and removing them? alethead74	by Anne Troy	1	685
California rollover Paid Time Off tracking - any templates availa. gsmith	by gsmith	0	1,104
How do I count occurences in a date range? Jeremy	by Dave Peterson	2	533
Establish a Branch of Clayton College here in Malaysia Datuk Dr. Mat Lazim	by Dave Peterson	2	481
Maintaining Protection when copying Jessica Wilson	by Dave Peterson	1	483
Can I format to always AutoFilter specific cells BCantrell	by Dave Peterson	1	560
How do I use a cell value as the filename in an external link? wattkisson	by Dave Peterson	1	724
Not filtering entire Database Katie	by Dave Peterson	2	459
VLOOKUP and ISNA functions Steve ([email protected])	by Steve ([email protected])	2	587
SumProduct or CountIf Kim	by KL	7	633
Auto date/time insert when data entered into an adjacent cell Auto date/time	by Max	1	1,577
Random Number Generator Pascale	by olasa	3	867
Sumif with criteria list Brian Barbre	by Brian Barbre	5	603
How do I compare 2 sets of data and highlight differences? Perplexed1	by olasa	1	2,785
Counting the number of cells meeting conditional formating criteria Jeff	by Jeff	4	1,548
What is the correct function to use, please? DDF	by RagDyer	2	499
calculate future date kevrgallagher	by Fred Smith	3	730
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? Daniel	by David McRitchie	1	1,298
how do i minimize/maximize a workbook from vba? I want to minimize it durring processing to speed things up a bit Daniel	by Dave Peterson	2	1,533
Dynamic Arrays Chiba	by Ashish Mathur	2	450
Create a function wher last digit is always set mcd_fan	by Dana DeLouis	4	445
Help with values gordo	by gordo	0	347
retrieve text from merged cells Eric	by David McRitchie	3	1,054
What does ScreenUpdating = False do? Judy Ward	by David McRitchie	5	504
formatting cells Eric	by David McRitchie	11	713
index match with blank entries andrewm	by Bob Phillips	2	814
mailto addresses Nona	by David McRitchie	3	523
How do I reverse the order (sequence) of a column of data in Excel Ken Hardman	by Max	5	3,064
linking workbooks trying@excel	by trying@excel	0	510
SUM of Hex? GeeB	by GeeB	15	2,071
Comes up #n/a, what do I do? Anthony	by Anthony	2	366
Advance Filter Criteria Jordan	by Art Farrell	2	405
sumif depending on 2 cells matching Anthony	by Gordon	3	459
a problem with if invovling a range of cells Anthony	by Biff	1	408
Auto sum does not add inserted figures in colum Bedros	by Dave Peterson	4	455
Help formating Cells Jrr6415sun	by Gordon	2	483
Analysis Toolpak Translator - Anyone got it??? pullingouthair	by keepITcool	7	589
Excel bug? AndreasN	by AndreasN	2	450
EXCEL - Please add a date format - yyyy mmm dd (mmm being letters I don't know but probably Lorraine O'Del	by David McRitchie	4	1,617
sort ascending tab is not active. Why? jeremy corke	by Dave Peterson	2	671
Insert more than 1 Row Syntax blazzae	by blazzae	5	931
Find then If then Replace cisq1	by cisq1	0	1,070
calling a new function Excel gives me #NAME? Mark Dvorkin	by Mark Dvorkin	4	1,180
totaling figures in colum Bedros	by Bedros	3	487
Compare data on 2 separate worksheets. Wayne	by Ashish Mathur	3	593
total subtotal cells Mary	by Anthony	1	431
Problem with an "if" relating to a range Anthony	by Anthony	7	455
sum function for minutes and seconds in Excel Brian McM	by Anne Troy	4	1,336
Help please simple drop and drag I can't make work Anthony	by Anthony	2	725
IF previous cell value is < 0,(neg)then add it to this cell value GS Mobile	by Bob Phillips	1	547
sorting whole numbers wstruse	by JE McGimpsey	4	899
How to add the 10 smallest numbers out of a range of 20 numbers. JPreeshl	by Martin P	3	806
protection and inserting rows tee	by Kassie	1	491
Do I need a formula or Macro? Sharen	by Anne Troy	2	424
Help with drop down menu Jrr6415sun	by Debra Dalgleish	4	875
compare time in IF statement	by JE McGimpsey	4	1,693
VLOOKUP from another sheet, VBA	by KL	7	1,986
Find then If then Replace cisq1	by cisq1	2	710
header row nospam	by nospam	6	327
How to calculate and then show up as a percent? Amuse	by Tom Ogilvy	1	741
Function to Count Number of Consecutive Rows with a Specific Criteria? Templee1	by Sandy Mann	2	1,094
how can i design a 2 page a day diary / appointment book kevin	by [email protected]	2	696
Help with adding certain cells using an IF function Jrr6415sun	by Padgett	4	416
formulas in pivot table casepaul1	by casepaul1	4	607