5/1/2019

  1. L

    Assign "grading" based on multilpe criteria

    I have a table of data with multiple fields that I need to include to assign a classification, or "grade" to. For example, in my data, I have: department floor set date region average rate of sale I need to assign an "A" to those items who are in the top 30% of rate of sale for each...
  2. F

    Offset Match Match with multiple Vertical Criteria

    I'm using the below formula <colgroup><col span="13"></colgroup><tbody> End Result Chart (ER) Model (M) Basis Tab (BT) A B A B C… A B C… 1 5/1/2019 1 5/1/2019 6/1/2019 1 5/1/2019 6/1/2019 2 OK 510 2 Total OK 510 500 2 Total OK OK 3 TX 690 3 Total TX 690...
  3. M

    compare for equal numbers and color code

    I just want to compare two different reports total to check if the numbers in bold matches. For report A, the January 1 total number 800 is not correct comparing to report B. Because 200 item are not recorded so I wan to flag that with color or other best ways. The same with May 1 records. I...
  4. S

    find a value in a column with duplicates and return first value

    I want to find the value in A1 in column F and return the corresponding date in column E in cell A2 as shown below. I am trying to avoid creating a lookup table and vlookup to do it. Column E and F have duplicates so I just need the date upon the first match of the value. <colgroup><col...

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