Excel Worksheet Functions - Page 31

Thread / Thread Starter	Last Post	Replies	Views
Extract Month and year from Cell containing date, month, year & time Montenegro Mick	by Ron Rosenfeld[_2_]	2	5,423
Using the IF and IFBLANK functions Superjase14	by Superjase14	3	778
If or VLookup function wererich	by Mazzaropi	4	719
How may I lookup and return a value between two numbers HGJ	by Mazzaropi	3	914
Allocate an income payment over a date range (tax years) Stephen[_26_]	by Stephen[_26_]	7	783
VLookup Won't Copy down (#REF! error) kristawoods	by GS[_2_]	2	1,837
Count if data falls within a range AND that has a certain criteria LaVitaEBella	by Claus Busch	1	894
Applying a formula to multiple values within a single cell? Alecj	by Alecj	2	1,138
End Date/Time adding business hours laya1024	by Vacuum Sealed	1	794
View sheet from another excel file? ahmed hassaan	by ahmed hassaan	0	638
Function to establish mortgage bond size. [email protected]	by PJ Hooker	2	633
Need to know give matrixes a name... elvagonumero1	by GS[_2_]	1	489
I need to add spaces to the beginning of my texts which are numbers Demetria Jones	by Gord Dibben[_2_]	1	607
checking for value in matrix Pamanabh	by Pamanabh	0	468
date/time formula briandel7	by Spencer101	1	524
Longtitude and Latitude Question Mastermind4real	by cubbybear3	5	1,104
search cell for specific text. vonsharkel	by GS[_2_]	1	745
drop down list and Locking certain cells Dpman23	by Dpman23	0	754
Change the colour of a cell if another named cell is blank LISAISAAC	by Gord Dibben[_2_]	2	1,251
Formula for multiple rows of same value... [email protected]	by Don Guillett[_2_]	4	1,528
Converting EST to PST neilalan	by _VINYL	4	4,659
Sheet and formatting programming dilexcel	by dilexcel	0	460
Lookup value across multiple columns and rows ImagineActuality	by ImagineActuality	0	986
check if or not time lies between a time interval Jaspreet281	by joeu2004[_2_]	4	756
count unique values with auto-filter on Francisco Rodriguez[_2_]	by giuval	4	2,206
Conditinal formatting blank output cell Nicholsonz	by Vacuum Sealed	1	522
How to separate text and numbers in one cell or column? novastar	by Bibhu Bag	13	3,337
Conditional formatting code Jwalters	by Gord Dibben[_2_]	1	702
I can't input anything I type on Excel. What can I do? Nothing p. nakalkn	by PersonHere	2	4,472
Excel Formula or VBA Code jsenglish11	by jsenglish11	2	671
attempting complicated IF comparison with end goal easy for future users ALRFman	by GS[_2_]	1	515
Conditional Formatting Less Than Today Week Days only Hippo	by Mazzaropi	1	1,154
Finding average of top 70% of the values pallavi	by Mazzaropi	1	842
Count Column B if Column A is within a multiple specificed ranges Chris Urban	by Chris Urban	2	639
check if or not time lies between a time interval Jaspreet281	by Jaspreet281	0	486
Nested subtotals in incorrect order on large worksheets 'Wyn	by Robert Lyons	2	1,154
Percentile on Aggregate data with multiple criteria Chris Burgh	by Chris Burgh	0	1,174
COUNT IF with unconditional AND on cell dates Aramazd	by isabelle	5	966
Lookup Function help Yunus	by Yunus	1	549
INDIRET fill marygo	by Don Guillett[_2_]	2	585
Naming cells Louja[_2_]	by Louja[_2_]	4	585
How do I unhide a row when ENTER is pressed in a certain cell? Saucer Man	by GS[_2_]	6	736
Color a cell based on column date and row content Denton Edwards	by Denton Edwards	2	768
IF statement with 2 logicals hensleyj	by Ron Rosenfeld[_2_]	1	821
calculating times montypython	by Spencer101	1	580
Formula for looking up and copying from another worksheet? tmorefi	by isabelle	1	652
how to link horizontal data to vertical cells in a new sheet sinoxolo	by isabelle	1	5,306
Data validation help Louja[_2_]	by Louja[_2_]	0	517
Changing cell content on n auto-filtered column Colin Hayes	by Colin Hayes	4	636
Function to establish the mortgage bond based on a monthly payment [email protected]	by [email protected]	0	465
VLOOKUP worksheet function returns zero for empty cells Hershmab	by Aidan Gould	4	3,410
Conditional Formatting Conundrum Suedonym	by GS[_2_]	3	614
Adding Periods at Specified intervals ddefina	by GS[_2_]	7	775
Printing "Freeze Panes" sh2195	by j B	3	2,598
Yield to Maturity W	by joeu2004[_2_]	11	3,271
How to reverse sign? Chips	by Spencer101	6	2,675
Adding days to a date - changed in Excel 2010 Robinsg	by joeu2004[_2_]	9	2,340
IF function limitation Srinivas Sharma	by Srinivas Sharma	0	477
Populating entire rows of data from a master sheet? Agrajag	by WallyWallWhackr	4	1,130
Conditional Formatting Dorian74	by Dorian74	9	742
Inserting a string in a cell reference Joao Andre	by Don Guillett[_2_]	2	682
CTRL SHIFT ENTER Yunus	by Yunus	2	1,855
Determine Resource Allocations by evaluating available time and required time. DieselDork	by DieselDork	4	1,166
countif fzl2007	by isabelle	2	567
countif fzl2007	by isabelle	1	499
If, And Or Nick_GB	by Nick_GB	3	590
Countif between Time stamps and have - value akmazaini	by Spencer101	1	2,125
Data Validation jgeekw	by Vacuum Sealed	1	472
HELP: IF Statement between Dates for Reverse Index failing Yunus	by Yunus	0	569
Excel import from PeopleSoft; formulas dont work AnaInMiami72	by Don Guillett[_2_]	1	806
word count in Excel Help Needed 2	by listings	3	1,148
Match function: error due to format? via sarpi	by isabelle	4	837
Match and Populate burntorange	by burntorange	1	558
error message "#VALUE!" due to blank cells Dorian74	by joeu2004[_2_]	5	1,392
Auto Filter Multiple Criteria Steve[_122_]	by Don Guillett[_2_]	1	784