View Full Version : Neighbours check
justdream
2009-10-22, 07:18 AM
Experts,
if you have already define dneighbours and want to check:
1) unmutual neighbours
2) Co BCCH between Source and target
3) Co BCCH between the same source's targets list
justdream
2009-10-22, 09:46 PM
here's an example of the format of the Excel sheet that I have:
kindly help me :hug:
justdream
2009-10-28, 02:21 AM
friends,
can you just show me how to let excel check if there's a co-BCCH between the sources' adjacent list as in shown in the attached picture 'taken from my excel sheet which contians a lot of these relations, so I'm wondering if there's a function to cheack all in one time instead of checking each sources' adjacent list one by one'
Thanks guys:hug:
eyaOpti_guy
2009-10-28, 04:45 PM
You will need a small VBA macro to do it for you...
friends,
can you just show me how to let excel check if there's a co-BCCH between the sources' adjacent list as in shown in the attached picture 'taken from my excel sheet which contians a lot of these relations, so I'm wondering if there's a function to cheack all in one time instead of checking each sources' adjacent list one by one'
Thanks guys:hug:
justdream
2009-10-28, 05:54 PM
thanks a lot, do you have it? :(
or could you guide me to do my first micro?
eyaOpti_guy
2009-10-28, 06:59 PM
http://www.functionx.com/vbaexcel/index.htm
justdream
2009-11-06, 07:36 PM
excuse me experts, if you already have macro to do it, please share with me
Adel K
2009-11-24, 06:53 AM
thanks it is so helpful
justdream
2010-01-10, 11:30 PM
Masters,
do you have good doc about Excel-macros 'step by step'?
it will be so nice to share in our lovely forum
guess.who
2010-01-16, 11:35 AM
share the file you want the macro in and i will write u the macro,,,
please share the proper sheet that u use so that u find my macro least difficult to use...and dont worry ur company'z data will b safe with me ... :)
secondly looking at your excel example file...i will need one change from u, that u do not leave the sites name blank if it the same as previous,,,, just repeat it....this way my macro will b easy otherwise i ll have to make a complicated logic..all the best
vBulletin® v4.2.5, Copyright ©2000-2024, Jelsoft Enterprises Ltd.