received

I have 2 chats on the same tab. Both are the same. 1 shows emails received by date, 1 shows emails sent by date. Both have the same filters, and the same fields used. They both pull from formula fields in different tables, and the formula is the same. The received table does not show dates...

...based on a date that falls between two given dates. For example, I collected $100 on April 15 and another $200 on April 20. I need a formula that sums up all cash received in April between April 1 and April 30. Thanks!

Hi, this was working last week, now appear to be causing an error. I have 2 tables, one is called inbox and one is sent items. inbox has from, subject, cc, received time, powerapps id as standard sent items has the same plus some formula. Original Subject = if(left('Sent...

I have a repair database that when I put in "Waiting for Parts" status (Column I), I will look up the repair ID (Column C) in [Parts Worksheet], and look if there is a match. If there is a match, it puts the same ID in Column A. This lets me know that I have a part inputted for the repair...

Hi i have analysed the data I have to produce a table showing the number of cases received and cleared each month based on converting the date field into months. I now have a problem because the 12 months has gone round and now I have April repeating itself so I need to add the year to the...

Hi all, first time posting in the BI forum, regular in Excel. I am attempting to build a dashboard with regards to our work team email inbox and sent items. I have created flows that save data to various excel sheets. I have 2 tables in BI. Table1 is data from the inbox. From - Subject -...

Hi, I am trying to automate a particular process where when I receive an email with a particular attachment I open the email, run a macro and close the spreadsheet. (The macro migrates data to a record sheet, generates an email and sends a 3rd spreadsheet on to a predefined distribution list...

Dear Team, I want a calculation a cell where i put the no of notes received like if A1 Contains the Currency Detail and on B1 I write the qty of the NOTES received and on C1 the Calculation should Show A1 B1 C1 100 2 200.00 then if again i received 3 NOTES then I should Write like...

Dear Sir, i want to say that i have a sheet where i need to calculate the no of NOTE(Currency) received the whole day, currently what i do is all the time i have to calculate the received amount with the amount entered in the cell. what i need is i only enter the no of note on the cell and...

Hi. Looked through the forum and couldn't find a response to this particular error. I have an excel file which loops through emails in a particular folder in Outlook to extract details of the emails. There are three main properties it's supposed to extract from Outlook: received time, subject...

Hi All, I am trying to write a Nested If the formula for more than 7 arguments. Below is my formula and answer received. <tbody>...

I have below column hedaers from BK11 to BZ11. These are basically steps in my projects. I have a drop down in AW11 which i basically update once the status changes of a particluar project. I have 10000+ such project with each row as 1 project. I want to basically track dates for each step. So...

I have a long list of organizations that have received funding over a 3-5 year span from different levels of government (local, state, federal). I want to calculate the average amount of funding each organization received over this time span from each level of government. I could do it by hand...

I'm having trouble with a code. I want to insert data into some cells on certain worksheets in my workbook. I can do this for one sheet, but it is not doing it for every sheet that I intend it to. Also, I don't know how to VBA a border around each cell and auto adjust the width of the column to...

Hi, I have data and want to pull the rows to next sheet if certain criteria is met. Criteria: 1: Name should match is 13th Column 2: Profit should be less than 5000 3: GMV should be less than 8000 Example: I want to pull all the rows where Name (Col 13) is I****a, Profit (Col 11) is less...

Hi All, Is it possible to read a received mail's subject, date received, sender emai Id available in Inbox based on certain condition such such as for a particular period of time, then take all the data to paste it in excel? I am finding hard to write VBA code for this scenario. Please help

Hi All, I have below tables which shows Query received time and Query resolved time. Now i need a formula in Column C to show, if the query is resolved with 24 hours or after 24 hours. Can someone please help <colgroup><col span="2"><col></colgroup><tbody> Query Received Resolved Duration...

Hi everyone, I'm hoping someone here can help me (after spending hours of researching, I cannot find the solution to this). I am working on a project around tracking certain items being sent out to certain providers and monitoring if we get anything back from the providers. However, the...

Good day, I have once sheet that has a lot of data of sales and commissions, etc. The data is complied by use of remittances that is received daily and is dependent on when an items is sold. Due to this it means that most of the the information for an item received in June might only be...

Hi All, I am looking for a formula to extract data from a list dependent on what is in columns D ie the list on sheet 1 will be A1 : Parts B1 : Description C1 : Cost D1 : Status On sheet 2 I need A1 : Parts only with "Ordered","Partially Received" or "Pending" status B1 : Description with...