General

Don't Count Duplicates
Here's a subset of 3 colunms of data: Zip Code Name County 42125 John Franklin 42156 John Fairfield 43123 Bill Fairfield 45612 Jane Fairfield 45126 Jane Franklin 49856 Jane Fairfield 45895 Chris Fairfil... 24 Apr 2010 13:54

2003 PIvotTable Calculated Fields
Simple question...Can you use an If function in a PivotTables formulas (Calculated Field)? If so can you provide an example for syntax purposes. Thank you! ... 24 Apr 2010 13:54

What keyboard keys for to increse font size?
... 24 Apr 2010 11:40

what is short cut key for running the macros
what is the short cut key for running the macros ... 24 Apr 2010 07:13

what is short cut key for running the macros
please prvide the answers intime ... 24 Apr 2010 10:33

Does anybody know why these two Excel files must be open in the sameprocess?
I would need to see the macro(s). Usually these problems are due to the focus being on the wrong workbook or worksheet while the macro is running. Replacing in the macro Activeworkbook with Thisworkbook will help and specifying in the macro(s) the actual sheet names instead of Activesheet. The focus is changed w... 24 Apr 2010 07:13

Excel Jululian
Good morning please help i have a lists of names and i want to separate each in a colum like You Light Up My Life197711 You Light Up My Life (in one colum "A") 1977 (in one colum "B") 1 (in one colum "C") 1 (in one colum "E") regards ... 24 Apr 2010 07:13

Access denied when running Excel from DOS prompt with runas comman
Hi I am trying to open multiple instances of Excel using the runas command from the DOS prompt. I am following the DOS command line method because the start->menu->..Excel and selecting 'Run As' method is not working. I get the following error when using the runas command: runas /user:campc.mydomain.com\ca... 26 Apr 2010 12:38

Allow Users to Edit Ranges
I should also mention that at the bottom of the 'Allow Users to Edit Ranges' dialog box in a check box that can copy the permissions to new workbooks ... Emma Emma Farrell wrote: Allow Users to Edit Ranges 23-Apr-10 I realise this is an old thread but the solution is still worth putting out there ... t... 23 Apr 2010 21:42

#NA error on a INDEX formular
Does anybody know why I am getting #NA with this formula. It was working OK awhile ago???? =INDEX($B$2:$BJ$402,MATCH(B411,$A$2:$A$402,0),MATCH(B410,$B$1:$BJ$1,0)) ... 24 Apr 2010 22:44