Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I've been given a question in excel and I think it can be done but
can't figure out how to do so. The worksheet they have has in Column A - a description of a certain object in Column B it lists the stations that the object was found and seperated by commas. EG: Object 1 | 1,2,3,4,5,6,7,8,10,11,13,15,16,17,18 Object 2 | 2,3,6,7,8,10,11,13,18 Object 3 | 5,15 What they want to do is to have each station as a column..... So the headings would be...... Object, Stations Found, 1,2,3,4,5,n,20 I started doing a formula =FIND($C$1,$B3,1) but when it got to Object 2, it found 1 in position 11 because of the number 11..... How am I able to search by "exact" within that array? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
identify numbers and text differently in formula | Excel Discussion (Misc queries) | |||
How to identify same row matches in two columns of #s using Excel | Excel Discussion (Misc queries) | |||
Identify number of items with characterisitics from two columns | Excel Worksheet Functions | |||
identify different data in two columns | Excel Discussion (Misc queries) | |||
identify numbers which are listed in two columns. | Excel Worksheet Functions |