PDA

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