We help IT Professionals succeed at work.

Need help with an Excel Formula

103 Views
Last Modified: 2017-04-09
I have a xls with two sheets...   ACCTs and opps

In ACCTS column B is an account name
I need a formula for column P that will be the number of lines found in sheet opps where column B ACCTS is found in column B opps
Comment
Watch Question

CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Matt PinkstonEnterprise Architect

Author

Commented:
awesome