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