LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 60
Default Formula to identify text into columns

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
identify numbers and text differently in formula widman Excel Discussion (Misc queries) 3 November 14th 06 04:28 PM
How to identify same row matches in two columns of #s using Excel NBM Excel Discussion (Misc queries) 2 April 13th 06 06:00 AM
Identify number of items with characterisitics from two columns [email protected] Excel Worksheet Functions 5 April 2nd 06 01:07 AM
identify different data in two columns fitzy Excel Discussion (Misc queries) 2 July 20th 05 11:13 AM
identify numbers which are listed in two columns. the_kane Excel Worksheet Functions 1 March 8th 05 06:21 AM


All times are GMT +1. The time now is 04:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"