Excel Worksheet Functions - Page 57

Thread / Thread Starter	Last Post	Replies	Views
Setting up an electrical register in Excel with expiry dates Scotty	by Mike H	1	957
directing cell contents dependent on its value Debi	by Mike H	2	662
Pulling/Collating Data chrisk	by chrisk	4	492
How I convert a numbers to tex --10 to ten Jesus	by ozgrid.com	5	617
How do I recover a forgotten password? Zmont	by macropod[_2_]	2	557
Validation list with formula? SaM	by Ashish Mathur[_2_]	3	1,451
Formula referencing a changing range?? Stacie2410	by T. Valko	3	755
compare -neg and +pos number that cancel each other in a column chom krusopon	by Casper	14	2,214
Relative Link remembers absolute path?? booker@mgt[_2_]	by Bill Snow	2	1,847
2 worksheets--3 questions Anne	by Bob Phillips[_4_]	3	535
Protecting Sheets with drop down boxes Dolores Gomez[_2_]	by Duke Carey	1	631
Excel 2003 - deleting Duplicates under conditions Cath	by Duke Carey	2	924
Changing Source Data using V-lookup Kevin	by Bernard Liengme[_2_]	2	1,186
data links on subsequent worksheets TerriK	by Duke Carey	2	497
Help needed with If & Today function Nemo	by Glenn	4	465
vlook up w- multiple variables chilitodd	by chilitodd	2	518
Auto Calculate Keeps Resetting to Manual Shirley	by Bernard Liengme[_2_]	2	1,642
invisible color cindyhosch	by lllorigirl	4	959
=INDEX(AF1:BD108,MATCH(Z3,AD2:AD361),AF:AR) excelrookie	by excelrookie	2	663
Help with function, not sure which one excelrookie	by excelrookie	4	485
If argument DonaMil	by Eduardo	1	404
General numbers lookup from FY-PP-WK-D resulting in MM-DD-YY Steve	by Steve Dunn	3	399
Nested IF(OR(AND) Statement with Two AND Conditions chiefs19	by chiefs19	5	1,303
consolidating data for a report - HELP - pivot tables no good for UKMAN	by UKMAN	0	495
using CountIF function or Array? AJ	by Bernard Liengme[_2_]	3	742
Sumproduct with sumif over mutiple worksheets Zeddie_Burger	by Eduardo	2	455
Vlookup and if formula edwin	by Jacob Skaria	2	619
CONVERT ROMAN TO ARABIC NUMERALS JOHN	by Ron Rosenfeld	7	3,377
Conditional Formatting based on match to external list Dawn Mann	by Steve Dunn	1	1,307
SumIf Debi	by Mike H	3	494
Vlookup & relative cell reference? Cecilia	by Jacob Skaria	2	1,464
Icon sets - conditional formatting - in Excel 2003 Lou	by ozgrid.com	1	1,974
Countif for finding a Time input Meebers[_4_]	by Meebers[_4_]	4	485
SUMIF Function Traci P.[_2_]	by Ashish Mathur[_2_]	2	540
Days in Text to Dates SPECIAL DOUG	by Ron Rosenfeld	1	529
How do i convert dates to text but keep the date format SallyP	by Gord Dibben	1	5,007
Find and Replace Pierre	by Tom Hutchins	4	407
Help Creating Excel Formula jamesvh	by jamesvh	4	735
changing formula Excel formula	by Excel formula	0	434
Can I use Sumproduct with the LEFT Function? Chris	by T. Valko	11	3,741
data validation using named range from another file pat67	by Gord Dibben	3	1,794
Counting with 2 criteria Amethyst	by Amethyst	3	399
row height issue Mike SoCal	by Gord Dibben	1	841
Average using Sumproduct Basenji	by Joe User[_2_]	4	3,948
Rounding Cynthia	by Cynthia	4	446
Change the weekends Sadad	by Mike H	1	427
Conditional IF formula using multi-dimensional arrays iperlovsky	by iperlovsky	2	674
How do I set NETWORKDAYS to regard friday and saturday as weekend Shay.C.	by Sadad	2	2,098
Date Diff - excluding working days Scott_goddard	by Rick Rothstein	2	1,149
Median with Criteria Demosthenes	by Demosthenes	2	2,049
Vendor List Andri	by Andri	7	731
ISNA VLOOKUP does not recognize 63023 Nain	by Dave Peterson	4	1,033
Adding totals from different columns Eskercat	by Ashish Mathur[_2_]	1	483
stock control template Gary L	by Eduardo	1	2,540
Auto-insert same value each Monday in cashflow worksheet? Scribble	by Scribble	0	690
Hyperlink won't open in excel JBrits	by JBrits	0	2,101
Combining text from multiple cells mgerken79	by Don Guillett[_2_]	6	978
Sum amount of days in another coloumn Scott_goddard	by Jacob Skaria	8	640
Array Formula Help Needed nelly	by nelly	5	513
Look for Min and second Min Elton Law[_2_]	by Steve Dunn	13	1,473
Removing multiple duplicate events Father John	by Ron Rosenfeld	10	873
Help with formula Brandon	by Stefi	1	513
Empty Cell Result Mike H.	by Grimwadec	8	555
Unable to set the FormulaArrary property of the range class RTK	by RTK	0	651
visible cell only Brad Autry	by T. Valko	1	717
Conditional formatting with expired dates after current Josh	by Max	1	1,455
I want to add formulas from multiple sheets to master form snake941	by Fred Smith[_4_]	1	607
vlookup and match first value greater than MPI Planner[_2_]	by Teethless mama	4	4,770
Non-contiguous range and Sumproduct to average Mifty	by T. Valko	5	1,899
Invoice: customer database and billing information Nic Daniels	by JLatham	3	1,637
excel formula Brian	by T. Valko	6	479
Sum VLOOKUP? andyoftheg	by Ashish Mathur[_2_]	4	1,770
Ignore Hidden Rows and Count of distinct values Anuma (GGK Tech)	by Ashish Mathur[_2_]	3	1,747
Duplicates formula Soth	by Ashish Mathur[_2_]	5	467
Averaging many non-contiguous cells if they are blank Nadine	by macropod[_2_]	1	766