Hi there...
I would like cell G45 to show all Cabernet Merlot wines used in column P…and so on for the other varieties. How can I do that?
Hi there...
I would like cell G45 to show all Cabernet Merlot wines used in column P…and so on for the other varieties. How can I do that?
Named ranges
variety: ='2014'!$B$2:$B$40
usage: ='2014'!$P$2:$P$40
G45,etc:
Please Login or Register to view this content.
Ben Van Johnson
You want vba code or formula ?
Sub DontForgetThese() If Your thread includes any code Then Please use code tags... If Your thread has been solved Then Please mark as solved... If Anybody has helped to you Then Please add reputation... End Sub
Thanks a lot!!!!!!!!!!!!!!!1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks