**Question description:**

*This user has given permission to use the problem statement for this blog.*

I want a formula (or combination of formulas) to look up the matching values(full name) within one column and based on those matching look in 2nd and 3rd column (email in and email out in last 6mo) and indicate which one is the most/highest. If there is a tie, then look in 4th and 5th column (email in and out in last year). It could be indicated by a yes or number to say that that name.

Solved by E. H. in 40 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
07/12/2017 - 03:47

Hello

User
07/12/2017 - 03:47

hi again

Excelchat Expert
07/12/2017 - 03:47

I am sharing the file link with you

Excelchat Expert
07/12/2017 - 03:47

Please wait

Excelchat Expert
07/12/2017 - 03:48

https://docs.google.com/spreadsheets/d/141CmVVHNyy56ZzmbCTlEGBjOaRBsWNa2NCeWvIxn78s/edit?usp=sharing

Excelchat Expert
07/12/2017 - 03:49

Please open above link

User
07/12/2017 - 03:49

Is it possible to send as an excel file?

Excelchat Expert
07/12/2017 - 03:49

yes

Excelchat Expert
07/12/2017 - 03:49

please wait

User
07/12/2017 - 03:49

Thank you!

Excelchat Expert
07/12/2017 - 03:56

which version of excel are you using?

User
07/12/2017 - 03:56

2016

Excelchat Expert
07/12/2017 - 03:57

ok

Excelchat Expert
07/12/2017 - 03:57

do you have maxifs function in your excel

Excelchat Expert
07/12/2017 - 03:57

please check

User
07/12/2017 - 03:58

I only see MAX and MAXA. maxifs doesn't comeup

Excelchat Expert
07/12/2017 - 03:58

ok

Excelchat Expert
07/12/2017 - 03:59

my solution includes use of maxifs function

Excelchat Expert
07/12/2017 - 03:59

It won't work on excel

Excelchat Expert
07/12/2017 - 03:59

You can see it on googlesheet only

User
07/12/2017 - 04:01

oh drat. Can maxifs be split in two columns for max and then if?

Excelchat Expert
07/12/2017 - 04:01

It would take a lot of time then

Excelchat Expert
07/12/2017 - 04:02

again

User
07/12/2017 - 04:02

oh... can you give me the formula for a cell?

Excelchat Expert
07/12/2017 - 04:02

I didn't get you

User
07/12/2017 - 04:05

I'm going to try and open the link give me a moment

Excelchat Expert
07/12/2017 - 04:05

ok

User
07/12/2017 - 04:07

Think I'm in

Excelchat Expert
07/12/2017 - 04:07

ok

Excelchat Expert
07/12/2017 - 04:08

See cell K3 to O3

User
07/12/2017 - 04:09

yes

Excelchat Expert
07/12/2017 - 04:09

you have to select emailed contact from dropdown in cell K3

Excelchat Expert
07/12/2017 - 04:09

then O3 will show you the result

Excelchat Expert
07/12/2017 - 04:09

Please try

Excelchat Expert
07/12/2017 - 04:09

changing K3

Excelchat Expert
07/12/2017 - 04:09

and see result

User
07/12/2017 - 04:10

Cinthia should have work contact of Ross

Excelchat Expert
07/12/2017 - 04:11

ohh

Excelchat Expert
07/12/2017 - 04:11

please wait

User
07/12/2017 - 04:11

Thanks!

Excelchat Expert
07/12/2017 - 04:14

Done

Excelchat Expert
07/12/2017 - 04:14

Please check now

Excelchat Expert
07/12/2017 - 04:15

there?

Excelchat Expert
07/12/2017 - 04:15

hello?

Excelchat Expert
07/12/2017 - 04:16

Are you there?

User
07/12/2017 - 04:17

Sorry, Yes I'm back

User
07/12/2017 - 04:17

I'll check

User
07/12/2017 - 04:18

This will work for all 4 columns, E-H right?

Excelchat Expert
07/12/2017 - 04:18

yes

User
07/12/2017 - 04:18

Cool!

Excelchat Expert
07/12/2017 - 04:18

you just change the name in K3

Excelchat Expert
07/12/2017 - 04:18

you will get the result in O3

User
07/12/2017 - 04:18

Perfect!

User
07/12/2017 - 04:19

Thank you for your help!

Excelchat Expert
07/12/2017 - 04:19

Welcome

Excelchat Expert
07/12/2017 - 04:19

Thanks for your patience!

Excelchat Expert
07/12/2017 - 04:19

Have a great day :)

User
07/12/2017 - 04:19

You too :)

Excelchat Expert
07/12/2017 - 04:19

Please leave your valuable feedback :)

Excelchat Expert
07/12/2017 - 04:19

You may close the session now from above button.

Excelchat Expert
07/12/2017 - 04:19

BYe :)

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*