Columns (1-4) are headers
1) Name
2) Data
3) Unique ID
4) $
I would like to show the Max $ amount assigned to Data. Unique ID is based off Data and Name (1) is added if Data and Name differ. Currently I've singled out the Data through unique formula and power pivot, but many "Data names" have multiple spellings. I can easily identify multiple spellings with power pivot, but trying to have dynamic display for reporting.
Is there an index/match formula nested within a If formula that can identify all the "Data names" as being the same if containing "x" and then bring back Max Value?
-Statements-
If Data (B2) and ID (C2) = B1/C1 then Sum D1:D2
IF Data (B2) and ID (C2) does not equal then sum D2 ****
****If B1 and B2 both have same "Data name" but different ID show MAX value based of data name - in 14 days another "Data name" could come up that is identical (different creation date/ID) - if that is the new MAX then show that value.
On my attached worksheet - Examples "The Bird Perch" "Warhorse" and "Riverside" are prime examples of the above request.
Bookmarks