mark

hello everyone I have a huge sheet 16000 row its item master file so in description of each item there is part number or unique value it always contained number I wont formula for more than 4 number are same to mark this cell as example <colgroup><col></colgroup><tbody> Sensor, SMR6206 TS...

Hi Again. This post is still about the check mark problem that I started. That post has now been solved. What I want to know now is the following: The Event Procedure check mark will also activate if you move through the cell with the check mark. Apparently moving the mouse through the cell...

Hi There I need your help again. I created an event procedure with macros that inserts a check mark in cells When the cells are clicked only once and I made the cell color turn green. The original colors of the cells are gray. When I double click on the cells, the check mark deletes and the...

Hello, Need some help with the data below with dates and numbers changing from positive to negative and positive again. At the point of change from positive to negative number, I would like to mark "X" and also from negative to positive number also mark "X" on third column. Can anyone...

Hello, I am trying to perform an IF function with multiple criteria. I'll explain what I'm trying to do first and then my formula is at the end. There are 3 columns: Check Mark, Formula, Activity (in A, B & C) In my example, imagine the "1" to be a check mark to do the activity in column C. If...

Hey Guys, Im looking for a file that I can use to recon my bank. I know there has to be something out there. Right now we use excel and I literally make green each matching deposit. It would be nice if I had some automation that would pick up the easy deposits first and match them and then I...

Hi!, In my Data Sheet, I am having below data. <colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> Rejection Details Jul-2018 22 34 31 22 24 22 36 36 23 Date Model Part Production Qty. M.Cap Miss M.Dent Mark M.Fin M.Flow Mark M.Scratch M.Shrinkage...

I have values in column A for my future forecast. In columnB I have budget for that forecast. Ihave delta btw the two in Column C. Iwant to create a formula that will use conditional format preferably with iconsets instead of fill that will do the following: If deviation exceeds in...

Hello, I am looking for an excel formula that does the following: We have a mark to reach, let's say MARK=12 In column A we have "random" amounts. In column B, I want a formula that: - Calculates the running amount in col A and - If the running total has not reached then MARK then leave the...

Hi, I have this spreadsheet. I want this cell to work out how much commission is calculated. If the "GM this month" is equal or higher than the number in the 4 or 5 week month row (depending on whether the cell E19 is 4 or 5) then I want the cell to give me E20* 10% if it is Equal or...

Hi All, Any idea's on if there is a formulas that say, if cell contains a certain value or text, then make another cell a certain color. Thanks in advance, Mark :)

Hi I wonder if you can help me I have a spread sheet of training for my staff <tbody> Student Course one Date started no. attempts mark acheived date completed Course 2 <tbody> Date started no. attempts mark acheived date completed </tbody> <tbody> Course three Date started...

Hello All- The below formula gives me a check mark(W867), if cell G11 matches "O_P". I am having issues with the second part of the formula - I wanted a check mark also if G19 matches "PWS_LOG_WARE", if not "". =IF(ISNA(MATCH(G11,O_P,0)),"",IF(ISNA(MATCH(G19,PWS_LOG_WARE,0)),W867,"")) Please help

I am working on a problem that I just can't solve. It may be that I can solve with good old IFs but I want to see if Goal Seek or Solver would work better. Basically, I have 2 tables. One table has John, Peter and Mark repairing bicycles. Bicycle A totals up to 34, B total is 120, C total is...

Hi I would like excel to be able to generate a list of student names in rank order from 1-10 in a different tab to the main list that may have 60+ students listed. For example TAB1 Time Rank John 10.23 4 Steve 10.34 5 Mark 9.43 1 Holly 9.87 3...

I am trying to return a name from a long line of text. Below is a sample line: Shipdate: 04/03/18 Stk Br # 1 Writer: Mark Smith Tax Jurisdiction: 1 Every line is edited the same every time, with a shipdate, writer, and tax jurisdiction. I am trying to extract the name of the writer in every...

Hi everyone, I am having some issues with this marco, and full disclosure, I don't know much about macro's at all. But i am getting a runtime 424 error whenever i try to run this. The purpose is to pull from a list of employee numbers and print them on a safety inpection sheet. Any help is...

Hi, I have 2 tables in 2 sheets. Sheet1 <tbody> name Margin MTD Target MTD Margin QTD Target QTD James Mark Frank Jim Russell Conrad Denis </tbody> Sheet2 <tbody> Year Quarter Month Day Name Margin Target 2018 Q2 May 01-05-2018 James 10 20...

Hi, I have 2 tables in 2 sheets. Sheet1 <tbody> name Margin MTD Target MTD Margin QTD Target QTD James Mark Frank Jim Russell Conrad Denis </tbody> Sheet2 <tbody> Year Quarter Month Day Name Margin Target 2018 Q2 May 01-05-2018 James 10 20...

Using excel 2010 I have the following line of code. Range("D13") = "(6) 1 1/4" Screws" I want range D13 to say the following: (6) 1 1/4" Screws I want the single quotation mark after 1 1/4 to be displayed since it's denoting inches. But I keep getting a debug. What do I need to add to...