Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a sheet with a cell that contains a text value. On sheet 2, is an
array contains the value from sheet one in column a, along with more values...different names. But the name appears much more that once. I want all the values from column b on sheet 2, that match the value on sheet one, which appears in column a on sheet two. I need them all together though, at the top of the sheet. I have been able to get it, but it appears in the position on sheet one, that it was in sheet 2, which is too many spaces in between. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combining data from cells from several excel sheets to a new sheet | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |