# Filtering With Duplicates and Max for Entire Row Output

1. ## Filtering With Duplicates and Max for Entire Row Output

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.

2. ## Re: Filtering With Duplicates and Max for Entire Row Output

Let's say I have this:

A B C D E
200 219 2017 M 35
201 219 2017 M 35
202 219 2017 M 35
203 219 2017 M 35
204 219 2017 M 35
205 219 2017 M 35
206 220 2017 M 35
207 220 2017 M 35
208 220 2017 M 35
209 220 2017 M 35
210 220 2017 M 35
211 220 2017 M 35

And it should output: (multiple columns, with highest of column A, given Column B) with forumula
205 219 2017 M 35
211 220 2017 M 35

3. ## Re: Filtering With Duplicates and Max for Entire Row Output

With output outcome in G1:K9
H1=B1
H2:
``Please Login or Register  to view this content.``
Drag H2 down

G1:
``Please Login or Register  to view this content.``
Drag down

Copy column G to H, I, J, K

4. ## Re: Filtering With Duplicates and Max for Entire Row Output

Thank you thank you! Looks wayyyy harder than I thought, would never be able to figure that out.

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1