Excel Worksheet Functions - Page 555

Thread / Thread Starter	Last Post	Replies	Views
Macro button that others can see Newbee	by Newbee	2	415
Sum function when the values in an xls are color coded Angeles	by Angeles	2	715
Sum if function Kishor Bhalerao[_2_]	by David Biddulph[_2_]	2	352
Sum with special requirement firroo	by firroo	2	391
Counting cells with colored font JockW	by JockW	2	745
#DIV/0! errors Erin Leva[_2_]	by David Biddulph[_2_]	2	507
incorrect calculation Markies	by Gary''s Student	2	317
if then based on date range Ann	by Ann	2	748
Linking Texts from on sheet to another while maintaining formattin merritaf	by merritaf	2	316
Consoildation of data for upload Bob	by Bob	2	387
Alpha column lables Oly User	by Oly User[_2_]	2	361
Avoiding #Value errors when referencing DB Tables Jeff Metcalf	by Jeff Metcalf	2	433
Macro Button Problem Squeaky	by Squeaky	2	380
importing multiple values from a spreadsheet Perplexed Peter	by Perplexed Peter[_2_]	2	377
Report duplicate rows [email protected]	by [email protected]	2	514
Autoformat issue Imi	by Imi	2	383
apply conditional format to time TD[_2_]	by Peo Sjoblom	2	891
Calculating 50% complete, returning Yes or No candacer	by Mike H	2	326
COUNTIF or COUNT.... IF MBS	by Marcelo	2	424
?? VLookup ?? Charles	by Dave	2	392
Microsoft Excel 2003 clark	by Gord Dibben	2	393
SUM+IF Array formula PFAA	by Bob Phillips	2	392
IF Statement based on cell color Koshkii	by Koshkii	2	2,890
Search for a partial number das	by Ron Rosenfeld	2	521
VLOOKUP Dave	by Dave	2	377
Is It Possible To Have... After A Button Press A Message Pops Up ? Chris	by Learning Excel	2	626
Finding first number in a row Cadders	by Cadders	2	2,527
How to sum a variable number of items RobinC	by Stefi	2	776
How do I lookup a worksheet name in excel? RJL007	by Rick Rothstein \(MVP - VB\)[_575_]	2	3,008
look up max CTURNER82	by Niek Otten	2	338
Formatting cells Tom J	by OssieMac	2	386
MAX TEXT ON A MASSEGE? Papin	by Papin	2	434
Worksheet autocalc with min function in error Loretta	by Niek Otten	2	395
loan amortization schedule - skiped months jc12999	by Fred Smith[_4_]	2	579
Why do i lose EOMONTH on file close Jake	by Jake	2	472
calculate total items meeting criteria in range with multiple shee twototango	by twototango	2	561
Trying to build reference to external, web-based sheets Error trying to sort in a Macro	by Error trying to sort in a Macro	2	460
what function/formula do I use? kate	by kate	2	957
COUNTIF with text criteria Alexey[_3_]	by Alexey[_3_]	2	1,417
Excel keeps auto-changing my formulas to include other cells. emeraldc	by Niek Otten	2	2,866
Can't get NETWORKDAYS to calc elapsed banking days in a month flecky	by Bob Phillips	2	703
Date formats English/US Peter Glebe	by Pete_UK	2	422
Drop Down Lists DJB	by Reitanos	2	327
VLOOKUP please help AP	by AP	2	336
countif colored numbers Mark	by Pete_UK	2	746
Using VLOOKUP results in a DSUM criteria range bluefish	by bluefish	2	1,417
Lookup from a list of numbers Dean	by Dean	2	381
converting text to numbers northerner	by Spiky	2	424
if(and(isblank( formula help JC	by Sandy Mann	2	533
Only adding nonzeroes BryGuy77	by Gord Dibben	2	287
Deleting Rows Containing Protected Cells Marge O.	by Todd A[_2_]	2	607
Enter number in a cell and it is to display time. Peter	by Dave Curtis	2	569
Named Ranges in Array Formulas jfitzpat	by jfitzpat	2	812
conditional change to absolute COB	by COB	2	627
VLOOKUP AP	by AP	2	296
De-identify data Eilean	by Eilean	2	6,176
Picking a value from a table using Column and Row ranges? James Dalton[_2_]	by James Dalton[_2_]	2	766
Goal Seek with Complex Numbers monir	by monir	2	1,266
Indirect Paul W Smith	by Paul W Smith	2	434
How to reference Cells AA and forward with CHAR (and a bonus quest Babymech	by Harlan Grove[_2_]	2	3,713
How do I copy a vlookup formula without changing the data range? VickyL872	by Alan Beban[_2_]	2	4,353
Sumproduct Hilton	by Teethless mama	2	416
lookup and return first... Jesper	by Marcelo	2	384
Excel 2007 Natural language formula Edna Basilis	by Niek Otten	2	1,616
vlookup help Giac	by Giac	2	296
How to add an inverted comma in a cell? Newbie	by Ragdyer	2	1,499
I want formula for multiple criteria using ih differnt column PERANISH	by PERANISH	2	411
Convert Letter to Number ExcelMS	by ExcelMS	2	538
Using SUMIF function and conditional formatting BSM	by Bob Phillips	2	1,161
Lookup Question Based upon 2 Variables Lois	by Peo Sjoblom	2	418
copy row content from one worksheet to another, if a condition met Lorilenore	by Max	2	2,630
Excel 2003 vs Excel 2002 duranwd	by Chip Pearson	2	430
please help in excel functions. Rajesh Chandra	by Stefi	2	439
convert moshe	by Fred Smith[_4_]	2	389
Using font elements as condition criteria StorageHawk	by StorageHawk	2	345