received

Hello I'm am trying to get sumproduct to subtract values in a column that match the criteria of the formula I have a check register that and each entry has a category, Payee, Spent, Received, Balance <tbody> CATEGORY PAYEE SPENT RECEIVED BALANCE Venue Tom thumb 125.00 500.00 Promotion...

Hello, I am very new to Excel VBA, i have worked on a few codes based on the forums available on MR Excel. I currently require a vba code for Debtors Management. I have 12 worksheets in a workbook each one for a separate month, in which i have a column called category in which i enter Debtors to...

Good morning everyone, can anyone help please as Im having a Real brain fog day! My if statement is =IF(G4=E4,F4,IF(G4>E4,SUM(C4-D4*G4))) which is not returning the value expected and I cannot work out where I have gone wrong. Column info C=price 1, D=price 2,E = sum of qty received 1...

Hi, i have a lot of data in Sheet3 columns A:CQ Rows all the way down to 30,000+. So columns B:CQ are all dates, so once all the raw data (in another tab) is entered and some data appears against a date the date will appear in the cell. below each columnd title i have several outcomes, i...

So I have an item that we have received many times and would like to create a table using a measure listing percent change and date. IE received at $1 Jan 10 then oct 8 $1.25 then nov 22 $1.30.... Showing the date for each. Something I’m guessing with min?

Hi, I have had a look around online but can't seem to find what I want. I have devices in one column and dates received in another. I do not wish to reorder the column as they are set up in device order. I want to find which device was received the earliest. Please can someone advise the...

Hello, I am trying to set a formula that will count days from a start date (or submitted date), up until I enter a received date. I need it to count days, but stop counting and leave the # of days in that column after I have entered that received date. I have tried many formulas, but I can't...

Hi there, I have two lists on one spreadsheet with the invoice number being common to both lists. The list on the left is from a supplier and the one on the right is my list. The list is about 2,000 lines and what the supplier wants to find out is if I have received their invoice and is it paid...

I am trying to sum up stock that was received in a given month to each individual location. I can't do a vlookup because the same item might hit multiple locations and not give me the correct quantity received in at that location. I have two separate worksheets. One worksheet is a summary of...

Hi I would like to get the range Address of Each Individual Name against payment made to them and received from them and few other details from each individual name. All the names are in column B if you see below For eg if I type Kate in txtName.Text to get the range Address ie A15:D23 in...

Hi, I'm not sure how to word this, so please bear with me. Each month, I receive data for work with 10 columns and up to 19,000 lines. On the first report I received, I added an additional 2 columns at the end and painstakingly went through each line to add extra data I needed. I have now...

Dear Sir, I am trying to format a date cell to return todays date if a cell in the same row is marked "Received" using the IF formula. =IF(F1 = "RECEIVED", TODAY(),"") But the issue in the above formula is when I open the file the next day the date changes, I want the date to be static, how...

Hello there, I'm trying to adapt some code that i found in another thread. Sub MM2() Dim lr As Long lr = Cells(Rows.Count, "A").End(xlUp).Row With ActiveSheet.Rows("1:" & lr) .AutoFilter .AutoFilter Field:=5, Criteria1:="Yes", Operator:=xlAnd...

Hello, If someone has helped out with a problem and given the solution, how do you post a Thanks or a Like on their answer? I see that some people have received Thanks or Likes from people but I can't seem to figure out how the heck the person did it. Jenny

Hi Everyone, I run the following code to UNHIDE a sheet(LOTTERY RECEIVED) from a button on a different sheet(LOTTERY). It works fine except I would like the sheet(LOTTERY RECEIVED) to be the active sheet in the workbook. Not quite sure how to get there? Thank You!! Sub...

I'm fairly new to the more complex Excel formulas and need help finding the average number of days between a range of dates. I'm using Excel 365. I have 2 ranges of dates; one for a ship date and one for a received date. There are ~1000 lines of shipped dates, but not as many received since...

Hi guys, I have a report that shows when a customer has responded with a customer service score, however it is not applicable if they’ve replied more than 2 weeks after the sent date. Let’s say cell B is the sent date and cell C is the received date and cell F is the cell I want to show yes or...

I have a table, Column A represents a billing period (11/30/18, 12/31/18, 1/31/19 etc.) and column B represents an amount received for the applicable billing period ($100, 115, 105, etc.). In a separate cell I want to return a date of the last invoice payment received. So, if the table above...

This is a re-post from another site, since I wasn't having much luck on there: The problem I'm presenting's a little above my VBA skills, so I appreciate any help and ideas. I've pasted a couple of excel sheets to give a general idea of what I'm looking for. Essentially I'm looking for a code...

Hi all, I am trying to filter for blanks on a specific column header and I am struggling to get my head around it/could not find any solution on the net relevant for this issue. I need to use this on about 30 different sheets and every single worksheet has the same text ("Received Progress") in...