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	573
Copy - Paste Special problem Bob Smith	by Bob Smith	2	488
Mapping values from an index!!?? HELP! BCBS_exceller	by JMB	3	465
How do I build a Construction Schedule of Values in Excel? Caleb Howze	by Martin Fishlock	1	5,690
How can I add times, i.e., 1:45:30 + 2:10:20? wahjazz	by Fred Smith	2	336
EXCEL: MOD FUNCTION or DIVISION NAIMA	by Max	6	1,453
Calculating overlapping time periods Arlette	by Arlette	0	709
Array formula referencing other worksheets broderp	by Dave F	1	470
Ignore Data for Dynamic Range Dale	by Dale	1	494
Counting Question rlee1999	by Duke Carey	7	435
sumproduct RGlade	by RGlade	3	367
macro or if statement CHARI	by CHARI	2	554
Multiple SUMIF Krish	by Don Guillett	1	344
Counting Words In Excel Formula dayd	by John Bundy	1	386
matrix multiplication for labor costs [email protected]	by [email protected]	0	791
To project inventory rundown and forecast Bob	by John Bundy	1	1,235
Row numbers containing specific value within a column carl43m	by Ron Coderre	15	962
Totaling contributions Jack Taylor	by John Bundy	1	414
how do I remove both duplicate records in excel Mtgdbsmgr	by Duke Carey	1	490
yield of a security Securities Auditor	by Duke Carey	1	561
need help creating formula [email protected]	by [email protected]	2	439
converting text to number Julio	by John Bundy	1	396
Return Column sign - PLEASE HELP Nir	by Roger Govier	1	408
finding one value by combining many Trandall37	by Bernie Deitrick	1	364
Counting Marked Cells Fred Atkinson	by Fred Atkinson	3	1,460
Create a funktion Jenna	by Jenna	2	446
Copying Excel formulas between sheets Hoz	by frankjh19701	2	1,127
How to find and replace all "*" symbols Roger	by Ron Coderre	3	748
Error message: "cannot shift object off sheet" Peter Vickers	by Dave Peterson	4	1,285
Don't know what to call the type of function I need Kasey	by Kasey	4	705
Macro Formula for Max value El Bee	by Gary''s Student	4	803
VLOOKUP steph44haf	by Alicia	6	439
PMT Function Ashley	by Bernie Deitrick	2	380
combo reference on another combo box for picking address etc. kbjin	by Ron Coderre	1	991
Date function Pasty	by Pasty	4	396
Advanced IF statement / LOOKUP Jane	by Jane	4	565
Conditional Formatting Green-shutters	by Bob Phillips	2	296
dates Susie	by Dave F	1	298
Calculate the number of days between two dates,missing weekends? littlejess22	by Dave F	2	1,378
LEADING ZEROS IN FORMULA RESULT Advent	by Advent	4	878
variable text value within string formula required to sum column Tester	by CLR	2	640
Creating a formula JMP	by Nick Hodge	2	414
Numbers Converted to Text - Last Digit Replaced by Zero Cheryl B.	by Ron Rosenfeld	18	2,362
help in formatting cells [email protected]	by Bob Phillips	1	360
convert second to date and time --== Alain ==--	by Bob Phillips	4	731
Cannot enter 0% into a cell Louise	by Louise	3	523
merging info from different tabs Ted	by Ted	0	495
Counting values with IF value? wester69	by Wester	5	433
count cells using multiple criteria kjguillermo	by T. Valko	1	584
how to convert numbers into words jigesh	by Paul B	1	833
Concatonate - can it be undone rita	by rita	3	374
Reading a worksheet from a specified workbook [email protected]	by Dave Peterson	1	451
Copying Conditional Formatting formulas pwsok	by Otto Moehrbach	1	906
Multiplication Danny Mac	by Danny Mac	8	610
Sumproduct ... Maybe? Ken	by Ken	5	503
Quickly moving rows of 5-column groups on 1 continuous line C.O.	by T. Valko	2	684
Turning rows of equal number of columns into 1 continuous row chimerical	by jlepack	1	649
How do I keep leading ZIPcode zeros from disappearing in Excel? Krabapple	by Gord Dibben	2	2,958
Opening Excel file on a specific worksheet sdhaight	by Dave Peterson	7	776
Calculating Time Karen	by bj	2	508
Does SQL.REQUEST not work for PostgreSQL? wc_marcos	by wc_marcos	0	509
count number of occurences on a particular date [email protected]	by jlepack	4	698
"#N/A" -- can I convert to a "0" (zero)? Branchie	by Gord Dibben	2	620
Trying to restore all default settings Aria Etriano	by Gord Dibben	1	1,614
Time in Minutes Karen	by David Biddulph	17	958
Excel Macros Kelvin9811	by Gary''s Student	1	358
%1 appears in "Application used to perform action" when trying to edit a file type [email protected]	by Ron Rosenfeld	3	2,449
Auto enter date when data in enter in another cell Brian	by Gord Dibben	5	1,732
VLookUp to extract data MD ENGINEER	by T. Valko	3	989
How can I make categories out of my data? NoviceinEXCEL	by Don Guillett	3	569
Adding error suppression to AVERAGE FUNCTION plb2862	by plb2862	3	726
change a string of numbers in to number format Debi	by Elkar	1	561
Changing to excel 2007 dpal	by dpal	2	683
Formula help with ordering quantity Angela	by Angela	8	1,476
I have 100 excel sheets how can I merge all data into one sheet Po	by Ron de Bruin	1	860