Excel Worksheet Functions - Page 1127

Thread / Thread Starter	Last Post	Replies	Views
Median with Criteria Demosthenes	by Demosthenes	2	2,044
Date Diff - excluding working days Scott_goddard	by Rick Rothstein	2	1,141
How do I set NETWORKDAYS to regard friday and saturday as weekend Shay.C.	by Sadad	2	2,089
Conditional IF formula using multi-dimensional arrays iperlovsky	by iperlovsky	2	661
Change the weekends Sadad	by Mike H	1	421
Rounding Cynthia	by Cynthia	4	441
Average using Sumproduct Basenji	by Joe User[_2_]	4	3,943
row height issue Mike SoCal	by Gord Dibben	1	832
Counting with 2 criteria Amethyst	by Amethyst	3	393
data validation using named range from another file pat67	by Gord Dibben	3	1,765
Can I use Sumproduct with the LEFT Function? Chris	by T. Valko	11	3,660
changing formula Excel formula	by Excel formula	0	417
Help Creating Excel Formula jamesvh	by jamesvh	4	730
Find and Replace Pierre	by Tom Hutchins	4	398
How do i convert dates to text but keep the date format SallyP	by Gord Dibben	1	4,992
Days in Text to Dates SPECIAL DOUG	by Ron Rosenfeld	1	519
SUMIF Function Traci P.[_2_]	by Ashish Mathur[_2_]	2	535
Countif for finding a Time input Meebers[_4_]	by Meebers[_4_]	4	478
Icon sets - conditional formatting - in Excel 2003 Lou	by ozgrid.com	1	1,964
Vlookup & relative cell reference? Cecilia	by Jacob Skaria	2	1,451
SumIf Debi	by Mike H	3	490
Conditional Formatting based on match to external list Dawn Mann	by Steve Dunn	1	1,272
CONVERT ROMAN TO ARABIC NUMERALS JOHN	by Ron Rosenfeld	7	3,320
Vlookup and if formula edwin	by Jacob Skaria	2	613
Sumproduct with sumif over mutiple worksheets Zeddie_Burger	by Eduardo	2	450
using CountIF function or Array? AJ	by Bernard Liengme[_2_]	3	708
consolidating data for a report - HELP - pivot tables no good for UKMAN	by UKMAN	0	481
Nested IF(OR(AND) Statement with Two AND Conditions chiefs19	by chiefs19	5	1,297
General numbers lookup from FY-PP-WK-D resulting in MM-DD-YY Steve	by Steve Dunn	3	393
If argument DonaMil	by Eduardo	1	389
Help with function, not sure which one excelrookie	by excelrookie	4	427
=INDEX(AF1:BD108,MATCH(Z3,AD2:AD361),AF:AR) excelrookie	by excelrookie	2	657
invisible color cindyhosch	by lllorigirl	4	947
Auto Calculate Keeps Resetting to Manual Shirley	by Bernard Liengme[_2_]	2	1,633
vlook up w- multiple variables chilitodd	by chilitodd	2	506
Help needed with If & Today function Nemo	by Glenn	4	461
data links on subsequent worksheets TerriK	by Duke Carey	2	492
Changing Source Data using V-lookup Kevin	by Bernard Liengme[_2_]	2	1,176
Excel 2003 - deleting Duplicates under conditions Cath	by Duke Carey	2	906
Protecting Sheets with drop down boxes Dolores Gomez[_2_]	by Duke Carey	1	627
2 worksheets--3 questions Anne	by Bob Phillips[_4_]	3	516
Relative Link remembers absolute path?? booker@mgt[_2_]	by Bill Snow	2	1,830
compare -neg and +pos number that cancel each other in a column chom krusopon	by Casper	14	2,205
Formula referencing a changing range?? Stacie2410	by T. Valko	3	740
Validation list with formula? SaM	by Ashish Mathur[_2_]	3	1,441
How do I recover a forgotten password? Zmont	by macropod[_2_]	2	551
How I convert a numbers to tex --10 to ten Jesus	by ozgrid.com	5	604
Pulling/Collating Data chrisk	by chrisk	4	483
directing cell contents dependent on its value Debi	by Mike H	2	654
Setting up an electrical register in Excel with expiry dates Scotty	by Mike H	1	934
Filldown starting from F2 instead of F1 Ephraim	by Ephraim	5	588
Can I combine a Vlookup with an IF formula? Claire[_2_]	by Duke Carey	2	689
Sumif with multiple sum ranges in a sheet MA	by Teethless mama	4	5,448
Adding a value to a customer ID? Anne	by Bernard Liengme[_2_]	4	671
multiple dependent drop down lists Mikej	by Mikej	6	3,608
Directing cell contents to one of two cells dependent on its value Debi	by Gary''s Student	1	661
Countif/SumProduct excelllllllll	by excelllllllll	4	339
how do I import data in excel form SQL server? Mitch	by Duke Carey	7	1,359
Convert percentage into margin Linda	by Bernard Liengme[_2_]	2	1,566
Show time as a negative figure JCR1987	by Hans Terkelsen	3	1,725
Excel IF Formulas mgreen-NJ	by mgreen-NJ[_2_]	2	425
Ad-In Rowliner Eurika Stemmet	by Gord Dibben	4	1,305
pounds shillings pence format in excel peter	by Bernard Liengme[_2_]	2	2,286
Rounding Up question spreadsheetlady	by Mike H	2	471
Help with If Sum statement - i think.... Scott_goddard	by Duke Carey	4	438
#N/A help please cadustin	by Duke Carey	2	554
Sort Brandon	by Tom Hutchins	2	576
Compare 1 cell to column of cells returning adjacent cells info? Mr. Fine	by Duke Carey	1	4,771
Add no. of days to a workday to get new workday? blswes	by Duke Carey	1	589
Add values based on text color with the criteria of a date Peter Gonzalez[_2_]	by Peter Gonzalez[_2_]	7	655
rounded # to correct # Wagnerk	by David Biddulph[_2_]	4	451
Standard deviation and bell curve Meebers[_4_]	by Meebers[_4_]	0	753
Can excel data be encrypted? Confused	by Joe User[_2_]	1	461
Need function to return numbers at beginning of text Nadine	by T. Valko	2	551
spreadsheet Ben Rivera	by CLR	1	400