2nd

  1. B

    excel copy 2nd column from multiple txt files

    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...
  2. J

    if statement with vlookup - returning false

    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...
  3. G

    Multiply ifs

    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...
  4. P

    If function with index and match not giving the data I need

    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...
  5. M

    Converting list to table

    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...
  6. K

    I have a Dynamic Chart. But Locking the data sheet prevents the Chart from working.

    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...
  7. S

    How can I find where the rows are not exactly the same for 2 tables?

    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...
  8. L

    json to excel VBA??

    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...
  9. D

    VBA Access Internet Multiple layers of password

    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...
  10. S

    Extract Data before the 2nd to last dash

    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...
  11. E

    2nd to last value using match

    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...
  12. L

    1, 2, 3.. IF formula and Rank If Uniques

    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...
  13. sharky12345

    Add items to Listbox based on criteria

    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...
  14. M

    Creating a betting system for personal use.

    <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...
  15. O

    A Counting Problem

    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...
  16. L

    Start Week 1 From September 2nd 2018 VBA

    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,
  17. R

    Delete every 2nd and 3rd row

    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
  18. R

    Script to find duplicates in 2 separate sheets and if the entire row is the same copy to 3rd sheet

    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...
  19. M

    Count Months between two dates, BUT,....

    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...
  20. M

    Getting the value of an adjacent cell when using Excel Find via VBA

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top