marked

  1. M

    Looking for other ways to "mark" emails in Outlook 2019 in IMAP mode

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

    userform listbox add items but not if they are marked cancelled

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

    Shortcutting equations on larger datasets

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

    INDEX / MATCH / OFFSET / AVERAGE Formula

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

    Formula Inquiry

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

    Summarise table based on value

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

    Conditional percent rank

    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?
  8. H

    Variable Pricing Formula

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

    Tracking attendance

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

    Cut list into pieces that are marked by /

    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:
  11. B

    Summing top 5 marks in excel excluding those marked 'F'

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

    How to substitute blanks with zero, only if the blanks are in between other data

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

    On a matrix: If cells are marked, show table header value in corresponding row (with line breaks).

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

    Protect cell from editing based on another cells

    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?
  15. M

    Index adn match with max and min criteria

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

    Question about creating a possible dynamic array?

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

    PowerPivot - Calculated Column Conundrum

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

    Nested IF, COUNTIF and OR statements

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

    Restrict value input in a column based on another column

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

    IF Function

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

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