Hi everyone,
In the attached file, the problem is listed on Tab 1.
I just need to find a way to count unique values but using a formula that would look up data in both tabs at the same time. The correct answer is provided in Tab 1. Can someone enter the required formula in the two highlighted yellow cells?
Thanks!
This issue was solved by forum members "Harribone" and "Lemice" in the Excel Formulas and Functions forum, so I'm marking this thread as solved. Link to the thread with solution is listed below:
http://www.excelforum.com/excel-form...xcel-tabs.html
As always, thanks to all the contributors for their expert assistance!
Rshukla,
For further reference, please remember that its against forum rules to open a duplicate thread. You are duplicating efforts. If you have not received a reply, you can bump your thread.
Thread duplicate, hence closed.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks