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.
