Excel Worksheet Functions - Page 708

Thread / Thread Starter	Last Post	Replies	Views
DP Auto increment [email protected]	by [email protected]	2	776
Formula help Craig	by Kevin Vaughn	2	339
How can I list worksheet tabs as a table of contents? aellorac	by Gord Dibben	3	440
Report choosing a Pivot table data Krish	by Debra Dalgleish	1	557
Pasting values from 2 colums into 1 on a seperate workbook? [email protected]	by Gord Dibben	2	440
Move a spreadsheet to an unopened workbook thegentree	by thegentree	0	393
How can data be summed for based on corresponding dates? Hunter	by raypayette	5	393
Using search when it returns #VALUE! IanMcGreene	by Niek Otten	1	439
How do I resolve a problem with sharing a workbook Carter	by Carter	0	581
How do I set a cell to auto expand when it has a formula? SriGog	by SriGog	5	582
Concatenating entire columns [email protected]	by Marcelo	2	433
repeat macro until empty space in next column Sabba Efie	by David Billigmeier	1	979
how to convert a column of numbers (monthdayyear) into dates? wsucougar	by wsucougar	5	995
vlookup and hlookup hotelmasters	by Toppers	4	892
Consolidation of dulpicate rows of data. Help Please	by David Bird	2	351
alphanumeric sorting Dhinakaran	by Dave F	1	544
Printing invoices Telephoneman	by Telephoneman	0	328
Popup boxes for dates? ribbons55	by ribbons55	0	399
Sum largest numbers based on condition Daniel Bonallack	by Biff	6	532
alternative to if statement dan	by Niek Otten	4	859
Mathematic problem solving using Excel Stonewall	by Stonewall	2	704
negative numbers raysa	by Dave	3	460
Text Color Change prompted by different columns NKDodd	by Bob Phillips	1	682
How can I change my column references from Alpha to Numeric? Danelle Boling, Sales Analyst	by PCLIVE	1	768
Excel 2003 is missing toolbar button select visible cells select visible cells	by David Billigmeier	1	1,280
Vlookup not Resolving PatK	by PatK	4	919
Excel should let you select 2 rows, right click, and SWAP them DG_Crewdson	by Jim Cone	3	1,011
Sumproduct Not Working Carl	by Marcelo	5	541
% query wally	by Biff	11	636
Compare Two Columns (Exact and Wildcard) Xavier	by Xavier	4	1,439
Sumproduct using dates Scopar	by Max	8	769
Searching a text string in a range of cells. heenanmc	by heenanmc	2	4,296
I need to understand how the IRR, NPV and FPV formulas work? Thks Juanmi	by Niek Otten	1	824
use concatenate function to put carrage returns in a text string dabblingandconfused	by Martha	4	868
no #VALUE! to printout garyww	by starguy	2	763
Calculate number of months between dates steph44haf	by Bob Phillips	1	975
Using seperate sets of radio buttons in one sheet Duster	by Duster	1	1,320
How do I match values in one spreadsheet to values in another? David	by David	2	1,301
Where in Office 2007 can I record a macro? Graeme	by Dave F	1	614
How to convert Kgs to Stns, Pds & Ozs FKBarnett	by Dave F	2	656
Convert from Excel to Software ? David	by Dave F	1	521
Overwriting prior formula Mark	by CLR	3	647
What happened to the Invoice Toolbar in Excel 2003? rbbuckfever	by rbbuckfever	0	609
How do I select the first cell of a filtered list? Shane Moore	by Bernie Deitrick	2	1,187
Enquiry Form Abidan	by Abidan	0	400
no #VALUE! to printout garyww	by Bondi	1	716
COUNTIF Slim	by Slim	8	463
MOre than 8 argurement wan	by wan	5	329
Rate function Professor Henn	by [email protected]	1	495
Filename from a Cell baridude	by Hurtige	7	719
color code a row by expiration date? kate	by Max	6	3,150
analysing sales vs price Vabu3184	by Dav	1	469
Use filename in cell to link data HughT	by HughT	2	452
Rank Function Andrew C	by Biff	1	672
validation list. Scroll to top when using, how? Corey	by Arvi Laanemets	4	424
Moving Related Fields Manager that needs help	by Manager that needs help	2	334
find two (2) lowest values in a range (Excel) Bob in Carson	by Biff	3	2,028
net present value Frank D	by Fred Smith	1	597
Closing files and saving files dan	by dan	0	549
Help with Random Functions CIL	by RagDyeR	6	505
eliminate repeat values from a list of ascending order norumbegan	by Max	5	966
random sample skimpw	by skimpw	0	678
if cell = no how to copy to another sheet oasisoflife	by Max	6	459
automatic table to table copy Sunny	by Max	3	520
Excel 2002 dropdown lists projectmgr	by Debra Dalgleish	2	970
Finding the average across multiple sheets quailhunter	by Fin Fang Foom	16	2,660
Removing characters Tomsriv	by MartinW	2	547
Concatenate values dan	by dan	2	531
Getting wrong values PW	by Niek Otten	5	552
Assigning consecutive dates Brooke	by Bob Phillips	14	1,032
Sum If Carl	by Bob Phillips	5	371
Ned Help W/ Custom Function japorms	by japorms	3	480
Index, Match or what??? John	by John	2	342
Benefit attendance calendar make 2 items .5 points not 1 pt shelian1	by shelian1	0	611
where can I find the "Calculated Field" in Office 2007 version? Bruno	by Bruno	0	756