Hello,
Hope I explain this well:
I have tried multiples ways and nothing seems to be working right, even though it seems very easy if my head!
I need to return an entire row based on criteria in columns A and B. Column A is 1-100. And Column B is random numbers, but there are some duplicates. So I want to return the entire row for each row (and of duplicates), using the highest of Column A for each column B. Is that possible with a function??
Not to mention have to add this to another already long equation, but will worry about that after.
Bookmarks