marked

Sorry if I'm not quite using the correct terms here, I'm an Excel VBA person, not so much an Outlook person. I know there is "Unread" which allows for marking something as read or unread and there is "Follow-Up" which flags an email, both of which can sync across multiple devices in IMAP mode...

When adding items to a listbox, how do i avoid ones marked "Do Not Use" (DNU). This is where I am picking up my listbox contents: Private Sub FillResults() Dim ws As Worksheet Dim rngFound As Range Dim strFirst As String Dim strSearch As String Dim strWSname As String Dim...

I am currently working through middle size data sets, around 1000 recordings, and want to be able to work through them quicker. My main problem is that if I have a column marked "test" with results from the tests in a different column marked "results" with the values, is there a shortcut to lets...

Help me Guys... <colgroup><col span="10" style="text-align: center;"></colgroup><tbody> DIV DOI 55555 33333 11111 44444 22222 66666 77777 888888 104 11111 10028 10128 10240 10358 10520 10748 10867 11583 104 22222 6948 7024 7099 7174 7245 7364 7440 8562 104 33333 1051 1200 1280 13523...

Hey All, The following formula is for displaying a time range. If a box is marked in any way it should choose the first and last time marked, in thirty minute increments from 4:30AM-12PM. However, I just added the 4:30AM spot into the sheet(new column, but cannot figure out how to have this...

Hi, I have a table, names of people in column (A) and names of tests in columns B to Y. Each person can only do specific tests which is marked by the name of the test under the heading. If the person cannot do the test this cell is left blank. Is there a way I can select a specific person's name...

I have a date column and a column that states "Include" or "Don't Include." I want to calculate the Percentile of each row in my data set given that they are marked to be included. Any thoughts on how to group them?

Hello. I have a quote sheet that marks up my price by a certain percent. The way I have it set up now is for a 10% markup and I adjust it manually. C1 = .10, C2 is where I enter the cost, B2 = C1*C2, A2 = B2+C2. I would like change this to vary the markup percent based on the cost. Ie. as the...

I’m trying to track attendance. Is there a way to atuomatically list employee I’ve marked a present or absent.

How to cut list into pieces that are marked by / ? so that 1/2/3/4 would become 1/ 2/ 3/ 4/ By doing a macro? so that it would cut after / and paste into new row? and repeat until the last / ? Thankyou :rolleyes:

<tbody> Given below is the list of 6 marks with various grades. Now how can I sum top 5 marks excluding that marked "F" in excel? 51 B 45 C 63 B+ 46 C 52 B 59 F </tbody>

Hello, In my score sheets, there are often blank spaces left in between other cells that need to be zero. I know of the find/replace function that can substitute blanks with zeros, but that will substitute any blank cell, even those that are after (to the right of) the last filled cell in each...

What is the best way to do the following: If one (or more cells) within a range on a matrix is marked (e.g. with "X"), show the value of the header in that column in the cell of the corresponding row left in the matrix (column B in my example). If more than one cell (on a row) is marked, the...

Dear Team, I have an excel sheet which is filled by the employees. Range "B" and "C" have data validation as list set to Yes/ No. If "B" and "C" are marked as "NO", Range "D:F" should be protected from editing. The event should be triggered on Cell value change. Can this be achieved?

Hello everyone, I am glad to be here. I need some help with this table please. I have different lots made on different machines and the corresponding cells are marked x or y In G6 I need to find out which lot has the largest risk number and smallest potency. In H6 I need to find out which lot...

Hello everyone, I have the following issue: I am doing a long and complex filtering within a table where each filtering process starts at the beginning of a certain Column where it then reads its cells content. In the middle of that filtering process, changes are done to other columns based on...

Hello, Looking for some support regarding the following question. Any SKU that Has05Reason equal to "Yes" AND Has98Reason = Yes then I want to be able to: Return a column and/or measure that says "Yes" the SKU Has05and98Reason Example1: SKU 123 would have "Yes" marked in...

I am attempting to build a simple dashboard that will reflect the overall status of several processes with a Red, Amber, Green indicator. For example, I have 6 processes in total, each to be marked as Red, Amber or Green. If all 6 are marked as Green, I want my Overall Status to be marked...

Please help... How could I make it so the user can only input an "X" either in column "D" or column "E" (on the same row) but not in both columns? Basically if there is an "X" marked in one column (either "D" or "E" on the same row), the other column will be restricted to enter a value. Mich...

Hey guys, Need a bit of help putting together an IF Function. I have multiple entries which I want to cross reference for differences. For the time being, I want to compare 2 entries for difference or to see whether they match. There needs to be 2 parts to this IF formula which I'm having...