Results 1 to 6 of 6

Percentage and extract data

Threaded View

sprit36 Percentage and extract data 04-19-2021, 02:34 PM
etaf Re: Percentage and extract... 04-19-2021, 02:59 PM
sprit36 Re: Percentage and extract... 04-19-2021, 03:34 PM
etaf Re: Percentage and extract... 04-19-2021, 03:42 PM
sprit36 Re: Percentage and extract... 04-19-2021, 04:04 PM
etaf Re: Percentage and extract... 04-19-2021, 04:05 PM
  1. #1
    Forum Contributor
    Join Date
    05-16-2017
    Location
    Spain
    MS-Off Ver
    2010
    Posts
    103

    Percentage and extract data

    Good afternoon, I have an excel sheet with several records that I need from the cells marked in yellow to show data. In column D I have some scores, where 5 is the maximum, it would be 100%, I need to put the percentage in column C, in this case 100%. On the other hand, on sheet2 there are several records with scores, I need you to compare the student number and put in column E the punctuation data from sheet2. I attach an example. Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA to extract zip file attachments AND extract time stamp data from .msg file
    By natjo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2020, 06:59 PM
  2. Deducting percentage, calculate what percentage needs to be added to reverse
    By HereComesTheBoom in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-15-2019, 05:47 AM
  3. Formula to Extract Percentage Value from Text String
    By Sparky666 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-03-2019, 02:08 AM
  4. Replies: 1
    Last Post: 09-20-2016, 07:33 PM
  5. Replies: 3
    Last Post: 12-18-2014, 10:27 AM
  6. Extract all data to new workbook then filter and extract to new worksheets
    By graphicgoose in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-04-2014, 08:18 PM
  7. Extract data that has increased by a percentage
    By swfisher in forum Excel General
    Replies: 1
    Last Post: 02-02-2006, 09:40 PM

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