1. S

    Getting the reverse percentage of an equation

    I have tried to google...Can't find. Please help. I am trying to get the answer of a formula to give me the reverse percentage. ex =SUM(D2/C2) (7/18) = 39% - But what I really want is 61% Thanks in advance
  2. D

    reverse array value in one cell

    dear mr excel i have problem in one cell lets say G1 i have value <tbody> 106.97259485721588,-6.261230615140504 106.97383940219879,-6.261321266258494 106.97372138500214,-6.2627076931611905 106.97363018989563,-6.263576874303437 106.97224080562592,-6.263475558784672...
  3. K

    Conditionally Formatting (Highlighting) Top 5 / Bottom 5 when there are two scales in same column?

    I have a column of topic scores. Around 50 cells. I am trying to highlight the bottom 5 and top 5. There are about 10 of these topics that are on a reverse scale meaning a lower score would actually be better and could put them in the top and a higher score would be worse and could put them in...
  4. muhammad susanto

    Reverse Text with Criteria not All text can be reversed

    hi all... i have problem how to reverse order text with criteria like this : Excel 2013 64 bit <tbody>#888888[/URL] "] #FFFFFF[/URL] ]F #FFFFFF[/URL] ]G #FFFFFF[/URL] "] #888888[/URL] "]#FFFFFF[/URL] ]4 PT THE BIS BOSS THE BIS BOSS, PT #FFFFFF[/URL] "] #888888[/URL] "]#FFFFFF[/URL] ]5...
  5. muhammad susanto

    Reverse Order After First Spacing

    hi all.. how to reverse order this text below after first space and the final answer adding mark (,) comma like this : <tbody> data expected result PT. Big Boss Big Boss, PT Drs Agung Maju Sejati Agung Maju Sejati, Drs CV. Indah Karya Solution Indah Karya Solution, CV FA Tiger Chong...
  6. R

    How to find a character in a text string without creating an error?

    I need to check when characters are and are NOT within a cell. =IF(AND(FIND("<>"&"!",$G11),FIND("<>"&"^",$G11)),1,0) G11 = !Project Planning The first logic test will produce a TRUE, but instead of the second one giving a FALSE, it gives a #VALUE error. I know I can do the reverse by doing...
  7. J

    Reverse scoring for likert scale

    Hello, I am analyzing data from a survey (1= Not Interested, 5= Very Interested) in which some questions have reverse scoring (5=Not Interested, 1= Very Interested). I am seeking to have a formula for a column to automatically reverse the scoring. How do I do this? Best, John
  8. D


    I need to change a list of names in my spreadsheet: John Smith to Smith J Is there a single formula I can use to do this? I know to change the first name to an initial I can use =LEFT(A1,1)&RIGHT(A1,LEN(A1)-FIND(" ",A1)+1) and to reverse the order I can use...
  9. P

    Reverse order of data range and exclude the blank cells

    Hello - looking to reverse order of a data range and exclude the blanks. Possible? Data Range B10:B15 B10=10 B11=20 B12=30 B13=40 B14=blank B15=blank Needed Result C10=40 C11=30 C12=20 C13=10 C14=blank C15=blank
  10. S

    Reverse of Fill Down in PQ

    Hi How can i do the reverse of Fill Down in PQ. ie remove the duplicate and keep only the first one in a column (Eg "Store" in the below code) let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"Store", type text}...
  11. A

    reverse compound interest

    Hi, I need a formula to calculate a daily compound interest rate where I know the initial value and the present value. For example, if in a week an investment increased by 30% (let's say $100 becomes $130), how would I display the daily compound interest, ie by what percent did it increase each...
  12. T

    Reverse Numbers

    I have a column of fields that I need to reverse the order by every 2 digits. Current: 021598 Need: 981502 So last 2 digits, next 2, then first 2 Also if the current number only has 5 digits, it needs to do the following, Current: 21598 Need: 98152 So last 2 digits, next 2, then...
  13. D

    Reverse Word/String in Excel using VBA

    Im taking one of those free continuing education courses to maintain my designation...anyway, one of the tasks is to make a loop that reverse the string in Excel, but im totally lost...could someone help me, pleasE?
  14. B

    Reverse lookup index/match excel w/ duplicates in array

    I need a reverse formula to identify the column headers from sheet2 based on model and OS version on sheet1; if no match found return text “OLDER”. It is important for me to note sheet2 contains duplicate model numbers listed in column A; this is necessary due to the various versions of OS...
  15. J

    Reverse engineer date

    Hi, I know the year, weekof year and day, How would I go about reverse engineering it to show the date. <colgroup><col span="2"><col><col span="2"></colgroup><tbody> Year Week Day Date 2017 26 Monday 2017 26 Tuesday 2017 26 Wednesday 2017 26 Thursday </tbody> Any help...
  16. J

    Reverse of INDEX function

    Is there a function the reverse of INDEX that will match a variable and give its row and column position in a nxm array?
  17. B

    Perform Reverse Simple Match

    Hi all, Every Keyword has a route associated with it. I want to find out which description contains the keyword and then post the associated route for that keyword . For example, Abrasive is associated with Route 22. I want to match the Description "Large Abrasive Tool" to the keyword...
  18. D

    Auto Increment Number on Data Capture Sheets but reverse print out

    After much searching i found a macro to incrementaly step an order code for our company data capture sheets: Sub print_sheet() P = InputBox("How many sheets?") For I = 1 To P Step 1 Worksheets("Sheet1").PrintOut Range("C3").Value = Range("C3").Value + 1 Next I End Sub but...
  19. T

    Reverse Concatenation

    The question is of reverse concatenation in Excel VBA. I currently have this: <tbody> Joe, Jon Joe, Pam, Carl Joe, Jon, Jeremy </tbody> And need to reverse concatenate so I can then have each individual name in its own row and cell as follows: <tbody> Joe Jon Joe Pam Carl...
  20. J

    Finding exact numbers

    Hi! I'm new to excel. Using the following formula, when searching for single-digit numbers, double-digit number are also found and reverse, e.g. 62 and 26. =IF(ISBLANK($F$1),0,ISNUMBER(SEARCH($F$1,$A1&$B1&$C1&$D1))) How do I modify this formula to search for exact numbers Thanks Jimbo

Some videos you may like

This Week's Hot Topics

  • Launch Script When Tab Is Opened
    Hello all! Is there a way to launch a script or message every time a particular tab (DATA1) is selected/opened? I know it can be done when...
  • VBA that can extract words that starts with # and ends with 2021.
    Hi Everyone, I am straggling to in searching for a vba code that will extract a string that starts with # and ends with 2021. The string has no...
  • Date update overflow error ‘6’
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • VLOOKUP Formula ?
    Hi i am using this below but i need to return Column C on Detailed_view. You can see ,1 this returns D, but i need to return C before D. I tried...
  • conditional formatting the whole row
    Hello This is a question solved earlier by etaf. But I am getting some problem. I need help to correct the formula as it is not working in some...
  • Vlookup in vba
    Hi, I am new with the VBA, can someone help me, I have made this macro, but the loop across files in a directory runs only in cell G13, and I...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back