+ Reply to Thread
Results 1 to 15 of 15

Find percentage of times two adjacent cells have the same data

  1. #1
    Registered User
    Join Date
    02-25-2013
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2010
    Posts
    14

    Find percentage of times two adjacent cells have the same data

    Hi there

    A newbie here, so be gentle.....

    I have a large database in excel and I want to get a percetage of adjacent cells that contain the same text.

    For example B1 and B2 contain "TBA", C1 contains "TBA" and C2 contains "cat".

    I want to get a formula that tells me (using the above content example) that 50% of the rows have the text "TBA" in the two adjactent cells.

    Thanks in advance for your help.

    Jamie

  2. #2
    Valued Forum Contributor
    Join Date
    09-04-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    463

    Re: Find percentage of times two adjacent cells have the same data

    i think u should make your detailed query and you should also provide a workbook with a manual solution example...for best answer...

    REgards
    CA Mahaveer Somani

  3. #3
    Registered User
    Join Date
    02-25-2013
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Find percentage of times two adjacent cells have the same data

    I thought that the example I gave would explain it.pretty well without providing the complete workbook.

  4. #4
    Valued Forum Contributor
    Join Date
    09-04-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    463

    Re: Find percentage of times two adjacent cells have the same data

    as you wish but i could not understand properly that what is your need exactly?

  5. #5
    Registered User
    Join Date
    02-25-2013
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Find percentage of times two adjacent cells have the same data

    OK, I have got back to work and have saved a basic example of what I am trying to find a formula for. (please find attached).

    What I am trying to do is produce a percentage of rows that have "RPL" or a year written in both colum A and colum B.

    Hope that helps

    Jamie
    Attached Files Attached Files

  6. #6
    Valued Forum Contributor
    Join Date
    09-04-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    463

    Re: Find percentage of times two adjacent cells have the same data

    i got your file but still could not understand what do you mean by percentage there?
    can you give me a manual solution so that i can create a formula for you....

  7. #7
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Find percentage of times two adjacent cells have the same data

    May be this...

    In E2 cell
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Drag it down...


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  8. #8
    Registered User
    Join Date
    02-25-2013
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Find percentage of times two adjacent cells have the same data

    Ok try this version for a more explained sheet

    Jamie
    Attached Files Attached Files

  9. #9
    Valued Forum Contributor
    Join Date
    09-04-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    463

    Re: Find percentage of times two adjacent cells have the same data

    Sixthsense are you got the file next to your answer....now what you will say... m still confuse what he want....
    mr. jamie will you plz tell me the answer with provided your sample data...

    regards
    CA Mahaveer Somani

  10. #10
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Find percentage of times two adjacent cells have the same data

    percent of people current with step 1 and 2
    What is the brief of the above quote mentioned in your file? show us the expected output and the way you are calculating it for better understanding

  11. #11
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Find percentage of times two adjacent cells have the same data

    @ mahaveersomani,

    Hm... still confused about the OP's requirement

  12. #12
    Registered User
    Join Date
    02-25-2013
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Find percentage of times two adjacent cells have the same data

    if you have a look at the last example sheet test sheet.xlsx‎ (12.0 KB) it explains

    I want a percentage of people who have the text RPL or a year in both step 1 and step 2 (colums B & C)

  13. #13
    Valued Forum Contributor
    Join Date
    09-04-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    463

    Re: Find percentage of times two adjacent cells have the same data

    i m sorry jamie i can't help you without came to my knowledge that what is your requirement...therefore i quit...ask this from others...
    Opinion:
    as i saw you sheet there is column B and C i assume they are for 1st year and 2 year...
    and then i found the people who have the text "RPL" then i saw the people are 7 people have the same text in year 1 and year 2 out of 11 people then did you mean the answer would be 100% (due to constant in two year) or it would be "63.63%" (people percentage)?

    Thank you
    Regards
    CA Mahaveer somani

  14. #14
    Registered User
    Join Date
    02-25-2013
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Find percentage of times two adjacent cells have the same data

    the percentage should equal 72.7%, as 8 people out of the 11 have either "RPL" or a year ("2013") written in B & C colums

    I need a formula for that

  15. #15
    Valued Forum Contributor
    Join Date
    09-04-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    463

    Re: Find percentage of times two adjacent cells have the same data

    I THINK NOW YOUR QUERY WILL BE SOLVE AS I UNDERSTAND YOUR QUERY

    use the attached file i have put two formula in that file...choose one formula by the way both are the same but one is detailed and another is in part...

    reply is it ok for you...?

    Regards
    CA Mahaveer Somani
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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