Find the row number with a partial match to text in column A

**zookeepertx** · 10-10-2014, 12:32 PM

Hello,
I have a worksheet that I need to sort by column A. That's working fine, but then I need to take the block or rows where the text in A starts with IFS. The text in the rest of the cell will vary. So, I need to get the row number of the first and last occurence of IFS..... in column A.

Most of the rows start with IFS, but there are always some that don't

I have tried every syntax I can think of, googled and searched this forum until I'm blue in the face and can NOT solve this. I'm sure it's very simple, but, apparently, so am I, LOL!

Here is my most recent attempt:

Please Login or Register  to view this content.

This one highlights the last row and says "Object Required"

I will really appreciate any help on this!

Jenny

**judgeh59** · 10-10-2014, 12:40 PM

Give this a go

Please Login or Register  to view this content.

**zookeepertx** · 10-10-2014, 12:43 PM

Perfect! Thank you!
(See, I knew I was just overlooking something. DUHHH!)

Thanks very much; works great!

Jenny

**judgeh59** · 10-10-2014, 12:46 PM

glad I could help and thanks for the rep points....

**zookeepertx** · 10-10-2014, 01:08 PM

One other question:
Sometimes, but not always, there will be a row(s) that, after the sort, ends up before the IFS rows. I tried Cutting all the IFS rows and inserting them after row 1, but it won't let me do that. So, alternatively, is there a way to see if there are rows between row 1 and the first IFS row and, if found, insert them after the last IFS row?

Thanks again,
Jenny

Never mind; I figured it out. Just had to add this:

Please Login or Register  to view this content.

**judgeh59** · 10-10-2014, 01:30 PM

so I'm making this up as I go along because I don't know what your data really looks like...so the first code was "Presorting" and this code is PostSorting...

Please Login or Register  to view this content.

**zookeepertx** · 10-10-2014, 01:37 PM

Awesome! Thanks!

Jenny

**judgeh59** · 10-10-2014, 01:39 PM

no problem

Find the row number with a partial match to text in column A

LinkBack

Thread Tools

Rate This Thread

Display

Find the row number with a partial match to text in column A

Re: Find the row number with a partial match to text in column A

Re: Find the row number with a partial match to text in column A

Re: Find the row number with a partial match to text in column A

Re: Find the row number with a partial match to text in column A

Re: Find the row number with a partial match to text in column A

Re: Find the row number with a partial match to text in column A

Re: Find the row number with a partial match to text in column A

Thread Information

Users Browsing this Thread

Similar Threads

Search variable number of sheets to find partial match on name

[SOLVED] Match partial text when partial text is not exact

[SOLVED] Need help - Match number in column, find lowest number in that row, and return header name

Find Partial Text Match between Two Columns of data

Help Converting Partial Text, Partial Number Cells to Number Only

Bookmarks

Bookmarks

Posting Permissions