Results 1 to 4 of 4

Percentage calculation

Threaded View

  1. #1
    Registered User
    Join Date
    02-28-2011
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    2

    Percentage calculation

    Hi,

    Please help with your excel expertise to achieve following in attached excel sheet (MLS_Matrix.xlsx):

    Source Data:
    In worksheet "Labels (Fixed Text)", in column A I have document names. For each document I have certain fixed text labels which are listed in column B. Now we are going to translate these fixed text label from English to different languages (listed in column header C, D, E, ...)


    I want to do following in Tracker worksheet:

    In the table Matrix against each Document Name and Language, I want to track %age of English lables translated at any given time.

    Example: For document name "Advanced Shipment Notice" and language "German", if there are 33 English labels, but in German there are only 20 corresponding translated label text the in cell D4 a percentage value 60% should appear.
    This matrix should get updated automatically as translations for each label text in listed languages start filling in. Empty cells in in source data should not be counted.

    Thanks for you help

    Best regards,
    Nitin
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1