+ Reply to Thread
Results 1 to 2 of 2

Return percentage value if match two cell ranges text value same with condition

  1. #1
    Registered User
    Join Date
    05-06-2012
    Location
    feeds fifater
    MS-Off Ver
    Excel 2003
    Posts
    1

    Question Return percentage value if match two cell ranges text value same with condition

    Dear Friends,
    anybody can help me to find a formula to get the result.
    I have an inspection plan for employees to perform their job and tracking their data entry to get the result of how much percentage they did their inspection.
    Employees will enter each inspection job in the "INSPECTION JOB ENTRY" sheet. The result will be shown in the "PLAN" sheet for their performance after matching the text values of building names in between "PLAN" sheet and "INSPECTION JOB ENTRY" according to the condition of dates within weekly duration.
    In the "PLAN" sheet, values already entered for each employee like a 5 days building inspection schedule for each month. The percentage result will show in the "%" column if the data of "INSPECTION JOB ENTRY" sheet looks at the value from the column "BUILDING/LOCATION" within a particular week.
    Please anybody can help me, attached the excel sheet.
    regards,
    Attached Files Attached Files
    Last edited by vppismail; 06-08-2021 at 01:15 AM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Return percentage value if match two cell ranges text value same with condition

    I notice that you have posted a file with an .xlsx file type, yet you have indicated that your XL version is 2003. Please update your profile to reflect the correct version of XL you are using. This helps to provide for a solution that will be appropriate for the version you are using.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 12-02-2020, 04:36 PM
  2. Replies: 6
    Last Post: 05-31-2019, 12:39 AM
  3. To return the value of the cell in a row if it match the condition
    By richard.77 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 04-21-2016, 04:12 PM
  4. Replies: 4
    Last Post: 11-20-2014, 08:49 AM
  5. Replies: 10
    Last Post: 09-18-2014, 09:36 AM
  6. [SOLVED] How to match a cell with text with a range of text and return own text
    By ec4excel in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-16-2014, 11:07 AM
  7. Replies: 0
    Last Post: 11-16-2012, 11:42 AM

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