• MAX of Alpha numeric range of fields

    How can I get the MAX value of an alphanumeric range of fields in Excel? i.e. a column with values like S020, S045, S102

    KarenKS25 pointsBadges:
  • Microsoft Excel

    Gents: Could you please assist me in the below case: 1-I have 2 Excel sheet on my PC (Excel A is extracted on a daily basis from I Series by using data transfer while Excel B is the target one). 2- Excel B (target) has a special header and colors and contains 4 columns and 20 rows with zeros amount...

    Senior1systemanalyst260 pointsBadges:
  • Why is my app so slow when writing from VB to Excel

    What I use: An app where following procedure has to be run approx 100.000 times... it takes 5 minutes! It should go faster. Question=how? Dim Record as string Dim oExcel As Microsoft.Office.Interop.Excel.Application Dim EXCBook As Object, Range as object oExcel = New...

    abc1234520 pointsBadges:
  • Excel file

    Gents Could you please assist me in the below case: 1-I have 2 Excel sheet on my PC (Excel A is extracted on a daily basis from I Series by using data transfer while Excel B is the target one). 2- Excel B (target) has a special header and colors and contains 4 columns and 20 rows with zeros amount...

    Senior1systemanalyst260 pointsBadges:
  • Excel speadsheet

    How to delete a password from the workwook?

    leegustia5 pointsBadges:
  • pivot table cell format

    Fields in pivot table have a different format that original data

    jalopez8115 pointsBadges:
  • Pivot tables

    Hi. I am trying to download data from SAP to Excel using pivot tables. When I go to spreadsheet in SAP it does not give me an option to use pivot tables. My work colleagues don't have this problem so I believe its something in the settings that I need to change in SAP or Excel?. Thanks

    aaaaaaaaaaaaaaaa5 pointsBadges:
  • Convert PDF to Excel

    How to convert PDF to Excel?

    LDS5 pointsBadges:
  • Conversion to mmm-yy in excel

    Hi, Please suggest any method to convert numbers like 41041,41072 to mmm-yy format.

    senmalar210 pointsBadges:
  • $ sign and numbers after decimal

    One of my columns is for a $ amount that never changes for that particular person. Recently, I wrapped the text to print out a readable copy. For some reason I lost all the $ signs in that column. Also, when changing an amount such as $176.37, the .37 will not stay.  The $ sign is true for all 129...

    kaykay9085 pointsBadges:
  • USB drive isn’t opening Excel file, but other Excel files are opening without any problems

    Hi, My Excel isn't opening because of one corrupted file from my USB disc.

    sherrozsatti5 pointsBadges:
  • Excel to AS/400 PF

    I know this topic is widely discussed. But even after going through some of those discussion, I am not able to proceed. I have an Excel sheet which has one row header and one row of data, which includes both numeric as well as alpha data. I have opened it in notepad and but ',' separators after...

    RamvishakRamesh2,505 pointsBadges:
  • Excel copy and paste

    Microsoft Excel Worksheet for Windows : Using copy & paste, if I transfer some information into one cell of an excel,during the course of routine work, if the number of words is around 200 or more, only part of the information is saved and not the entire information. Is there any solution for...

    NAGKUDLIG5 pointsBadges:
  • Excel Question

    Can you repeat the 'LESS' command by pressing CTRL + R?

    edjames10 pointsBadges:
  • Excel x-axis labels

    I have tried unsuccessfully to create labels such as Aug 11, Sept 11 under the x-axix. Would appreciate any help.

    lorilee5 pointsBadges:
  • SQL table connectivity via odc

    Can a user create a Microsoft .odc file from a SQL database (eg Visual Manufacturing, Dynamics, etc.) without a special tool? Looking to design refreshable Excel reports.

    tswanson3005 pointsBadges:
  • Outlook email

    Can I export my daily mailbox into an Excel spreadsheet or table?

    vonka5 pointsBadges:
  • Opening files

    How do I get excel and word to open files without giving me the "read only" screen and having to click "notify" and wait? In the 2007 version, they would just open and 2010 takes so much longer because of this "read only" issue. How do I take that off so they just open?

    cmeveland5 pointsBadges:
  • Excel Quickbooks Update Report

    I was wondering what the Quickbooks Update Report in Excel does? I was going to try it but I am on a work computer and was afraid to try it without knowing what it does first.

    Administrative5 pointsBadges:
  • how to recover an excel file

    i did format my disk, but unfortunately, i also deleted an important excel file. i used getDataBack to recover that file, but when i get it back, i totally cannot read it, the data inside appear all like this "ZUØƠ&¥¥<Ó·UßçœZZ.XMUßwđ¥¥.^µUø™Ũ{đ¥¥_®×,R¥|ni2#EZ™™�"...

    Devil5 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