Menu

Finding the last one

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.programming

Boris[_2_] Boris[_2_] is offline

Boris[_2_] is offline

external usenet poster

Posts: 11

Default

Finding the last one

On Thu, 20 Sep 2007 10:53:53 -0700, wrote:

How would I do it for the case that I have to look at every 4th row,
not every row.

Like Joel already said, you have to move by 4, not 1:
ie.
For i = n - 1 To 2 Step -1
should be
For i = n - 1 To 2 Step -4

Regards,

B.

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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
Finding the first value that is less than zero	russhess8	Excel Worksheet Functions	4	June 25th 09 03:19 AM
Finding a Value	SueK	Excel Discussion (Misc queries)	3	September 21st 08 07:27 PM
Finding second value?	bgkgmg	Excel Worksheet Functions	6	August 24th 08 05:22 PM
Finding the top 10	Bertha needs help[_2_]	Excel Discussion (Misc queries)	13	August 5th 08 04:41 PM
finding value	ceemo	Excel Discussion (Misc queries)	4	April 20th 06 02:16 PM

All times are GMT +1. The time now is 08:59 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement