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,424
Using the IF and IFBLANK functions Superjase14	by Superjase14	3	794
If or VLookup function wererich	by Mazzaropi	4	729
How may I lookup and return a value between two numbers HGJ	by Mazzaropi	3	931
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,851
Count if data falls within a range AND that has a certain criteria LaVitaEBella	by Claus Busch	1	905
Applying a formula to multiple values within a single cell? Alecj	by Alecj	2	1,149
End Date/Time adding business hours laya1024	by Vacuum Sealed	1	808
View sheet from another excel file? ahmed hassaan	by ahmed hassaan	0	644
Function to establish mortgage bond size. [email protected]	by PJ Hooker	2	634
Need to know give matrixes a name... elvagonumero1	by GS[_2_]	1	498
I need to add spaces to the beginning of my texts which are numbers Demetria Jones	by Gord Dibben[_2_]	1	621
checking for value in matrix Pamanabh	by Pamanabh	0	478
date/time formula briandel7	by Spencer101	1	530
Longtitude and Latitude Question Mastermind4real	by cubbybear3	5	1,107
search cell for specific text. vonsharkel	by GS[_2_]	1	755
drop down list and Locking certain cells Dpman23	by Dpman23	0	764
Change the colour of a cell if another named cell is blank LISAISAAC	by Gord Dibben[_2_]	2	1,252
Formula for multiple rows of same value... [email protected]	by Don Guillett[_2_]	4	1,544
Converting EST to PST neilalan	by _VINYL	4	4,660
Sheet and formatting programming dilexcel	by dilexcel	0	470
Lookup value across multiple columns and rows ImagineActuality	by ImagineActuality	0	996
check if or not time lies between a time interval Jaspreet281	by joeu2004[_2_]	4	772
count unique values with auto-filter on Francisco Rodriguez[_2_]	by giuval	4	2,220
Conditinal formatting blank output cell Nicholsonz	by Vacuum Sealed	1	536
How to separate text and numbers in one cell or column? novastar	by Bibhu Bag	13	3,348
Conditional formatting code Jwalters	by Gord Dibben[_2_]	1	715
I can't input anything I type on Excel. What can I do? Nothing p. nakalkn	by PersonHere	2	4,481
Excel Formula or VBA Code jsenglish11	by jsenglish11	2	683
attempting complicated IF comparison with end goal easy for future users ALRFman	by GS[_2_]	1	526
Conditional Formatting Less Than Today Week Days only Hippo	by Mazzaropi	1	1,169
Finding average of top 70% of the values pallavi	by Mazzaropi	1	848
Count Column B if Column A is within a multiple specificed ranges Chris Urban	by Chris Urban	2	655
check if or not time lies between a time interval Jaspreet281	by Jaspreet281	0	495
Nested subtotals in incorrect order on large worksheets 'Wyn	by Robert Lyons	2	1,155
Percentile on Aggregate data with multiple criteria Chris Burgh	by Chris Burgh	0	1,184
COUNT IF with unconditional AND on cell dates Aramazd	by isabelle	5	974
Lookup Function help Yunus	by Yunus	1	559
INDIRET fill marygo	by Don Guillett[_2_]	2	592
Naming cells Louja[_2_]	by Louja[_2_]	4	595
How do I unhide a row when ENTER is pressed in a certain cell? Saucer Man	by GS[_2_]	6	749
Color a cell based on column date and row content Denton Edwards	by Denton Edwards	2	781
IF statement with 2 logicals hensleyj	by Ron Rosenfeld[_2_]	1	824
calculating times montypython	by Spencer101	1	585
Formula for looking up and copying from another worksheet? tmorefi	by isabelle	1	653
how to link horizontal data to vertical cells in a new sheet sinoxolo	by isabelle	1	5,315
Data validation help Louja[_2_]	by Louja[_2_]	0	527
Changing cell content on n auto-filtered column Colin Hayes	by Colin Hayes	4	637
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,417
Conditional Formatting Conundrum Suedonym	by GS[_2_]	3	627
Adding Periods at Specified intervals ddefina	by GS[_2_]	7	789
Printing "Freeze Panes" sh2195	by j B	3	2,599
Yield to Maturity W	by joeu2004[_2_]	11	3,276
How to reverse sign? Chips	by Spencer101	6	2,684
Adding days to a date - changed in Excel 2010 Robinsg	by joeu2004[_2_]	9	2,354
IF function limitation Srinivas Sharma	by Srinivas Sharma	0	488
Populating entire rows of data from a master sheet? Agrajag	by WallyWallWhackr	4	1,145
Conditional Formatting Dorian74	by Dorian74	9	779
Inserting a string in a cell reference Joao Andre	by Don Guillett[_2_]	2	694
CTRL SHIFT ENTER Yunus	by Yunus	2	1,864
Determine Resource Allocations by evaluating available time and required time. DieselDork	by DieselDork	4	1,181
countif fzl2007	by isabelle	2	577
countif fzl2007	by isabelle	1	509
If, And Or Nick_GB	by Nick_GB	3	603
Countif between Time stamps and have - value akmazaini	by Spencer101	1	2,130
Data Validation jgeekw	by Vacuum Sealed	1	482
HELP: IF Statement between Dates for Reverse Index failing Yunus	by Yunus	0	577
Excel import from PeopleSoft; formulas dont work AnaInMiami72	by Don Guillett[_2_]	1	816
word count in Excel Help Needed 2	by listings	3	1,161
Match function: error due to format? via sarpi	by isabelle	4	847
Match and Populate burntorange	by burntorange	1	565
error message "#VALUE!" due to blank cells Dorian74	by joeu2004[_2_]	5	1,404
Auto Filter Multiple Criteria Steve[_122_]	by Don Guillett[_2_]	1	797