fromula

  1. A

    Display and count unique values in date range

    Hi all, Im standing in front of the task (see picture attached) and I cannot to figure it out . Does anybody has idea how to achieve desired result based on the criterias defined? The result should be done by fromula, not by pivot or vba. If possible, do not use any formula in data table... Im...
  2. gheyman

    Date Formula Problem

    I am trying to determine how much of a value goes in each Year based on the dates. (If my date range was 12/1/2018 and 1/1/2019 and a value of 48, my results should be 24 in 2018 and 24 in 2019) (If my Date range was 11/1/2018 and 1/1/2019 and my value was 30, my results should be 20 in 2018...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top