excel help

  1. B

    Entering values in adjacent columns in VBA

    I wanted to run a macro in which it returns the values in adjacent columns from a website for ex: selecting a range("A1:D100") in A1 it returns course of person in B1 it return status of that course and again C1 it returns course of different person D1 it returns status of that person.
  2. M

    Need help writing excel formula please

    Hello, I'm stuck writing a excel formula and need assistance and hopeful someone can help please! I'm trying to write a formula that I can drag down column "P", that will analyze that row from (B:O) for the cell that has the first "1" in it, from left to right order, and return the header...
  3. S

    Format mobile numbers in excel

    Making WhatsApp data. Wanted excel file into neat & clean format. Final Format in excel be look like this: usa & canada: +1 123 456 7890 europe:+49 xx xxxx xxxx Middle East:+971 xxxx xxxx asia:+98 xxx xxx xxxx Please remove brackets, dash or any unwanted character if it contains. You can...
  4. B

    Price sheets

    I have pricing I send out on monthly basis to distributors. First column is the base price which could be $22.98, $19.01, etc. next column is the base price +$1.50, last column is base price -$1.50. How do I get the last digit in pricing to always be a 6, I.E. base price = $22.48 + first...
  5. Q

    IRR Help

    I am getting different returns when calculating for IRR. The far right is the "desired" ending return that should be populating in the IRR column as well (I pasted these numbers in the desired column and am using the formula below for the IRR column). I was able to get the first year to match...
  6. E

    Parsing Data / Advanced Text to Columns for Non Uniform Data

    I was hoping someone would be able to assist me with a question I have regarding a text-to-columns type scenario. I have copied names, number, address and titles from a website but when i past it into excel it all goes into column A. Normally, if the data was uniform and consistent, you could...
  7. K

    List of URL Images to export and rename

    Hi I have an excel sheet showing the SKU and image URL i need a way to export these to a folder on my desktop (New Folder) i understand there is a way of doing this with a macro and the ones i have found i can't seem to get to work. The excel sheet is Column A | Column B SKU | ImageURL...
  8. R

    Combine IF and WORKDAY functions in Gantt

    Hi I need help to plugin the Workday & Holiday formula to my existing formula to calculate the number of days. =IF(D9="","",IF(F9="",E9-D9+1,(E9-D9+1)-G9)) In above formula: D9 is the start date E9 is the End Date F9 is manual column to calculate the % of work completed and G9 has the...
  9. N

    formula to extract the number from each cell

    Hi, Can anyone help please. I have a table where I need to extract just the numbers from a cell. The problem is that not all cells contain a number so the cells that do not contain numbers need to be ignored. I have added an extract from my workbook below. <tbody> Walton Vale 1977 UK HQ...
  10. J

    How do I delete text ONLY from a Cell containing both numbers and letters?

    I have a spreadsheet and it uses when the data imports it displays Ex- ".87 (ft)". having the text and parenthesis in the cell give me an error on the output of the program. There are thousands of these measurements, so I am looking for a quick way to accomplish this.
  11. M

    help I can not get this to work

    =SUMIFS('Facebook data'!D:D,A:A,">="&Sheet1!A2,'Facebook data'!A:A,"<="&Sheet1!B2) what am I doing wrong please help
  12. T

    Index and Match - with 2 criteria AND a date range...

    Hello, I have a doozy here and any and all help is truly appreciated. I am trying to create an Index and Match function that is looking for 2 criteria - a user ID and a date within a range. I have created this array that is looking for the user ID and the specific date...
  13. N

    a little odd: Need to convert TODAY() date to two digits 0000 and use 2 letters + 6 random number formula

    Hello, I'm breaking my head here, I understand a little =Tex which changes my TODAY() cell in another cell to 0406. Now I would like to add initials at the front like CS0406 followed by 6 random numbers. CS0406123456- It's killing me, can someone help? It doesn't have to pull the date from the...
  14. K

    Invalid Reference Error on INDEX MATCH to image

    Greetings all! I am a new member to MrExcel Discussion Boards, but have relied on your wisdom for years. Unfortunately, I came across an issue that I cannot find a solution to, and I have tried searching everywhere for an explanation. I will try explaining as best as I can, please let me know...
  15. K

    Invalid Reference Error on INDEX MATCH to image

    Greetings all! I am a new member to MrExcel Discussion Boards, but have relied on your wisdom for years. Unfortunately, I came across an issue that I cannot find a solution to, and I have tried searching everywhere for an explanation. I will try explaining as best as I can, please let me know...
  16. M

    Moving Data into one Row Based on ID and First Mention

    With the below spreadsheet, I am attempting to have one row per unique identifier. You can see in the 8 empty columns to the right, I need to show if and when each person first attended each of the 4 steps as shown in the Attribute column. However, since some people may have attended one of the...
  17. H

    Excel Recalculate Specific Cell Random Numbers

    Hi, I'm having a problem with a specific issue and looking for help, i'm not a excel expert, so please explain in layman's terms. Setup I have a set of randbetween 1-100 in A1:A100, then in Column B1:B100 1 to 100 in sequential order (1,2,3,4,5,etc...), in Column C1:C100 a formula (A1*B1...
  18. S

    VBA Code- To Update Data Validation Drop Down to first date

    I have a data validation drop down that chooses a range beginning with =Today() and then goes out 7 days. When tomorrow rolls around the worksheet requires you to go into the data validation drop down and select today's date. As the data validation box does not auto-refresh. Is there any way to...
  19. D

    VBA to track History changes from a worksheet to a new worksheet

    Hello I need help and not able to find my solution. I have in a sheet called TOC on cell J33, which updates every 2 minutes based on a = function to another sheet that uses a api query. My goal is to track last value (history) before it updates, and have the data output on another sheet...
  20. M

    IF one date falls on/between 2 others AND a cell matches, then return result

    Hi Experts, I would really appreciate some guidance as I cant quite figure out what formula to use. If this was already answered previously, I cant seem to find. I Already spent hours on forums and youtube videos. Perhaps I am wording my question wrong? I have thousands of rows of ITEM #'s...

Some videos you may like

This Week's Hot Topics

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
Top