mark

  1. B

    index match or offset?

    I am trying to type in a name in column D, and have the data from column B (for that name), generate in ascending order in column E. Any ideas? Is it an index match formula? <tbody> A B C D E F 1 Matthew 1/1/18 37 Mark 1/1/18 45 2 Mark 1/1/18 45 Mark 1/5/18 41 3 Luke 1/1/18 52 Mark...
  2. H

    How to make combobox search strings in between

    Hi, I have this combobox in userform and were populated using rowsource. What I need is that everytime I key in or type a text in combobox, a dropdown list would I appear like i type : JOHN, all list that has word "JOHN" in it should appear; JOHN MARK, MARK JOHN, LYOD JOHN, Please help, I dont...
  3. J

    Vlookup Problem

    hi all i understand how to work Vlookup funciton, if found a value return me a value, if not give me a #NA (right) my dude is how to mark in the matrix the value? see the image. https://imgur.com/a/LkFjp1C How to mark? found in the matriz? thanks
  4. R

    Mark consecutive Non-Blank Cells

    Hello, I need to mark consecutive more than 5 Non-Blank cells in excel like given below. It will be good if this can be done in VBA Macro. <tbody> A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB AC AD 2 5 3 4 3 3 3 4 3 3 2 3 3 3 3 3 3 3 4 4 4 4 1 2 3 4 5 6 5 7 7 8 8...
  5. I

    DATA VALIDATION: dropdown "x" and no more that one "X" in the range

    If I have a range, C4:G4, where I want to place an "X" to indicate a size, but there can be no more that one "X" in that range, is there a way to do that with Data Validation, or will it have to be VBA? This is a sizing chart to send to members and them to mark...
  6. S

    Find largest result after converting to percentage

    I am familiar with the LARGE function of finding the largest, 2nd to largest etc. value of a range. I have the situation where I have a range of marks, and then below it another range of what the mark is out of. E.g I have the following in A1 to E1: 1,2,3,4,5 Then in A2 to E2 I have 3,4,4,4,10...
  7. M

    Adding line break and alpha-sort to existing VBA

    I have a table that looks like this: <tbody> Teacher Class Mark Smith English Mark Smith Math David Park Science David Park History </tbody> I currently have a VBA solution (at the bottom) that combines teachers to one row, and lists their classes in the next, separated by commas...
  8. Welsh Mark3

    Create ID for duplicate values

    <tbody> Col A Desired Result Mark 1 Mark 1 Rich 2 John 3 Rich 2 John 3 </tbody> Is it possible to create a formula that gives an incremental numerical value for duplicate values? My actual spread sheet will be bigger than the example above.
  9. E

    Compare and mark

    Hello, I need to open archive file and compare column F of active sheet and archive sheet for occurrence and mark in acive sheet in column A if something was found. I have code to compare fields and mark differences but now I would like to mark dubles in ActiveSheet. Mayby someone could...
  10. R

    Rounding

    So I have a formula written that works for what I am trying to do. I have it rounding to the nearest 500, either up or down, but I need it to round down at the 250 mark, not up. So what I am trying to do is.... 5250 goes to 5000 6380 goes to 6500 7750 goes to 7500 any help is appreciated.
  11. A

    Excel 2010 - Need A hand

    Hi, in another thread I outlined problems running version 2007. To resolve tehm I dexcided to buy Office 2010 hoping that would fix things. I've installed it but trouble straight away... e.g. The code in this project must be updated for use on 64-bit systems. Please review and update Declare...
  12. L

    Find A Value based on multiple columns and single cells with data separated by a comma

    Hi I have a spreadsheet with a set of criteria in it. I have called it table 1 I have a second set of data I will call Table 2. I would like to be able to insert the appropriate value in the PRICE column in table 2 based on the criteria listed in table 1 and matching it to a set of values...
  13. A

    Flitering + logical tests

    Dear all, I have been doing the following problem: I have a table <colgroup><col span="5"></colgroup><tbody> Name Training welcome day night mark welcome 1 mark two mark day 1 mark some Polyak day 1 Polyak night 1 Polyak one Polyak two...
  14. Victtor

    dynamic truncuation

    I found this formula: =LEFT(A1, FIND("?", A1&"?")-1) that removes everything after a question mark including the question mark. I need the formula to remove everything after the first number after the last alpha character in a cell: 3 examples: 2011617 Nacho Bar 206 42.83% 1,260.19 68.32%...
  15. S

    Show cell content when it is selected

    Hello, I have a worksheet to mark the student exams. The final mark is a formula and I want to hide the number value. However, when I click on it or select it, I want it to show. Since I want to show the students this file on my computer, however, I don't want them to see other students marks...
  16. B

    Make a score worm

    What I want to do is make a chart like this: That shows score and when they happen. So a team score a goal at the 3 minute mark, their margin goes up 6 points, then a point at the 5 minute mark, they go up to 7 points, then at the 14 minute mark the other team scores a goal and it goes back to...
  17. M

    If function not working (based on x, y, z number)

    Hi all. I have the formula below =IF(E11="7.5",L6*K11,IF(E11="5.0",M6*K11,IF(E11="3.5",N6*K11))) In cell E11 i have the following in a drop down list, "7.5" "5.0" "3.5" I keep getting FALSE as my answer, if anyone could guide me in the right direction that's be...
  18. G

    Function

    Hi In column A I have series of dates. In column D I have numbers. I need a function that will return the sum of numbers in column D between the dates Jan 1st and June 30th 2017. Many Thanks, Mark
  19. T

    And the winner is...

    Once the cells are filled for columns "1,2,3,4,5 and 6" I'd like a check mark (or any selected illustration) to automatically appear under the "Winner" column for the team with the most points. In the example below Team A defeats Team B 4.5-1.5. All cells are filled so can we get a check mark...
  20. B

    Count Down

    Hello, It has been a while since I have asked any questions, but I am sure you folks will steer me in the right direction. Thanks in advance I am trying to create a gradebook, of sorts, in which each time I enter a number it will subtract from 100 Sorry I couldn't get the image to work...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top