Excel Worksheet Functions - Page 35

Thread / Thread Starter	Last Post	Replies	Views
IF statement inside a SUMIF statement.... or alternative method Sungibungi	by Paul C	3	3,112
Vlookup return a ROW of data thecdnmole	by Alan Beban[_2_]	3	3,112
Pivot table show all days of a month even if no data Elan lent	by Herbert Seidenberg	2	3,111
Pick up some text in a cell Elton Law[_2_]	by Teethless mama	9	3,111
Please put a remittance advice template online gistmei	by gistmei	0	3,110
Vlookup, return zero if not found molsansk	by Carim	2	3,110
Formula returning current user name TBoeck	by Dennis in Indy	5	3,110
Countif to ignore any errors	by [email protected]	4	3,110
sum cells based on another cell value Anauna	by	3	3,109
Vlookup, Column Index Num and Autofill mp	by T. Valko	9	3,108
Vlookup from 2 different sheets WorkerBee	by Ken Wright	20	3,108
Creating drop downs for part number configuration Peter	by Peter	2	3,108
Count cells with the red color Collcat	by Frank Kabel	1	3,107
excel-custom format using inches symbol (") nannieree	by JE McGimpsey	1	3,107
My excel formula is correct, however, my total is off by .01. scotton	by Niek Otten	1	3,106
Find AVG/MIN of a Column, excluding 0's and NULL's? JT	by Harlan Grove	3	3,103
Counting cells that don't contain certain text JRD	by Domenic	4	3,103
Removing duplicate records based off of date Jen_T	by Herbert Seidenberg	3	3,103
Counting blank cells until value is reached Dan	by Dan	9	3,103
Blank cells: ISBLANK = FALSE, ISTEXT = TRUE Raj[_2_]	by joeu2004	3	3,103
formula to roundup to the nearest 9 susiegirl	by Epinn	8	3,101
Can I link/lock rows so they move together in a sort? dla80	by Jock	1	3,101
Golf Formula aussiemike	by Gary''s Student	2	3,100
How to copy rows that meet criteria to another sheet in Excel Bruce	by Ron Coderre	9	3,098
Reverse PRICE function ingmar	by John C[_2_]	32	3,098
Extract multiple records matching criteria from list William DeLeo	by William DeLeo	12	3,097
color code a row by expiration date? kate	by Max	6	3,097
Disable/ignore compatibility check during SaveAs [email protected]	by Edgar Estrada	2	3,097
Can I write an excel formula to display the file save date? Bob-123456789	by Gord Dibben	1	3,096
Calculate next workday after adding calendar days to date in cell Darrell[_2_]	by Chip Pearson	13	3,096
Save Random Number Paul B.	by jester23423	5	3,096
Add excel horizontal & vertical ruler snbahri	by flipnfly8	8	3,095
Birthdate 01/01/2000 Remove Slashes Sprowler	by Sprowler	3	3,094
XNPV vs. NPV(quarterly) different results magis	by [email protected]	3	3,093
Vlookup using a partial text match JGROVE	by Teethless mama	1	3,093
Conditional Formatting Driving Me Crazy Cactus1993[_2_]	by T. Valko	2	3,093
How do I round a number to the nearest .49 in a cell that has a fo Butrcup624	by T. Valko	5	3,092
Date-dependent calculation Steve O'Donnell	by Toppers	2	3,092
Excell Check Digit Formula tnelson	by Ian	1	3,092
Need a formula to determine if date falls within a date range then Corca	by Ashish Mathur[_2_]	2	3,090
How do I change the cursor or outline color in excel 2007? Lady J	by Lady J	0	3,089
Opening an .mdb file in Excel lehigh46	by ryguy7272	2	3,089
Calculating Percentage Rent Paul S	by Paul S	4	3,089
Set fixed Decimal places with no rounding azza	by azza	4	3,088
XIRR versus IRR help! Seth M	by JoeU2004	6	3,088
How do you easily add rows to check register template mrboard	by Joel	1	3,088
Force function to show positive or negative number? smoore	by smoore	3	3,087
VLOOKUP/Index&Match data format issue [email protected]	by Allan[_2_]	3	3,086
Excel COUNTIF Function - a range as criteria ? joes	by Bob Phillips	2	3,086
How can I make Excel automatically count down the date? Jason Wong	by OssieMac	1	3,086
Month Year Date Format Jamie	by Arvi Laanemets	2	3,085
Excel 97 - Adding Every 8th Row - Formula should work, but doesn't Damaeus	by Tushar Mehta	12	3,085
calculate month from week number ankman	by bveara	2	3,084
Limit or Exclude cells in Average and Sum formula dagger	by swatsp0p	3	3,084
How do I ignore cells with errors when calculating an average? M Enfroy	by M Enfroy	6	3,083
Create a credit (negative) column in Excel? AvonSue	by Gord Dibben[_2_]	6	3,082
Adding up number of yes, no, maybes in a column JRD	by JRD	2	3,082
Error of slope taking into account error of the data points cer144	by Pete_UK	5	3,081
I want to show only the first three columns Padre310	by Rick Rothstein	3	3,081
Comparing dates from VLOOKUP functions not working right Sambonator	by Max	2	3,081
How do I turn off format painter so it doesn't keep popping up? mcandrj	by Saylees	4	3,080
sumif to aggregate month to quarter renegade	by Stefi	16	3,078
TEXT function to format a date in English & French IanC	by IanC	2	3,077
VLOOKUP dragging down Ozlem	by tjtjjtjt	3	3,076
Excel template for daily compound interest varying monthly paymen Peter	by joeu2004	1	3,076
Excel 2003: Swap or flip or rotate rows and columns (instructions didn't work) BJ Martens	by Mazzaropi	1	3,075
Predicting a Number From a Time Series Carl	by [email protected]	4	3,075
Formatting negative percent Tschurin	by Peter H6	12	3,074
Excel template for youth softball statistics Sharon L. Hull	by John[_22_]	1	3,072
how do i get zeros to show after decimal point? gwreed	by David Biddulph[_2_]	2	3,071
lookup multiple occurrences of a value excel ckl	by Ragdyer	5	3,071
difference between two dates in years, months and days. ruby	by Duke Carey	2	3,071
How do I calcuate an IC50 from analyze it? jc33	by Dave Peterson	4	3,071
How do I reverse the order (sequence) of a column of data in Excel Ken Hardman	by Max	5	3,071
Password protect cells PivotTable & allow the Pivot Table to refre KJThams	by KJThams	2	3,070