help with Excel

[onlygod]

Hi

Quick question, in Excel, I have a table with RBS and Cells for this RBS like this:

RBS1 Cell11
RBS1 Cell12
RBS1 Cell13
RBS2 Cell21
RBS2 Cell22
....

Then I have a list of RBS, eg:
RBS1
RBS2
RBS3
....

I need to find all the Cells that belong to these RBS.

VLOOKUP with last value [range lookup] set to 0 will find the 1st cell and with 1 set it will find the last cell, but I can't figure out how to do this fully automatically. Any suggestions?

[kaizzer545]

Macro is the solution. .. according with the version of Excel you can find the Macro Programmer and make it automatically, thanks

[Walid Madih]

Hi

Quick question, in Excel, I have a table with RBS and Cells for this RBS like this:

RBS1 Cell11
RBS1 Cell12
RBS1 Cell13
RBS2 Cell21
RBS2 Cell22
....

Then I have a list of RBS, eg:
RBS1
RBS2
RBS3
....

I need to find all the Cells that belong to these RBS.

VLOOKUP with last value [range lookup] set to 0 will find the 1st cell and with 1 set it will find the last cell, but I can't figure out how to do this fully automatically. Any suggestions?

You can use Access it's a good tool for this kind of requests.

[mimoX]

Hi

Quick question, in Excel, I have a table with RBS and Cells for this RBS like this:

RBS1 Cell11
RBS1 Cell12
RBS1 Cell13
RBS2 Cell21
RBS2 Cell22
....

Then I have a list of RBS, eg:
RBS1
RBS2
RBS3
....

I need to find all the Cells that belong to these RBS.

VLOOKUP with last value [range lookup] set to 0 will find the 1st cell and with 1 set it will find the last cell, but I can't figure out how to do this fully automatically. Any suggestions?

for complex function, use built-in visual basic (even better than macro)
try post ur excel here.