mark

Hello, I'm looking for some code that will rank by name. Meaning anytime a name changes it will start over counting. Please see below. Name Rank Frank 1 Frank 2 Frank 3 Frank 4 Mark 1 Mark 2 Mark 3 Mark 4 Mark 5 Mark 6 Mike 1 Mike 2...

Good day all, I'm trying to pull the weekly attendance of personnel, at the moment i do this manually (not clever enough to do the other bit:confused:), please see my screenshot of an example, I have on another sheet all the week numbers and dates they start/finish on. So I get the information...

Hi everyone, I would appreciate if anyone can help me with theis code: Sub pairs() Dim sh As Worksheet, tb As Long, c As Range, sVal As Range Set sh = Sheets(1) 'Edit sheet name tb = sh.Cells(Rows.Count, 1).End(xlUp).Row For Each c In sh.Range("B2:B50") 'Assumes header row...

hi all... how to adding mark "-" between number from 2 columns (joined) this layout : <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td {...

Hi all I need some help I've made some rules with conditional formatting on a spreadsheet Like when true - mark as bold or mark with a blue background. Now I would like to do some calculations based on those rules. For example, I need to calculate the average of all bolded cells (and only the...

Hello All, I am trying to sort some source data that comes in a formatas follows: <tbody> John 1 1 3 3 3 3 Mark 1 1 2 2 Amy...

Hey guys, I've searched but I am not sure I'm using the correct terms so I am sure I have not found something that is in fact on this site. My problem is that I have a list in cell G2 ("1a, 2b, 4e" for example) which corresponds with columns R and S to give a value (column R has the 1a through...

Hi, I'll explain the purpose of my spreadsheet before I say what I'm trying to achieve as it might make more sense that way. I've been asked to create a spreadsheet to log when we have cancelled a sales order and why, but in such a way that it will be a visual checklist. I know that there's a...

Trying to find a way to get info from a data set into a list where by the list is populated only if a there is a figure next to a name for example: Data Set: Sue 0 Mark 16.99 Dave 0 Adam 0 Carl 2.45 Oliver 18.19 Kirsty 0 Which will populate a table...

Hi, Apologies if this has been covered.. I can find various posts on Sumproduct but can't quite get my head around what I need to do to get this to work. Please can someone help me with the final part of the formula? My table is below. This is a mock up that I can then expand across my...

I might be asking to much for excel to do this but is it possible for example i import a picture of a map and i was it to mark on the map locations with dots. so in the cell i'm typing the street name erie st. it marks with a dot or what ever on the map. i'm assuming i will have to program it...

I have a work/marksheet where column BJ is the possible mark and Column BK is the actual mark. Column BL is the the percentage with column BM has a code for example C1. I have 7 sections in total. I have done the formula to pick out the Maximum and minimum percentage marks. I wan to output the...

I have a data file containing data from several different countries, many of which use accented characters in their alphabets. The file has been unable to interpret many of these and replaced them a black diamond with a white question mark inside: � On my PC (Office Professional 2013), I can...

I have attached an image with a rough idea of what I want. I need a way to mark the columns in row J-AU if the number in Column D is >= and Column E is <=. For example in Column D is 17 and Column E is 40 I want to mark Columns K-O. I have done this manually for some. ( See image) But what is a...

Hello everyone, WIll try to explain this as best as I can Starting at A1 Row 1 is conditional row for the code <tbody> John 22 Apple John Apple Mark Cup John Cup Mark Apple Steve Pen Mark etc etc etc etc etc etc </tbody> What I wish for is in other sheet rows from column A...

the below code lets me double click a field to place a check mark in that field and double click again to remove it. I am trying to keep the function except I want to make it conditional for the "C" column and "D" columns where if there isa check mark in a field in column "A" and I decide to...

Hi All My data has all dashes displaying as "~". When doing a VLOOKUP, any parts with the "~" (example here A~2405~4) will not register, or comes up as an error. If I try to do a find / replace it will not find the "~" I know it's something simple I'm doing wrong, and appreciate the help Mark :)

Hi, I am using the code below but not getting a true copy / paste value etc. The worksheet called MILEAGE at cell C32 has the formula =DOLLAR(D31*0.45) & currently shows £1.80 When i press the button the £1.80 is copied to cell reference E58 on the SUMMARY sheet but there is a mark in the cells...

I have a list of 8000 Company names and a list of 100 keys words. I want to the company names that contain a key word. For example, if 'Supply' was a keyword and Company name was "Mark Edwards Supply Co" the result should say yes

I'm trying to figure out a formula that would return a value of "?" if a certain cell was not a group of numbers. Example: I want Cell A2 to display a question mark if the user does not enter the numbers 10, 15, 20, or 25.