Excel Query Question

D

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!

 
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.
 
I private messaged you. Can you please respond when you catch a break?
Thakns
 
Last edited:
If I include the attachment here it's open to the public and I will run the risk of the recruiter finding out
 
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.
 
You must log in or register to reply here.
Back
Top