Excel Worksheet Functions - Page 633

Thread / Thread Starter	Last Post	Replies	Views
How can I use €œcountif€ to count BOTH zeros AND blank cells as zer Danielle	by JMB	1	594
Copy - Paste Special problem Bob Smith	by Bob Smith	2	512
Mapping values from an index!!?? HELP! BCBS_exceller	by JMB	3	478
How do I build a Construction Schedule of Values in Excel? Caleb Howze	by Martin Fishlock	1	5,720
How can I add times, i.e., 1:45:30 + 2:10:20? wahjazz	by Fred Smith	2	348
EXCEL: MOD FUNCTION or DIVISION NAIMA	by Max	6	1,465
Calculating overlapping time periods Arlette	by Arlette	0	718
Array formula referencing other worksheets broderp	by Dave F	1	515
Ignore Data for Dynamic Range Dale	by Dale	1	506
Counting Question rlee1999	by Duke Carey	7	448
sumproduct RGlade	by RGlade	3	378
macro or if statement CHARI	by CHARI	2	566
Multiple SUMIF Krish	by Don Guillett	1	356
Counting Words In Excel Formula dayd	by John Bundy	1	393
matrix multiplication for labor costs [email protected]	by [email protected]	0	813
To project inventory rundown and forecast Bob	by John Bundy	1	1,296
Row numbers containing specific value within a column carl43m	by Ron Coderre	15	968
Totaling contributions Jack Taylor	by John Bundy	1	431
how do I remove both duplicate records in excel Mtgdbsmgr	by Duke Carey	1	516
yield of a security Securities Auditor	by Duke Carey	1	568
need help creating formula [email protected]	by [email protected]	2	447
converting text to number Julio	by John Bundy	1	417
Return Column sign - PLEASE HELP Nir	by Roger Govier	1	410
finding one value by combining many Trandall37	by Bernie Deitrick	1	368
Counting Marked Cells Fred Atkinson	by Fred Atkinson	3	1,498
Create a funktion Jenna	by Jenna	2	450
Copying Excel formulas between sheets Hoz	by frankjh19701	2	1,165
How to find and replace all "*" symbols Roger	by Ron Coderre	3	761
Error message: "cannot shift object off sheet" Peter Vickers	by Dave Peterson	4	1,307
Don't know what to call the type of function I need Kasey	by Kasey	4	721
Macro Formula for Max value El Bee	by Gary''s Student	4	811
VLOOKUP steph44haf	by Alicia	6	443
PMT Function Ashley	by Bernie Deitrick	2	386
combo reference on another combo box for picking address etc. kbjin	by Ron Coderre	1	1,079
Date function Pasty	by Pasty	4	400
Advanced IF statement / LOOKUP Jane	by Jane	4	606
Conditional Formatting Green-shutters	by Bob Phillips	2	300
dates Susie	by Dave F	1	303
Calculate the number of days between two dates,missing weekends? littlejess22	by Dave F	2	1,403
LEADING ZEROS IN FORMULA RESULT Advent	by Advent	4	887
variable text value within string formula required to sum column Tester	by CLR	2	665
Creating a formula JMP	by Nick Hodge	2	432
Numbers Converted to Text - Last Digit Replaced by Zero Cheryl B.	by Ron Rosenfeld	18	2,405
help in formatting cells [email protected]	by Bob Phillips	1	362
convert second to date and time --== Alain ==--	by Bob Phillips	4	970
Cannot enter 0% into a cell Louise	by Louise	3	526
merging info from different tabs Ted	by Ted	0	517
Counting values with IF value? wester69	by Wester	5	441
count cells using multiple criteria kjguillermo	by T. Valko	1	608
how to convert numbers into words jigesh	by Paul B	1	853
Concatonate - can it be undone rita	by rita	3	384
Reading a worksheet from a specified workbook [email protected]	by Dave Peterson	1	462
Copying Conditional Formatting formulas pwsok	by Otto Moehrbach	1	931
Multiplication Danny Mac	by Danny Mac	8	643
Sumproduct ... Maybe? Ken	by Ken	5	524
Quickly moving rows of 5-column groups on 1 continuous line C.O.	by T. Valko	2	713
Turning rows of equal number of columns into 1 continuous row chimerical	by jlepack	1	683
How do I keep leading ZIPcode zeros from disappearing in Excel? Krabapple	by Gord Dibben	2	3,010
Opening Excel file on a specific worksheet sdhaight	by Dave Peterson	7	789
Calculating Time Karen	by bj	2	517
Does SQL.REQUEST not work for PostgreSQL? wc_marcos	by wc_marcos	0	518
count number of occurences on a particular date [email protected]	by jlepack	4	724
"#N/A" -- can I convert to a "0" (zero)? Branchie	by Gord Dibben	2	632
Trying to restore all default settings Aria Etriano	by Gord Dibben	1	1,632
Time in Minutes Karen	by David Biddulph	17	966
Excel Macros Kelvin9811	by Gary''s Student	1	360
%1 appears in "Application used to perform action" when trying to edit a file type [email protected]	by Ron Rosenfeld	3	2,485
Auto enter date when data in enter in another cell Brian	by Gord Dibben	5	1,875
VLookUp to extract data MD ENGINEER	by T. Valko	3	1,000
How can I make categories out of my data? NoviceinEXCEL	by Don Guillett	3	586
Adding error suppression to AVERAGE FUNCTION plb2862	by plb2862	3	748
change a string of numbers in to number format Debi	by Elkar	1	593
Changing to excel 2007 dpal	by dpal	2	739
Formula help with ordering quantity Angela	by Angela	8	1,509
I have 100 excel sheets how can I merge all data into one sheet Po	by Ron de Bruin	1	875