Hi all,
I have two name manger data sets that I'd like to search within itself. Example being I have 45 "Blocks" outlined within the sheet. Each block has its own Name Manger set, I also have a much larger data set that refers to the "Modules" distributed to the site. That is broken down into 3 separate Name Manager sets. I want the main search to be within the "Block" (which will give the value of 80) but within that 80 value, find the "Module" amounts within the confines of the Block.
The best I can think of is what's below:
=CountCellsByFontColor(Module!Block_01,B87),(Module_430w,B87)
Any suggestions or help regarding this would be greatly appreciated.
If I haven't made myself clear enough, I will try to reply with a better breakdown but I think this tell everyone what it is I need.
Cheers,
Shonky
Bookmarks