Excel Query Question

dennisplove01

New member
Joined
Jun 28, 2018
Messages
3
Reaction score
0
Points
0
Excel Version(s)
2010
Have a question. I'm in Florida and I have an assessment for an indoor soccer facilities management position. See question below.
I have a data query that outlines the different people that sends us business from various agencies. I want to know which agent from a specific agency have sent us business. I need to present this in a table. I tried vlookup and hlookup and nothing. I also tried if formulas but nothing. Please help! Thanks!

 

AliGW

Administrator
Joined
Nov 8, 2015
Messages
1,785
Reaction score
1
Points
38
Location
Ipswich, Suffolk, England
Excel Version(s)
MS 365 (Beta Insider Channel)
Could you please attach a sample workbook showing what you've done so far and manually added outcomes as you wish to see them? We can't really hlep without.
 

dennisplove01

New member
Joined
Jun 28, 2018
Messages
3
Reaction score
0
Points
0
Excel Version(s)
2010
I private messaged you. Can you please respond when you catch a break?
Thakns
 

Pecoflyer

Admin Alumnus
Joined
Oct 13, 2011
Messages
1,766
Reaction score
0
Points
36
Location
Brussels Belgium
Excel Version(s)
2010 on Xubuntu - O365
Last edited:

dennisplove01

New member
Joined
Jun 28, 2018
Messages
3
Reaction score
0
Points
0
Excel Version(s)
2010
If I include the attachment here it's open to the public and I will run the risk of the recruiter finding out
 

AliGW

Administrator
Joined
Nov 8, 2015
Messages
1,785
Reaction score
1
Points
38
Location
Ipswich, Suffolk, England
Excel Version(s)
MS 365 (Beta Insider Channel)
And why would that be a problem? Are you trying to cheat in an entrance test?

If not, then provide a desensitised version of the file.

As has been mentioned, we don't provide help via PM, so I will not respond to your message there.
 
Top