Excel Worksheet Functions - Page 630

Thread / Thread Starter	Last Post	Replies	Views
Figuring Vacation Hrs. Earned using Current Date minus Hire Date Sharon	by BoniM	6	2,113
table lookup with two inputs one output cobra_charlie	by cobra_charlie[_2_]	3	1,348
Copy/Fill cell values in a column ReportSmith	by Gord Dibben	3	398
index match 2 rows 1 col denise	by denise	0	527
Formula Question casdaq	by casdaq	0	387
Creating a Macro For Shading Rows - Or Should I Use Conditional Formatting? [email protected]	by Michael M	3	583
pivot table field settings % of... Colin Funk	by Colin Funk	0	799
What formulae to derive? Jeffrey	by Don Guillett	1	428
Macros Sandy	by Sandy	6	336
number to time Stan Halls	by Pete_UK	6	361
How do I move the expand/collapse for rows and columns in Excel? JP	by JP	0	897
In XLS, how do IF stmt for IF a date is after another date...? wiggledg	by Dave Peterson	5	989
Decimal Place Rounding Aaron	by Aaron	4	520
School teacher needs help! Need to filter all columns, not just o Steve	by Fred Smith	2	334
Time sheet Ed Davis	by T. Valko	2	304
Lookup Eric	by Max	3	267
Paste Special Sharron	by Gord Dibben	1	442
Formulas instead of VBA joesf16	by joesf16	2	341
Help with IF statements Lil	by Lil	0	337
Drop down lists Carrie	by shail	4	352
Dynamic Range bony_tony	by bony_tony	4	330
Zero values to show blank Louise	by Arvi Laanemets	9	478
Merge command not active Stilla	by Roger Govier	1	471
SUMIF DaveMoore	by DaveMoore	2	296
Formula Help with Lists TN.Jim	by kate	5	378
Find duplicate rows then deleting them SSHO_99	by Rayvaz	4	1,219
countif, sumif, or whatever - counitg just some psecific values [email protected]	by BoniM	2	466
Vlookup multiple value deen	by Sriram	5	383
counta if iserror Bruce	by Teethless mama	1	418
How do I calculate NPV of perpetual annuity. Kalsang	by bpeltzer	1	4,368
How do I convert Roman numerals to Arabic (reverse of ROMAN)? IanW[_2_]	by Ron Rosenfeld	5	4,399
Security level of protected sheets bony_tony	by Dave Peterson	2	399
cumulitive totals and FILTER Laura	by Mike H	1	423
Calulating week # & Day # bj[_2_]	by andy62	2	417
square cubic Dreamstar_1961	by bj	1	439
Counting populated cells in another worksheet Fox via OfficeKB.com	by Fox via OfficeKB.com	0	706
THe Last DATE of the previous month from today CmK	by Philip J Smith	6	706
blank cells are treated as zeros how do I stop that Jez	by Jez	4	590
combine Vlookup with the Right function Harold Good	by Ron Coderre	3	1,528
Find and replace with a tick JDavidson	by Bernie Deitrick	1	574
Macro Modification carl	by carl	0	431
Copy across row alpha - not numeric. laralea	by Roger Govier	5	382
Altered Column Width No Name	by Harlan Grove[_2_]	2	357
Number to Text Bank Analyst	by Bernd	3	423
Connection between size and complexity emilija	by dq	3	359
Pivot tables and grouping words that are both upper and lower case Abdullah	by dq	1	878
how do i shade all identical cells automatically eve	by Gord Dibben	4	743
Merge Workbooks command not active Stilla	by dq	1	1,425
How do I convert a percent number, for example, 12.34%, to text? joeZy	by Bernard Liengme	1	661
Klick button for [F9] function Espen Rostad	by Gord Dibben	2	717
I need to change the Excel Header and Footer margins to match the Training Goddess	by Gord Dibben	2	2,022
Insert Full Path Roxy	by Gord Dibben	4	529
Need Destination cell to ref origin cell, but w/ many variables..H Ms.shopalot	by Billy Liddel	4	510
margin of error formula IC Data	by bj	3	4,310
Can one conditionally format a WS to leave everyother row blank? Drew	by Gord Dibben	2	385
Problem with Text to Speak [email protected]	by Billy Liddel	1	440
What is wrong with my Post? mman493	by mman493	5	430
count unique entries across worksheets globetrotter	by bj	6	669
Using a hyperlink to backup Excel files Colin Hayes	by Colin Hayes	7	694
using vlookup for a range of cells mmpfa07	by T. Valko	2	812
Excel quits unexpectedly Simon Brown	by Gord Dibben	1	654
subtotaling every third row? [email protected]	by Roger Govier	4	523
COUNT entire row [email protected]	by Roger Govier	4	412
Cant get dynamic range formula to work. Mike K	by Mike K	2	504
excel spreadsheet print functions [email protected]	by Gord Dibben	1	391
formula issues adella40	by Gord Dibben	2	459
Conditional formatting numbers inputted to bold tmjt21	by tmjt21	2	460
Cell reference in comparison formula E2out	by Elkar	1	383
microsoft works spreadsheet [email protected]	by Gord Dibben	2	346
Finding/Listing Symbols from 2 Columns Manfred	by Ron Coderre	1	372
How do I delete a partial worksheet? Crisco Kid	by Gord Dibben	1	352
challenge! - match/index/lookup with multiple criteria laststraw	by T. Valko	2	733
Count No Name	by T. Valko	9	462
Removing spaces at the end of numbers Chris T.	by Peo Sjoblom	5	2,424
formula which can convert amount in figures to amt in words sand	by Stan Brown	1	2,197