formulas

The messy data looks like the list in columns A & B (see image), the finished list needs to be like columns D&E. I'm cleaning up some very messy data with formulas on the spreadsheet up to this point but the solution could be with VBA also, I'm open to either. So basically the purchase order...

I have a spreadsheet with two tabs that keeps wins information for cases I work on for my job. The "Winners" tab has all the info and the "Summary" tab summarizes it all. Within the "Winners" tab, I have it broken up by a days, and each day has 10 lines attributed to it. For example, day 1...

I have a workbook that analyzes 3-5 years worth of bank information, I need to identify when money is being transferred from one account to another. IE. I move $10.00 out of account A and put it into account B. Currently I have a formula that will Identify duplicates that occur on the same...

I am trying to compare dates between 2 different worksheets in the same workbook and summarize differences on summary worksheet. First I would need to search by ID number to make sure I am looking for the correct line, than look at the close date, compare this to the other worksheet using same...

I found some information/formulas on a website and I tried to transfer the information to my own spreadsheet so that I could play around with other stock/exercise prices and dates. I am trying to get the formulas listed below for D1 (cell B12), Call Price (B16), and Put Price (B17) to work out...

Hello Excel Geniuses, I'm having a hard time coming up with solutions here using formulas. Here's the synopsis: I work at a company where an employee usually works 1 job a day or multiple jobs a day. Scenario 1: Employee 1 works 1 13 hour shift Hours Calc: Regular (8hrs) OT (4hrs) Dbl (1hr)...

When I click "Trace Dependents" for a cell on a given worksheet and the little arrow picture shows that it has dependents on other worksheets in the workbook, how can I find out exactly which other cells of which other worksheets are dependents of the original cell?

Hi, I need a formula that will add the values in column B for each member (Member names are sorted alphabetically): Column A - Members Column B Sum (Required result) Member 1 4 10 Member 1 6 Member 2 4 4 Member 3 3 5 Member 3 1 Member 3 1

Hi, I have a database in Excel, where Column A have 100 specific values, that are updated each month, and column B have a price, and Column C have the date which the values have been updated. But some month not all values are updated may only 60 or so. I need a way to get the values closest...

Hello everyone, I have a macro that insert new blank rows, then copy and paste some rows, based on a input userbox. Those last rows contain formulas but, once pasting them, they become incorrect (problem of references). I'd like to make the formulas dynamic in the macro code (via R1C1) or via...

I have this formula, I am running into an issue when I want the nth value, but it matches the nth value for another column, then does a match to get what value in this column. Visual is below. Column B matches the index of Column C to return a value based on the value. I want it to show what the...

I have this formula, I feel I am making a very small mistake, but I keep receiving the #N/A error. I've been working on trying to find a fix to it for about 2 days now, any help would be greatly appreciated. 1 2...

Hello, I have a spreadsheet with column I where there is a lot of data. I have the 1000 which is the sum of the 2x500 (bold) The 2x500 are the sum of the data (first one is 200 =300 and second one is sum of 5x100) I would need a VBA that would populate the formulas taking in consideration the...

DEFGHIJKLMN21 varm1 varm1 varm1 varm1 kold1 varm#VALUE!#VALUE!#VALUE!31 varm1 varm1 varm1 varm00040260,00 kr.42 kold2 kold2 kold0001 varm16455,00 kr.51 varm1 varm1 varm1 varm1 varm1 varm1 varm70455,00...

Hello, I have a problem that I can't find any information on online. I hope someone here can help me. I work with excel workbooks that have several spreadsheets (tabs). On some of the workbooks (no rhyme or reason I can find), any formula that is pulling data from another spreadsheet within...

So I have a master list of inventory that I have accumulated over the last 8 years (Over 7000 items). I am looking to actually inventory my 'on hand' items (approx 1000 items) into an excel spread sheet. 'Parts Costs' pic has the exact set up of how my inventory list has been accumulated over 8...

I'm trying to label rows as "Duplicate" in Column Q if i have a duplicate phone number in Column G across multiple tabs. I'm struggling with the formula. So far, I have: =IF(COUNTIFS($G$8:$G$2020, G8, 'FW 4'!$G$8:$G$2020, G8),>1,"Duplicated","") But it's not recognizing the second Criteria...

Hello, Currently having some issues when copy/pasting some range of rows. There are some formulas in there that would be populating depending of another table. So in the end there would be some rows populating from such table, and eventually remaining rows without populated values would remain...

Hi, I have two formulas that I would like to combine into one if it’s possible. Formula 1. =IF('ROTA 1'!$C3="LAPSED","",RIGHT(IF(ISNUMBER(SEARCH("RTO",'ROTA 1'!E3)),"",'ROTA 1'!E3),9)) If cell E3 = (*)0655-1425 it will return 0655-1425 If cell E3 contains RTO it will gave a blank...

Hi all, I have a date which is 31/12/2019 and when i use this formula : =WEEKNUM(E8435,21) its returning week 1 2019 My question is why doesnt it show week 52 2019 Any help is appreciated.