status

  1. USFengBULLS

    VLookup For Same Value but in 2 Different Columns

    Hello All, I have a column of cell on one sheet that I am having lookup the description in the table in another sheet based off the status. Basically the formula works for this =VLOOKUP(B11,'FINISH LIST'!B11:J495,6,FALSE) and its is returning the status fine, but I also need it to look into...
  2. R

    formula to return status of a PO w/ multiple rows and multiple status

    Hello I need assistance with coming up with a formula for spreadsheet 2 column 2. I have a list of all PO in spreadsheet 1 and need to Pass or Fail based on the status from spreadsheet 1. If it contains a no or maybe then fail. this is a s implied version. <tbody> Spreadsheet 1 </tbody>...
  3. R

    RAG Status help!!

    Hi, Is there a nested if formula that can result in a RAG status for the following Criteria? R if less than 1.5 or more than 4 A if between 1.5 and 2 or between 3.5 and 4 G if between 2.1 and 3 Thanks
  4. M

    Vlookup? and range check

    Dears I need your help My data is as follow <tbody> Name Status Pro1 Successful Pro1 Failed Pro2 Failed Pro2 Failed Pro3 Successful Pro3 Successful Pro4 Successful </tbody> And what I want is retrieve the names without duplication and this criteria for the status <tbody> If...
  5. K

    Conditional formating based on reference table

    I'm trying to develop an excel spreadsheet to use for writing work schedules. The current set-up I have is columns A, B, and C are "employee", "status", and "hours",respectively. Off to the side (columns K, L, M) I have a table that designates the range of hours allowed to each employment...
  6. S

    Date extraction from cell according to the status

    Dear All, In excel sheet, Column V has a history of comments. Commentsare recorded by the date then Name of the person then status and then thecomments. Please see the below example (these all information in cell V2): 10/9/201810:20:32 AM(Date) - Hanneli (Name) : Status - Response...
  7. R

    How to send the automated gmail from excel sheet content

    HI, I have the data in google Excel sheet. How to send auto generated gmail from that excel cell contents Need to send status report on daily basics Eg: To:Distro to be sent Subject: Status report Body Content: All, Please find the status report Table format to be displayed from that...
  8. T

    when 'status' changed, timestamp cell in correspondingly titled column

    Hi, I have a sheet with a list of unique values in column A, say 1 through 100.Each has a 'status' in column B. This status is selected from a drop-down menuof 6 options, say, I, II, III, IV, V and VI. These options each have a column assignedto them (columns C through H), and the cell in the...
  9. E

    How to carry over the values of a column in 1 workbook to another?

    I have 2 separate workbooks. I want to carry/copy one column in workbook A to workbook B, but only carry/copy over that one column, the values in the "status" column. Since some employees are removed and some are added, I can't simply copy and paste the entire "status" column from workbook A...
  10. H

    Count the amount of times a month appears in a range

    I tried the formulas here, but they are all returning #VALUE . https://www.mrexcel.com/forum/excel-questions/503651-counting-number-times-specific-month-appears-range.html Please note that I am referencing a separate workbook ('[2018 Claim Status Sheet.xlsx]Active Claims') which has the dates...
  11. J

    Conditional Formatting with multiple values

    I am setting up a s/sheet to keep track of meetings, if they were held, minutes received and attendance. I have set up formulas to give me the status. I want the status cell to change colour depending on its value. I would like Cancelled – Red (Got this set up already) Waiting for minutes –...
  12. M

    index match losing hyperlink status

    Good evening I am using this code: =INDEX(a3:b100,MATCH(L9,a3:a100,0),MATCH(M8,a3:b3,0)) I have a drop down box in L9 listing names, when I choose a name it copies an email address from another (hidden) column My question is this: the email addresses in the original hidden column are...
  13. A

    Return A cumulative Percentage value based on Today's date referencing a start and end dat

    Hey everyone, I have been stuck for a while trying to figure this out. This is what i have: Start Date End Date Days Weight Status Planned Value Actual Value 1-Feb-2018 5-Feb-2018 5 10% Red/Green/Yellow ( Function 1 ) Function 1 = =IF(AND(Today()>=Start Date,Today()<=End...
  14. BenElliott

    Extract not ignoring duplicates - Why?

    I'm still working on my several tables for Speakers giving several talks in multiple locations. Some speakers are marked as "Good" and some as "Moderate" in a table column named "Status" Location is given in cell F1 and Status in cell F2. The count is in cell F3. the folumula for extracting the...
  15. Guzzlr

    Copying one cell value to another, then checking with a third cell value

    =IF(AND(E21=MILESTONE_SCH!D12,STATUS!E21=[Daily_Status.xlsm]PB_STATUS!$Q$6),STATUS!E21=MILESTONE_SCH!D12,"TEST") I’m trying to copy a cell from one worksheet tab, into another worksheet tab. And, have the copied cell check to see if it is equal to another worksheet tab, using the above...
  16. BenElliott

    Extract with or without criteria

    Hello, all. Several years ago I watched a ExcelMagic trick that extracted a series of data based on a criteria but I can't seem to find it now. Here is what I need: My data table, currently 2,800 lines long is in an Excel table labled "SpeakerTalks". Column 'A' is labled "Speaker Full Name"...
  17. L

    If/And/OR help

    <tbody> A B C D E F 1 <tbody> $ Amount </tbody> <tbody> $ Amount </tbody> <tbody> </tbody> Pool $2000 2 <tbody> Paid in auction Bought by non-owner </tbody> <tbody> Paid in auction Bought by owner </tbody> 30% <tbody> 70% </tbody> <tbody> Status </tbody> <tbody>...
  18. J

    PivotTable # and % column on same row

    I'm connecting to Analysis Services; I need to represent the data in # and % columns and not sure how to accomplish this. <colgroup><col><col span="2"></colgroup><tbody> System\Region\Location\Appointment Department 7/1/2018 # % Total number of scheduled appointments 100 x% Total...
  19. Z

    Put 1 as value for every unique set of values appears with multiple columns as criteria

    Hi, everyone. So, I am working on multiple columns of data that needs to be a part of a formula. Let's say I have columns A to E - each of the columns correspond to a certain type of data. Now, we have column F where we need the formula to be added so that each cell for each row shows the value...
  20. B

    Finding the lowest value

    I have a spreadsheet where Column A holds a document reference number, Column J holds a type (fixed rent/insurance/service charge), Column K holds a status (invoiced/to be invoiced), Column L holds a target date, Column M holds a target amount. What I would like to report on, is for each...

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