5/1/2019

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...

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...

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...

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...