return

Long time reader, first time caller, I want to look for a value in two tables(columns in sperate worksheets) and have the result come back of which table the value was found in. I have tried with If and Vlookup, and can return the result of the first table search, but does not work when...

Hi, is there a way, without using Pivot, to return a specific sum through duplicate list entries, example: <tbody> Item Qty Qty needed Total qty needed Item#1 1 = 100 Item#1 200 = Item#1 50 = Item#1 500 = </tbody> I only need the sum of 100 taken from...

I am working on a formula and I have a Name in A31, A percentage in M31, then I have a list of names in Column U. What i need is if that name in A31 is a member of the list in Column u and the percentage is over a set number return a yes. Any ideas?

I am using the following sumif formula: =sumif(U5:U91,"2",N5:N91) N5:N91 contains all negative numbers, and I need to make them positive. How can I accomplish this? Thank you!

Is it possible to use InStr to where it will only return the position of a string if the phrase you are looking for is the entire cell. So say for example InStr(1, a(i, j), "err", 1) i want to find "err" in an array and not have it return "Sierra" only if the entire cell is "err" do i want it...

I’m trying to query a value in a row/column and depending on the value provide an answer in another row/column. The data I’m checking against is a number sequence which needs to be queried to see if it’s between a series of more than/less than/equal to statements. Ive done these before for...

Hi, I have 2 worksheets, I need to retrieve the column header data from one worksheet, but I have values in the row data, not text. I need to look up the ID name from my master worksheet and return the header value if of my column of data if the same ID name is in the other worksheet. Lookups...

Good morning All, I am trying to write a VBA to search for either a PO# or Document # and from that return Additional information. I have a workbook with 2 tabs that this would work with 1st Tab is "Transactions" -- PO # would be -Column "X", Document # is column "V" 2nd Tab is...

Hi Master Excel Users. I have a two dimensional cell range of cells say from A1 to P5000 I would like to remove all duplicates within this range but keep the uniques where they currently are sitting, in their current position. Any good way of doing that? Alot of cells are blank within this...

Hi everyone, I have looked at different answers to this question with no success as when i run the vba my workbooks freezes and then wont do anything. I have a worksheet called "Club Ledger" that i need to sum a range of cells in column C5 to C105001 and return the result to Cell F5.. Then...

I have a column of data and I want to find how many semicolons are in that column. So for example: a; b; c d; I would expect to return 3. However, for: e;f; g; h;i;j; k; I expect to return 7. I tried using: =COUNTIF(A:A,";")) but it only returned 4 for my second example...

Is it possible to either return the Label Selection or the periods selected from a Timeline attached to a pivot table?

Good afternoon all, Can anyone please help with the following, I think its an ‘index/match’ formula – but I cannot understand any guides I can find online and it’s beyond a simple vlookup. I have sheets 1 in the same workbook, What I am trying to do is return a value in column C from sheet 2...

Hi, I need to create a formula that looks at the mid point of a cell =MID(CellA1,20,????) and starts at character 20 and returns the next 2 words before a space. Cell A1 contains "AAAAAAAAAAAAAAAAAA RyanSmith Recruitment AFH 0967" Cell A2 contains "AAAAAAAAAAAAAAAAAA JonBlot Recruitment AFH...

Hi Guys, I've got a question regarding the CUBESET Function. =CUBEVALUE("ThisWorkbookDataModel","[Measures].[Sum of Sales Price Ex Tax]","[Orders].[CON Flag].&[1]",CUBESET("ThisWorkbookDataModel","[Orders].[Created Date].&["&$Q$2&"]:[Orders].[Created Date].&["&$R$2&"]")) This is my current...

Hi, In column range A-Z, row 1, there are cell values in E1, M1, Y1, the rest are blank. What functions can I use to determine the far most right column containing any value, in this case Y?

Hi, I'm trying to calculate a 1 month benchmark return for an investment portfolio. I've encountered an issue where by using the daily index rate of return to compute a 1 month rate of return and multiplying that by the allocation does not give me the same result as calculating each days index...

Hi, I want to check the value that is in cell C and if it isn't found in C14:C62 then return "1". Does anyone know the formula? Thanks

Hi, In cell A1 I have 2019 in cell A2 I have Aug in cell A3 I have 19. I need a function that will return the date 19/8/2019 Many Thanks Mark

This is my formula that returns the 1st value but I need to return the data from the 2nd and so on. My project is to pull data to populate invoices based on the invoice number. =VLOOKUP(value(rngInvoice),Received_Process, 2,false)