Find Last Cell In range, and changing another Cell based on offset text

**radar_jynx** · 05-04-2009, 11:07 AM

If i have a range say E12:O12 and want to find the last cell before blank, lets say it finds m12 as the cell with the value before blank. then with m12 it needs to determine weather row 11 in the same column has Text either "S" or "F" if "S" then m12 = t if "F" then m12 offset(1,-1) = t. And just to make things more difficult i need the range E12:O12 to step 2 as well until it gets to E208:O208 .Noting that row 11 never changes and will always have either an "S" Or an "F"

and also t = time()

**JBeaucaire** · 05-04-2009, 11:54 AM

Sounds like a PERFECT chance to upload a "before" and "after" workbook, easiest to see, right? Don't make the sample data TOO short, make sure it shows all the hurdles to overcome.

Click on GO ADVANCED and use the paperclip icon to attach a file.

**radar_jynx** · 05-04-2009, 06:30 PM

test document.xlsx

Here is an example file containing a long length of data however i cannot really provide a before and after, have a look and see what i mean.

Thanks Heaps

**JBeaucaire** · 05-04-2009, 07:06 PM

No? On Row 14, what is supposed to happen? P14 is the last value and P13 = "F", so...

Is the letter "t" supposed to go on P14? Q14? P15?

Then what about K24 with an "S" in K12?

**radar_jynx** · 05-05-2009, 04:19 AM

yes P14 is the last value and P13 = "F" so O15 becomes t
N16 is another last value and N13 also = "F" so M17 becomes t

so with the ones that row 13 = "S" not F
then eg.
K24 has K13 as "S" then K24 becomes t
I32 has I13 as "S" then I32 becomes t

and so on.

**JBeaucaire** · 05-05-2009, 04:32 AM

Try this macro:

Please Login or Register  to view this content.

**radar_jynx** · 05-05-2009, 04:46 AM

Thanks heaps that works exactly how i want it to, but can is there any way of making it so it doesn't automatically count the amount of rows eg. make it so it only goes from 14 to 208 not row.count

Thanks

**radar_jynx** · 05-05-2009, 04:52 AM

thanks heaps i figured it out

Cheers

Find Last Cell In range, and changing another Cell based on offset text

LinkBack

Thread Tools

Rate This Thread

Display

Find Last Cell In range, and changing another Cell based on offset text

Re: Find Last Cell In range, and changing another Cell based on offset text

Re: Find Last Cell In range, and changing another Cell based on offset text

Re: Find Last Cell In range, and changing another Cell based on offset text

Re: Find Last Cell In range, and changing another Cell based on offset text

Re: Find Last Cell In range, and changing another Cell based on offset text

Re: Find Last Cell In range, and changing another Cell based on offset text

Re: Find Last Cell In range, and changing another Cell based on offset text

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions