person

  1. W

    Trying to match several individuals to see how often and total times they have crossed paths

    Hi. I've got a bunch of transactional data that I'm putting into Excel - dates, times, phone and people associated to each line item - kind of like traveling together is the best example I can give. I'm trying to match up the dates and times for Person A to see who Person A has strong...
  2. N

    Run BeforeClose Event in One Situation and Ignore or Bypass It In Another

    If anyone can help with code below it would be very much appreciated. I’m at loss as I’ve reworked the code below multiple times with no success. I’m trying to do several three things in sub but can’t get everything to work. Thing 1: I want to determine if person—supervisor or...
  3. F

    Finding max value per id in a stacked data table

    Hi there, I have 2 tables. 1 called 'HeadcountTble' the other called 'SurveyTble'. The 'HeadcountTable' is normalized and has unique ids per person. The SurveyTble has multiple rows per person. The tables are linked 1 to many from the 'HeadcountTble' to the 'SurveyTble'. What i want to do is...
  4. A

    Using Min and if to produce a text response

    This is probably very straightforward but its doing my head in, can someone help I have a worksheet which has two columns one with Names the other with value, all i need is a formula in column 3 that will return for each individual "lowest" for the lowest value attributed to that person and...
  5. S

    Lookup formula

    Hi, sorry this is probably pretty simple to work out but I'm very time poor at the moment and am only an eighth of the way through this project. I need to calculate how much we owe each person. Person in column A. Amounts owed to that person are in column D. Thanks so much!
  6. E

    Match/Lookup Formula when lookup value isnt exactly the same

    Good morning, I was hoping for some help on a lookup/index function I amtrying to get to work. I have two spreadsheets in excel that have the name of aperson in column A, the location of the person in column b, and an amount forthe person in column C. Sometimes a person’s name will be on the...
  7. R

    Sending an email when a value/name is entered into a cell

    I have a spreadsheet for work that gets populated with various issues. I have to notify each person who is in charge of resolving the issue, there are so many at this point I am running around all day. Is there a feature in excel or a way to send out an email to a person when their name is...
  8. D

    Create Header Row From Data & Place Column Data Across 4 Columns

    Hi all, I'm required to format .txts into a series of reports. After removing some columns and filtering the courses, this is an example of what I have left (Cols. A to G), with each person having 4 rows of data. The number of people on the report varies. I don't know how to do the final bit...
  9. C

    Nested Excel Function

    I have the 6 columns that I need to include in an IF formula that I am having issues with. Column A is Ethnicity,Values are "Y" for Yes and "N" for No Column B is America Indian, Values are "0" mean not American Indian and "1" meaning person is America Indian Column C is Asia, Values are "0"...
  10. A

    Is this even possible?

    Is there anyway to sort column B, by the persons name and all the data that is for that person under and to the right move up to the rows above that are empty?
  11. K

    List Copy Paste Concatenate

    Hello Experts, I have a sheet that I need to figure out how to automate: - I need to copy the Attendees Column (Could be upwards of 500) to Output A2 - Sort alphabetically - If the level is below the level threshold listed, the person needs to report as NAME,LEVEL - If there is anything in the...
  12. E

    Lock row based on value in first column

    Hello everyone, I'm struggling to get this code right. Hopefully someone here can steer me in the right direction and help me out. <tbody> LOCK PERSON DATE CONTROL no Value 1 Value 2 Person 1 01-01-2018 1234 15 55 Person 2 20-02-2018 5678 20 42 Person 3 15-04-2018 9012 34 37 </tbody>...
  13. A

    onedrive - live updates with restricted access?

    hi all. I have a central 'leads' excel sheet, that is stored on our onedrive. Person A through person D have access to it. I have another sheet "Output.xls" stored in the same location, where person E can access / see it, but not edit. output.xls is pretty much a selected data transfer from...
  14. L

    Conditional format for names between morning and evening shift

    Hi, Hope this is placed in the right category. I'm struggling to make a conditional format for the following: If the person on de "Evening shift" is the same as the person the following day in de morning (the first of the 2 persons), I want to put the name in red and bold. I have uploaded a...
  15. H

    Best way to show quantities and ratio on same chart?

    Hi! I'm not sure if I can attach a file but here is my sample data: <colgroup><col span="2"><col span="2"><col span="2"><col><col><col><col></colgroup><tbody> Early For Class On Time Late For Class Grand Total % on time Person A 2438 535 546 3519 84% Person B 127 41 17...
  16. E

    Macro to concatenate data

    Hi there, (all fictitious) Suppose that I have a worksheet with names, date and prizes won at those dates, as they appear in the worksheet. I need a VBA code that concatenate these data in a single row per person, listing the person name, the dates and the prizes wons on each unique date...
  17. G

    Create data validation formula so pop up box appears when a number is entered

    How do I create a Data Validation formula for Column C? If a person tries to enter a number in Column C when an "X" is in a cell in Column B, would like a pop up box to open that says "Miles Not Allowed". I would prefer not having to create a VBA formula. Also, would I need two different...

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