excel help

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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.
  8. 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
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. M

    Multiple if or vlookup need help

    <tbody> Rule Born Trigger Variable XYZ Texas Texan A or B or C or D ABC New York New Yorker A or B or C or D RST RST A or B or C or D WXY WXY A or B or C or D DWF DWF A or B or C or D </tbody> Hello I need help with this excel formula. Basically I always have data in Rule column...
  19. I

    Conditional Formatting not highlighting duplicates correctly

    I am trying to remove items from my catalog that are discontinued. I added the column of new P/N so I can match it up with my current catalog to quickly identify those products. Those that are not highlighted should be the discontinued items. However, I see P/N that are highlighted when there is...
  20. F

    New to using excels charts

    I am new to using excel for charting. I was asked to prepare charts or tables that will effectively answer the following questions: Of the subsectors noted in the table, which produced the highest number of fatal claims in 1990 – 2014 for: · Pneumoconiosis (make sure to include...

Some videos you may like

This Week's Hot Topics

  • VBA code giving errors and stopping Excel
    Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
  • Disable MsgBox message
    Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
  • Macro Recorder into VBA, Copy Paste Data Filled Cells
    Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
  • Number format changes while pasting into a cell
    Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
  • Collating data
    Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
  • Sum Multiple Columns Based on Multiple Criteria
    I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...
Top