C
CTR
Hi,
I have not been able to find the solution to my problem after searching
through the groups so I've decided to join and post my problem...
)
I have a long list of ID numbers in an excel spreadsheet which I would
like to extract certain values from. In another cell, I have a drop
down menu (data validation) which will provide the criteria for the
function to operate.
For example, if say, column B contains the following:
1A
1B
1C
2A
2B
2C
3A
3B
3C
I want excel to extract from column B, all the ID numbers that begin
with say, the number "2" (selected from the drop down menu) and display
the results in a row.
So, it should return with the following, in a row (separate cells):
2A 2B 2C
The actual ID codes are something like this: "D0771S" but I don't think
it will affect the above example.
I think my main hurdle is getting Excel to actually return a group of
results rather than simply extracting single values and present them
"transposed" in a row. Also, I would prefer to keep to formulas and not
go into macros/VB.
I realise the "extraction" part of this problem can also be done using
the autofilter/filter function, but this function will form part of
other functions where the results will work in conjunction with another
set of formulas etc so unfortunately filters cannot be used.
Many thanks for your help in advance!
CTR
I have not been able to find the solution to my problem after searching
through the groups so I've decided to join and post my problem...
)I have a long list of ID numbers in an excel spreadsheet which I would
like to extract certain values from. In another cell, I have a drop
down menu (data validation) which will provide the criteria for the
function to operate.
For example, if say, column B contains the following:
1A
1B
1C
2A
2B
2C
3A
3B
3C
I want excel to extract from column B, all the ID numbers that begin
with say, the number "2" (selected from the drop down menu) and display
the results in a row.
So, it should return with the following, in a row (separate cells):
2A 2B 2C
The actual ID codes are something like this: "D0771S" but I don't think
it will affect the above example.
I think my main hurdle is getting Excel to actually return a group of
results rather than simply extracting single values and present them
"transposed" in a row. Also, I would prefer to keep to formulas and not
go into macros/VB.
I realise the "extraction" part of this problem can also be done using
the autofilter/filter function, but this function will form part of
other functions where the results will work in conjunction with another
set of formulas etc so unfortunately filters cannot be used.
Many thanks for your help in advance!
CTR