excel help

  1. 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
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. E

    How to resort data automatically

    I have 3 sheets of data. Sheet A: Has a drop down list with statistics (checks, sales, items) which drives the data on sheet C (see below). There is also a graph on this sheet that is based on the data on sheet C (see below). Sheet B: Has all of the raw data that the workbook is based on...
  15. D

    Removing zeroes in number format

    Our customer numbers begin with A followed by four zeroes and a string of numbers. Example: A00002121256438 A00002178164211 A00002191112936 A00002152291978 How can I create a formula to remove the 4 zeroes following the letter A so that the...
  16. A

    Vlook to get the latest date

    Hi mates. I'm working on a file where data is entered date wise and I need to keep a track of the latest date entered besides the last order received. When I'm using Vlook up, it shows the date which is on the top of beside that wendor's name but not the latest. As the latest date is mentioned...
  17. E

    Converting Data listed horizontally to vertical listing

    Hello, I have PDFs that I converted to excel. The PDFs contain a Subcontractor, General Contractor, and then every invoice#, invoice date, and invoice amount that that subcontractor has paid. When I convert it to excel the data all gets listed in one row. I would like it to be listed vertically...
  18. H

    One time transaction IRR Calculation

    I am trying to calculate IRR on a one time transaction as follows initial investment $6.1 Million Return captured 120 days later $17.5 Million our investment partner has an IRR threshold at which point we receive an equity claw back and higher percentage of the proceeds. I am having...
  19. B

    Seeking help in personalising the process of rounding off an amount in excel

    I would like to have a formula to round off an amount in a personalised way. To illustrate, if an amount comes to 830.70, then the amount will be rounded off to 830.00, but if the amount is 831.40 then it will be rounded off to 840.00. Which excel formula shall I apply to get desired result?
  20. F

    format in excel

    Hi Everyone, I have a sizing spread sheet that looks like this... style fabric S M L Jeff cotton 1 1 1 and I would like to rota it to look this this... style fabric Size qty Jeff cotton S 1 Jeff cotton M 1 Jeff cotton L 1 is there a...

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