Find Second Occurence of Text...

E

eblake

Active Member
Joined
Aug 18, 2004
Messages
258
I know i've seen this here before but after searching for a bit i've been unable to find it. :(

I need to find out what column some text is in, but I need the second occurence of the text, I've been playing with index/match/vlookup but can't seem to get what I need.

The text is in Row 2 and i need the second occerence of "Cust/LFO"

Any help would be greatly appreciated.
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Sort by date Sort by votes
=ADDRESS(2,MATCH("Cust/LFO",INDIRECT(ADDRESS(2,MATCH("Cust/LFO",2:2,0)+1)&":XY2"),0)+MATCH("Cust/LFO",2:2,0))


This should work, it will give you the cell reference of the 2nd apperance of "Cust/LFO".

I did not know how long the data in row 2 goes on so I chose XY2 as where it stops looking, possibly you will want to change that.


hope this helps
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question
Most frequently occurring text in array formula
Replies
5
Views
61
Fluff
Fluff
C
  • Question
Excel Userform Listbox Search issues
Replies
3
Views
125
Akuini
Akuini
B
  • Question
Excluding a cell from MINIFS calculation - error when excluded cell is equal to first cell in range
Replies
2
Views
238
FormR
FormR
A
  • Question
Microsoft Excel VBA to : Find text from specific cell.
Replies
2
Views
323
Andrian2712
A
G
  • Solved
Finding previous number to sum
Replies
9
Views
90
Fluff
Fluff

Forum statistics

Threads
1,214,952
Messages
6,122,457
Members
449,083
Latest member
Ava19

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top