pending

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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