mark

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...

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...

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

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...

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...

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...

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...

<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.

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...

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.

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...

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...

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...

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%...

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...

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...

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...

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

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...

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...