pending

  1. 2

    Multiple ISBLANK Query

    <colgroup><col><col><col><col></colgroup><tbody> ORDER STATUS CAD PENDING DIE PENDING STONE PENDING CAD PENDING </tbody> These are my 4 columns, if (Column 2,Row 2) -> CAD pending cell is blank , then Order status(Column1,Row2) should show CAD PENDING, if (Column 3,Row 2), DYE PENDING is...
  2. J

    How do I sort things in the right order when events happen at the same time

    I need to find a way to sort each line by Column A and then by Column D. The problem is that some events happened at the same time. The idea is to provide a timeline of each Incident Number in Column A. How can I get excel to know that if the timestamp is the same, the line that goes first is...
  3. K

    Multiple emails with each row data

    Dear All, I have this excel data where am trying to send individual email along with the data from each row associated to that email id. Below is the format <colgroup><col span="6"><col><col span="7"></colgroup><tbody> Number BU Amount Currency Supplier Name Creation Date Invoice Date Status...
  4. D

    Filter data on multiple criteria

    I need help filtering on multiple criteria. Consider the sample data below that provides a greatly simplified data set. I need to show all data for the current date and any data from previous dates with a status of "Complete Pending Verification. I am not sure if it will matter, this table...
  5. S

    If Column X contains specific text in Column Y then SUM Column Z

    I'm working with a large table similar to the one below with thousands of Order #'s (Column A). In Column D I'm trying to identify the status of each Order # based upon the Line Description(s) in Column B associated with each unique Order #. If Column B contains "Fiber Facility - Enterprise"...
  6. H

    specific formula for chart data

    hello, i'm trying to pull specific data from a column for a graph. this column has cells that have dates in the in format dd/mm/yyyy, but also has cells with the word 'pending' in it. i want to make a chart that includes the cells with a date value (and will be pulling in corresponding data to...
  7. E

    Validation in 4 columns for todays date

    Hi Team, I have below data, i require a formula in column E where it should say pending / completed. Wherever there is no todays date it should say pending and where todays date is present it should say completed. Dates ate populated in this sheet by a vlookup from different sheet...
  8. M

    What did I do wrong?

    This formula returns "N/A", and for this particular row, it should return "Pending" because the identifier is in the pending hires and transfers page. =IF(VLOOKUP(A2,'Open Reqs'!A:A,1,FALSE),"ACTIVE",IF(VLOOKUP(A2,'Pending Hires &...
  9. N

    break inconsistent rows of data into a long list

    Hi, I've only posted once before, so sorry if this isn't very clear. I've got a list of email addresses with additional information associated to them in random length rows as shown below (dummy email addresses used). I want to be able to capture each email into it's own row, with the...
  10. N

    generate weekly report

    can someone help to generate weekly summary per this file? raw data entries: <colgroup><col><col span="4"><col></colgroup><tbody> Date Status1 Status2 Status3 Status4 Week 02 April 2019 Approved Approved Approved Approved 14 03 April 2019 Reject 14 08 April 2019 Approved Reject...
  11. R

    Need Sumif Formula

    Dear Sir, I need a formula in Excel, may be Sumif or Sumifs I am not sure. 3 columns in consideration for this formula. I need a formula if column D1: D1000 is "Direct" and column K1:K1000 is "Pending" to sum column I1:I1000 Your help will be appreciated. Thanks Raaj.
  12. R

    VBA Advanced Filter

    I have some code that currently looks for two criteria. <colgroup><col><col></colgroup><tbody> Date Requested Approved? 2/24/2019 Approved </tbody> I would like to add pending as a criteria under approved too. so that if the column has approved or pending it will show up. bellow is what i...
  13. A

    Update Information with Multi Select List Box

    Hi all !!! I am just starting off with VBA and have made a couple of userforms, but ran into a question when trying to update the information based on multiple selections in a ListBox. I have a userform that shows in a list box all of the jobs that are due this week, if for some reason I do...
  14. S

    Compare & copy the records from 1 sheet to another sheet in the same workbook

    Hello Friends, Need the expert guidance from you. I am new to the VBA world. My problem statement is as follows: Problem Statement: There are 4 sheets in my workbook - Pending Old SP, Pending New SP, Onboarding Dump - Old SP & Onboarding Dump - New SP. Below is the manual process that i am...
  15. T

    If Function - 4 results needed

    Hi Needing help with this. What i have is not working, obviously. Below are 4 scenarios and I need results for all 4. I have this =IF(ISNUMBER(SEARCH("*",AN32)),IF(AO32>0,"Yes","Pending"),"") from my spreadsheet but I don't know how to change it for what i now need below. What i have below...
  16. K

    Count Maximum Days Based on Status

    Hi, I have three columns. Column A has the task type , column B the number of days and column C has the status as Completed or Pending. I need to show the maximum days pending for any task that has been tagged as Pending in column C. I am using the following formula but it does not work...
  17. T

    If function to return multiple conditions

    Hello Looking for help to write a formula that will give me the result of column "C" below. Tried this in my excel and obviously not working.... =IF(AND(COUNTIF((AH287="*team*", AJ287=1), "Yes", ""), (AH287="*team*"), AJ287=""), "Pending", "")) I want it to return Yes if Team and a date, if...
  18. M

    Countifs and Isblank??

    I am trying to create a task list of pending tests on 1 main worksheet from another worksheet with multiple account numbers for the same person. I need to match the account number (which is repeated multiple times on the worksheet I am pulling from) to a column that may or may not have a date...
  19. H

    Issue with CF of column

    Hello All, i am having issues with creating CF for a specific column. column is for delivery ETAs. so most of the cells have a date in it, so the column is formatted to dates. however for some of the cells we are waiting for the ETA so have "pending" written in it. i can't seem to be able...
  20. S

    Marco to Paste to last Row based on a column

    Hi, I am trying to paste data from the "Pending" tab to first row without any data on the "BS" tab. I tried to create a "test" macro (copying only one of the columns) but it's pasting in the correct column but wrong row. The first column with data in the BS tab is column D. I need to copy all...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top