• Microsoft Excel: How to convert data from rows to columns

    I have a bunch of data in Microsoft Excel that I need to convert from rows to columns. Basically, here's what I want to do: Sport College Coach Division Basketball Uconn Ollie Division 1 Change that to: Sport Basketball College Uconn Coach Ollie Division Division 1 How can I do that?

    ITKE1,015,970 pointsBadges:
  • Cannot open Microsoft Excel document: There was a problem sending the command to the program

    Whenever I try to open a document in Microsoft Excel 2010, I keep getting this error: There was a problem sending the command to the program. Here's the key - when I have Excel already open, it's fine. This is only happening when Excel is closed. What can I do?

    ITKE1,015,970 pointsBadges:
  • Excel formula help IF LEFT or

    I need an Excel formula: =IF(LEFT(b1;2)or(1.;0.;2.;3.;4.);b1*4;b1*2.1). I don't think it is correct. It should duplicated the number in cell C1 from B1 with 4 when first two letters are 0. or 1. or 2. or 4. If not, it should duplicate with 2.1.

    postavosta5 pointsBadges:
  • Microsoft Excel formula for how many times a name shows up in a column

    My Microsoft Excel sheet has several columns that contain different names in it. For example: Michael Melanie Matthew Katie The names are in the column multiple times. How can I count how many times a name shows up in a column? Is there a formula for that? Thank you.

    ITKE1,015,970 pointsBadges:
  • Microsoft Office: Missing Localized Strings Here

    I downloaded microsoft office from my college's website, and when I tried to open it the message "missing localized strings here!" what does that mean and how can I fix it?

    dsawyer5 pointsBadges:
  • VBA Do While Loop

    Dim iJob As Integer Dim strJob As String iJob = 5 Do While ThisWorkbook.Sheets("Defaults").Cells(iJob, 21).Value <> "" And iJob <> 4 If ThisWorkbook.Sheets("Defaults").Cells(iJob, 21).Value = strJob Then Select Case ThisWorkbook.Sheets("Defaults").Cells(iJob, 21).Value Case strJob...

    Wolfehound725 pointsBadges:
  • Download details of VK13 in Microsoft Excel

    Can I download/export details of vk13 (condition type- Slab Price with historical data) in Excel. Is there any T-code or table?

    Marmik5 pointsBadges:
  • Deleting filtered Microsoft Excel rows

    I have a Microsoft Excel spreadsheet that has over 50,000 rows. After applying a filter, can I delete non-consecutive rows? The Visible function doesn't work because there's too much data. Thanks again.

    ITKE1,015,970 pointsBadges:
  • How to autofill Microsoft Excel column with series

    In Microsoft Excel, I can't autofill a specific column with a series. For example, this is out I want it set: Jan17 Feb17 Mar17 I'm doing a right click and drag but that's not working. Any idea on what I should do?

    ITKE1,015,970 pointsBadges:
  • Find max of visible Microsoft Excel rows

    Sorry if this question is confusing. I'm in Microsoft Excel 2010. I have several rows of data. I would like to find the max for each specific row. But here's the catch: My formula should only take the max from visible data (not hidden). How can I do that?

    ITKE1,015,970 pointsBadges:
  • How to convert a .SHS file to Excel?

    How can I convert a .SHS file into a Microsoft Excel file as with .SHS. My computer is not able to decode it? Please tell fast its an emergency, I have to work.

    daaku35 pointsBadges:
  • How to export data from AS/400 in Excel

    Hi everyone, I would like to know how to in a step by step process export date from AS/400 iSeries into an Excel workbook. The purpose is to gather the data from AS/400, export it to Excel, then filter the data for specific info, then import that to another Excel workbook. A basic inventory report...

    Itriconewbie5 pointsBadges:
  • How to convert Numbers file to Microsoft Excel file

    Not sure if this is possible but I thought I would give it a shot. I have both a Windows and Mac PC. I have a spreadsheet on my Mac that's a Numbers file. Would I be able to convert to an Excel file for editing on my Windows PC?

    ITKE1,015,970 pointsBadges:
  • Autofill PDF form using Excel data

    I am a Visual Basic newbie and I need some help with the following code. Basically, what I am trying to do, is to autofill a PDF form using data in an excel worksheet. I did some testing and the program seems to be reading the required data from the excel cells but not writing it in the PDF form....

    shawnturner10 pointsBadges:
  • Set Microsoft Excel 2016 document as read-only and password protected

    I used to run Microsoft Excel 2010 and what was great about it was that I could set my documents as read-only and if one of my co-workers wanted to make any chances, they would need to put a password in. But now our company upgraded to Excel 2016 and I can't find that setting at all. Does anyone...

    ITKE1,015,970 pointsBadges:
  • Adding tax data in Microsoft Excel

    I am trying to move tax data from one Excel sheet to another, organized by zip code. In one sheet, which has the tax data I need, the data is organized by AGI. This means there are 6 data cells for each zip code. However, In the Excel sheet I am moving this data to, there is only one line for each...

    caseyp75 pointsBadges:
  • Text file format is taking up more space than Excel file format

    In my Microsoft Excel spreadsheet, my data is in roughly 10,000 rows. But when I stored the data as a text file, it's taking way too much space. Why is it different as a text file than an Excel file format?

    ITKE1,015,970 pointsBadges:
  • Microsoft Excel: Round two decimal places

    Sorry if this is a basic question. I'm a Microsoft Excel newbie. How can I add two more decimal places without rounding it off? Basically, if I have $50, I want it to show $50.08. Thank you.

    ITKE1,015,970 pointsBadges:
  • Needs to pass data from Excel to host on demand

    I need to pass data from Excel to Host on demand 3270 mainframe and vice versa using VBA.

    Kavithagowda5 pointsBadges:
  • Create random sample of Microsoft Excel data

    I'm looking to do some random sampling on my Microsoft Excel spreadsheet. Basically, it has over a thousands rows on it and I want to sample around 100 of them randomly. Would this be possible? If so, what's the process?

    ITKE1,015,970 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.

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

Following