2nd

I have a folder with a lot of files of the form: defects_*.txt Assuming the path to the directory containing these files is C:/Path, how can I load just the second column of these txt files into excel? So column A would be the 2nd column of defects_002.txt, column B would be the 2nd column of...

I have 3 different conditions and I am trying to use vlookup. Only the 1st if(and statement works. The 2nd and 3rd if(and return FALSE from the vlookup (***note each if(and statement works by its self***). Can I use if(and vlookup with the statements below?. The 2nd set of code works...

Hi everyone, I was checking previous posts but I am not able to amend the formula in the way I wished. So I have following table <tbody> 1st week 1000 2nd week 2000 3rd week 5000 </tbody> In C1 I need a formula that multiply B1*0.5 if A1is "1st week", if A1 is 2nd week multiply...

Hi, I am using the below formula to try and get the the following information: I am asking it to look for a name in the left cell of the main sheet and then look at the 1st column of the 2nd sheet to find it, then index the 2nd sheet data and match "Two Man" in the 2nd column of the 2nd sheet...

Hi all, I have the following set of data: <colgroup><col><col span="2"></colgroup><tbody> Name Event Place Athlete 1 A 1st Athlete 1 C 1st Athlete 1 D 1st Athlete 1 E 1st Athlete 2 C 2nd Athlete 2 D 2nd Athlete 3 A 2nd Athlete 4 E 2nd Athlete 4 F 1st Athlete 5 B 1st...

Hi Guys, Currently using windows 7 and Excel 2010. I have 3 excel sheets. In the first sheet it contains my charts. In the 2nd sheet are where all my chart data's are. And the third sheet are all my source data. Depending on the option selected in the chart the 2nd sheet data would change...

I have 2 tables, A and B, and I would like to find where the rows are not exactly the same. For example: I tried doing the find unmatched query wizard but that seems to only bring in where table A does not have an ID? So I would only get the 2nd line of my desired output. If I got the...

Hi everyone, May I know if there is a solution to convert my json file to excel format... below data extracts from json... I would like to show 1sr row:add_amount,available_amount,budget_account_code,budget_account_name... 2nd row:0,0,R13006,A123... 3rd row:0,0R13006,A1234...

Hi, I have created a vba script to access my bank Internet site (i have successfully entered the user Id and password) but on the next tier of passwords it asks for 2nd 3rd and 4th digit of a pin and also 1st 2nd and 3rd digit of a password. I have tried to find the source code for the...

Hello, I have been really struggling with this, I need a formula that can extract the data before the 2nd to last dash. I have thousands of lines of data, and the data are all different lengths, with different dashes. Here is an example of data and what I need to extract <tbody> Data...

Hi, Looking for a formula... I have a columnG with names and the value that I want returned on column Y BUT I need the 2nd to last value. Is that possible? For example, COL G COLY John Taylor apple John Taylor carrot John Taylor cucumber John Taylor...

Hi, I'd have 2 separate data sources, 1 is a list of values that's automatically sorted highest to lowest. I have a formula that puts a Y next to a value if it meets a criteria. (This is in column B). What I'd like in column A is to place a 1, 2, 3.. but skip if the value in B is a Y. I only...

I'm using this to load a Listbox on a Userform as the form is loaded; ListBox4.RowSource = Range(Sheet5.Range("U2"), Sheet5.Range("U11").End(xlUp)).Address(, , , True) I now need to take this a step further if possible - I now need to load only those values where the value of the 2nd offset...

<tbody> ID TEAM (WIN) SCORE BET AOS </tbody> Hi, im new here, i really need help about the betting system i create. as you can see at the top. 1. ID 2. TEAM (WIN) 3. SCORE 4. BET 5. AOS i have problem when it comes to the score and the bet, which is i create like this: im using the...

This one has got me puzzled and I'm sure there is a simple solution. I have a long list of rankings for various statistical tests, i.e., A 1 B 2 C 3 A 2 B 3 C 1 and so on. I just want to determine how many 1st, 2nd and 3rd place rankings of A, then of B, etc. There is no real range to use a...

Hi, How can I create a function that looks at a date in a cell and returns the week number? But the week number isn't starting from 1st Jan but actually for this year 2018, it's August 27th which is a 53 week year. For 2019 it's September 2nd. Thanks,

I have an excel column with about 5000 rows of text. Is there a quick way to delete every 2nd and 3rd row? There is nothing in the text that would allow me to filterin a smart way. Currently 1 2 3 4 5 6 etc. I need to delete rows 2,3 5, 6 and so on. Thanks

I have 2 spreadsheets. I need a way to compare the entire row from sheet 1 and if that row matches any row in sheet 2 then copy all of that information to a 3rd sheet. Or if it is easier to just highlight the entire row in the 2nd sheet because it is a duplicate from the first sheet. Sheet 1...

i have two dates and i want to get the month between it but the problem is my first date is in different cell the year is in B2 and the month is in B3 and the 2nd date is in one cell in F2, like this <colgroup><col style="width...

I have a list if ID's in column A where some ID's are repeated and column B I have a list of dates. I want to be able to find the latest date for a specific ID and wondered if the best way to do this is to use VBA code to use the 'Find & Replace' option to find each instance of the ID and...