2nd

Hi. I have 2 tables , first has people details , 2nd has these people visit (mob number , name surname there is in both tables and mobile is relationship one to many). I need when in 2nd table i put the phone , name and surname auto filled Thanks

I am looking to get the 2nd Largest Value with Criteria Avoiding Duplicates, essentially I want to find out every customer in my records their min, max and 2nd to max ship date This was my original take on it, '={LARGE(IF([Column2]=[@Column2],IF([Ship Date]<[@MAX],[Ship Date]),[@MAX]),2)}...

Hello, I need to figure out how to grab the 2nd largest value with criteria and avoiding duplicates. essentially i have a list of transactions and I need to say what is this customer's last time they ordered and 2nd to last time they ordered. Thank you so much!

Hi all, My first query here. I am from a development background and lack the VBA know how to get this work done. Any help is much appreciated. I have 2 spreadsheets, with around 2000 rows of data with 55 columns. I need to match data between the two sheets based on 10 columns given to me by...

I've got a row (Q1:BH1)with mutually exclusive dates. My 2nd row has formulas (Q2:BH2) that pull in related data. I've also got 1 cell with a specific date (Q13) If a date on my first row matches to the date in cell Q13, I want to copy/paste special values in the 2nd row in the cell below the...

Hi All, Anyone here can help on a VBA script to copy 1st and 2nd sheet from a closed workbook to currently opened workbook overwriting and contents of sheet 2 and 3? The 1st and 2nd sheet names of the closed workbook changes dynamically so please don't rely on the sheet1 and sheet2 names. The...

Hi, I have the following formula that works well, is there a way I can use it & take the 2nd 'hit' it finds? =IF(ISNA(MATCH(A6,'Yr6 Wk1'!$C$5:$C$252,0)),"",VLOOKUP(A6,'Yr6 Wk1'!$C$5:$D$252,2,FALSE))

Hello, I have the following website: http://greyhoundbet.racingpost.com/#dog/race_id=1596517&r_date=2018-03-15&dog_id=508369 Which I then can get just the block details by using the following URL...

I have the following table sample. I need to indicate in the Shipment column,the first time something with the unique ID , the 2nd.. etc. it has to be based on date and not location in the sheet. And if the ID does not repeat then it is the 1st shipment...

Hello Column B has a list of codes B2 and B3 are the same location code 2 line items are required because each site will get 2 ciircuits From the data sheet I am provided it has COL M is 1 IP address COL N is 1 IP address COL O is 1 IP address COL P is 1 IP address What I need is for a lookup...

I've searched and found some things that are similar, but not exactly what I want (i.e. Index/Match). I want to look up the 1st largest value and return what is in column A. I'm then repeating for the 2nd, 3rd, etc. Here is the formula I have, but the output for the largest and 2nd largest are...

Hi, I am wanting to find the 2nd occurrence of "Buyer Comments:" on my sheet and have it return the cell below it. I have been using this code: but it catches the first one. Thank you!

I am trying to write a formula that will calculate Accounts Receivable due dates. Some of the due dates are easy, because a few of our customers have terms of Net 30, Net 45, etc. However, a handful of our customers have due dates that read: "2nd day / 2nd month". In other words, if the...

Hello, how to I count the 1st, 2nd, 3rd... occurrence in visible (filtered) cells? I used =COUNTIF($A$7:$A7, $A7) with all cells, but how to convert to filtered cells? The date I want to count is people's name, ie not number. Thank you!

hi guys, I am trying to find the harmonic mean for the range X10:X1329, but only want to include rows where AE10:AE1329 = "W" When I have resolved that I want to move it further forward by adding a 2nd condition, ie, A:A meets the same data in cell R1338. Any ideas, I have tried if formula...

I have a workbook with multiple worksheets. 1st sheet contains data - 000's of rows with many cols (one of which is txn #) On this sheet, a given txn # may have multiple rows associated with it (the txn # is the same but each row has specific data). 2nd sheet has list of 20 unique txn #s On 3rd...

<tbody> 0 10 20 30 40 50 60 70 80 90 100 121.8 124.5 127.2 129.9 132.6 135.3 138 140.7 143.4 146.10 148.8 </tbody> Given the table above where in the first row is Weighted while the 2nd row is a target value. If i have an actual value of 132.6 the result (as per the first row is 40), My...

Excel novice(at best) Timetable data.csv file Example/excerpt: Wish to extract to 2nd sheet only flights valid for 7 day period beginning Jan/14 ending Jan/20 from following.... Jan/1-Jan/13,ABR,5:00AM,MSP,6:20AM,123456,7365,CRJ Jan/16-Feb/28,ABR,5:00AM,MSP,6:20AM,123456,7365,CRJ...

I have a file with 2 worksheets. The first one is for entering certain employee fields, and the 2nd worksheet shows all current employees. One of the input fields in the first sheet is for a JOB_CODE number. Is it possible to link that to the 2nd sheet where as soon as I enter that JOB_CODE...

I'm not sure if this is possible , if it's not possible please let me know. Any help will be appreciated. I'm trying to extract a list from A if B matches " Yes " without showing the errors , completely ignoring the errors. What I usually use is Index and match to return criteria , but it...