tabulate

  1. F

    Help with formula tabulate values

    Hello, May somebody help me how to tabulate with a formula the following information please. <tbody>#CACACA [/URL] "] A B #CACACA [/URL] , align: center"]1 STAGE 1 #CACACA [/URL] , align: center"]2 ID 0 #CACACA [/URL] , align: center"]3 NAME JFMSC #CACACA [/URL] , align: center"]4...
  2. L

    Automated Invoice Register

    Hi There, Just need a more customized version of the vba from MrExcel-"Create An Invoice Register Podcast #1808". This VBA tabulates data from an invoice to a separate worksheet. I.e. It pulls out information like Date, Invoice No, Customer Name and Invoice Amount an tabulates on another sheet...
  3. A

    Replicate Stata Tab function in Excel?

    Hello - I'm trying to replicate the Stata "tab" function in excel. I have a spreadsheet where I'd like to understand the number of times a set of trainings have been requested, by a person's stage (A->E). I'd then like to be able to filter by a person's demographics (ethnicity, gender, and so...
  4. L

    What is the easiest way to tabulate multi cell patterns?

    I have searched but all answers seem to be regarding searching within a string or within a single cell.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I’m using Excel 2010. Here’s my problem. I have a column of numbers (about 25,000 long) as shown...
  5. S

    How to Tabulate Survey?

    <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...
  6. D

    How to automate a Spread Sheet?

    <!-- / icon and title --> <!-- message --> <!-- BEGIN TEMPLATE: ad_showthread_firstpost_start --> <!-- END TEMPLATE: ad_showthread_firstpost_start --> I have a spread sheet (sheet2) that runs an add-in and does some calculations and arrives at a result which is a number in cell...
  7. RayJay

    Excel to tabulate info about audio files

    Hi all, I have a ton of audio files (12.something gigs worth) on my phone, all with names like ABCD.mp3 (since they were taken off my iPod). Is there a way to take these files, and tabulate the information about them (which is stored in the Advanced Summary in the Properties of each file) such...

Some videos you may like

This Week's Hot Topics

  • Check VBA code to locate value in cell
    Hello this is the current code I have [CODE=vba] Private Sub TextBox1_AfterUpdate() Dim m As String Dim rx As String rx = Trim(TextBox1.Text)...
  • Reverse Numbers Formula
    Hello Everyone! My computer is Asus My Operating system is Windows 10. Can someone please help me with a formula that I can drag down (or up) to...
  • Count If Issue
    Hi all, I'm trying to create an spreadsheet which counts certain words in a cell only once and gives me a total. I can do this but some of the...
  • VBA Check for multiple cell values and copy the cell in column A
    Hello! So I have this code that checks for the values in column "L" in this case it's 25. But I want to change this code so that it actually...
  • Sending mails to specific recipients based on a cells value
    Good morning, I am trying to get excel to send out an email to different sales reps. So if row X is an error code of "999" then excel needs to...
  • Matching Number in Textbox
    Hello Excel Users, I come with a request. Hope all are doing fine. So I have 1 textbox to type in numbers etc. 12345 (it will always be 5...
Top