• How do I extract the top 5 from an Excel column if there are duplicates?

    I have a stats sheet and need to pull the top 5 players' names and their stat out.  The issue is that I get the first player's name (that has the stat) for each entry that has the same stat total. In the example below I get Rae for both of the "5" stats...

    mtnmaiden5 pointsBadges:
  • Convert PDF to Excel

    How to convert PDF to Excel?

    LDS5 pointsBadges:
  • Editing excel file after converting it from pdf file?

    At first I convert the pdf file to text file using acrobat reader. after that i open the file through excel.  But i didnot get proper output of my file as the pdf format. the pdf format contains picture & tables also.

    Papuli5 pointsBadges:
  • PDF format file change to Excel

    My friend got one PDF file and contain some table based data. How can we convert that file to Excel format?

    Tonycheng5 pointsBadges:
  • Critical Path

    I created a project plan and everything looks normal but when I want to view for a critical path (using Gant Wizard Chart), I don't see any critical paths. I am wondering what went wrong

    MSProject5 pointsBadges:
  • Finding the list of processes executed on a queue

    I want to generate an Excel sheet of processes executed on particular queues. Please assist.

    makxxd3564565 pointsBadges:
  • ASCII code VS. ASCII text file

    If I convert an excel spreadsheet containing hundreds of sheets in the workbook to text file format is that the same as ASCII code? Also, is there a way to convert the whole workbook or do I have to do each page one at a time?

    zoombug5 pointsBadges:
  • Analyzing an Excel spreadsheet divided by categories and subtotal

    Column B has various vendors, column F Has Totals, Row 5 has a category subtotal which totals all categories in column 250,and row 7 starts a new category. I would like to create a total of each vendor in a table, what is the best way?

    Kerrie12345 pointsBadges:
  • Reading Excel with RPG HSSF

    I set up a program to read Excel on my AS/400 using the klement examples then move to user AS/400 and cannot get it to read the Excel. Program compiles fine.

    mr400man5 pointsBadges:
  • Row of data not transferring to Microsoft Word when using mail merge

    I'm using mail merged to transfer data from Excel to Word for my job. I just had to write a bunch of code to update to Word 2013 for it to work. However, when I try to transfer everything, it works perfectly except there is a whole row of data that does not transfer to the Word document. Everything...

    SARAHCYOUNG205 pointsBadges:
  • Export / import data from Excel to SQL database

    Hi, I want to do one program in which I have one Excel sheet that some data can be stored. I want to import that data in VB.NET application and store it in a SQL database and do same thing vice versa. Which means I can fetch data from SQL database through VB.NET and store that data in Excel. Please...

    qwertyudicdi10 pointsBadges:
  • Microsoft Excel: How to find top 10 figures based on a condition like country wise

    I do have sales figures country wide and i would like to make a separate table for each country and populate top 10 sales figures in XLS. Thanks in advance.

    rangagom15 pointsBadges:
  • Load Excel with Japanese characters to iSeries DB2 file

    How do I load an Excel spreadsheet containing Japanese characters to an IBM iSeries DB2 file?

    tonycurtis135 pointsBadges:
  • T-code S_ALR_87013611

    If I look the SAP id of my office mate, the code S_ALR_87013611 was in the excel format. How can I do this in my SAP ID. Thanks!

    eiseljaneenriquez5 pointsBadges:
  • MS Office 2007 Excel files not opening

    I have MS Office 2007, Windows 7. When I double click on an XLS file, Excel opens up but it is just a empty Excel program. It is similar to opening up Excel and then just closing the book1 that opens up automatically. Just a grey background. Also I can't open up XLS files by doing File > Open or...

    CharlessReynoldss5 pointsBadges:
  • Copying Outlook messages into Microsoft Excel using VBA

    I'm fairly new to Macros and VBA. So, on a daily basis, I receive roughly 50 emails with one specific subject - Task Completed. Now, I made a rule that moves them directly into a Task Completed folder. But now reading all these emails has pretty much consumed my day. Is there a way I can copy these...

    ITKE392,005 pointsBadges:
  • VBA Exporting to text file

    I am trying to make a VBA to copy multiple cells from excel to notepad in this sort of format: Interface GigabitEthernet1/0/1 Switchport access vlan 990 shut But all I seem to be doing is copying the top line over and over again. Here's the code I've been using: Sub exprtToText() Dim ff As Long,...

    Dozii35 pointsBadges:
  • How to repair and recover corrupt MS excel file?

    How to repair and recover corrupt MS excel file? I am unable to open corrupt MS Excel file due to virus infected, I have crucial Workbook sheet got lost, so how to get back corrupted MS Excel file. Please help me.

    DredSelpy5 pointsBadges:
  • Microsoft Excel: Convert number into column

    Could I convert a number to my Microsoft Excel column name? Now, I can't use automation (basically I can't get the value straight from Excel). I'm also using Excel 2007. Thank you.

    ITKE392,005 pointsBadges:
  • Break through password on Microsoft Excel VBA

    The project I'm currently working on is to update some macros in in Microsoft Excel. But here's my issue - a bunch of the VBA projects are protected by a password that I don't know. Can I remove / break through those passwords? Thanks!

    ITKE392,005 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following