find grid coordinates for particular data

[Traymond]

I hope I can explain what I need. I want to know the coordinates in the grid based on value in a cell . i'll lay out a sample of what I need the code to do.

I have as many as 12 cells in a column that the grid gets populated with. for example I need to make a list of cell coordinates that contains the textf FBI. as you see in this example none of the TR data exists in the grid but this is not always the case. the grid will
pull from those 12 cells at random, so I need it to work down the whole list or column of 12 cells. hope I explained this correctly. I also uploaded a file that
maybe explains it better. Thanks for any help offered.

FBI 101,105,111,113,122 and on and on
FBA 102,103,104,112, 114 and on and on
CPI 121, 211 and on and on
CPA 404 and on and on
TRA
TRB
TRC
TRD
TRE
TRF
TRG
TRH

[Glenn Kennedy]

Cast a critical eye at your post and then post a sample spreadsheet.


Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

However, nothing on this Forum works quite as well as you might expect. The attachment icon doesn't work!! (Helpful, isn't it!!). Instead, just before you submit your post, click on GO ADVANCED (near the bottom) and then scroll down to Manage Attachments to open the upload window. The relevant instructions are at the top of that screen.

[Traymond]

thanks, I noticed that . I added file

[Glenn Kennedy]

Some more Q's for you.

How large is your real dataset? Using formulae, I have (so far) only covered two of your ten rows. It works, but a ten row solution will be cumbersome. A hundred row solution will be impossible (unless someone else sees something blindingly obvious that has escaped me).

If your real dataset is bigger than your posted sample, I think that you'll need VBA to get a workable solution. In which case, I would be inclined to post again in the VBA sub-forum and ask one of the Moderators to close this thread. I can copy other people's VBA, but don't know enough to write any. Way beyond my pay grade (pay grade... if only!!).

Formula as used in sheet:

Please Login or Register  to view this content.

This is an array formula. Array Formulae are a little different from ordinary formulas in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.

You will know the array is active when you see curly braces { } appear around the outside of your formula. If you do not CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly braces yourself - it won't work...

[AB33]

Try the attached code. It works on the sample attached. If you change the layout and data, I also need to change the code.

[Glenn Kennedy]

Thank you!! AB33