LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default Loopy question

Have a spreadsheet sent to me
about 250 lines, 12 columns.

There are 60 lines of data, two blank rows
'nother 60 lines, two blank rows, etc.

After my numbers did not foot to the
published totals, discovered that the
person supplying the spreadsheet had
duplicated the same number
in the spreadsheet. (The odds of
having duplicate values in the same column
are extremely slight).

I want to loop through each cell, by column,
starting at cell D2 (data runs from D2 - O2)
store the value in cell D2 as a temporary variable,
compare the tmp variable to each cell in
the same column (going down).
If a match is found, msgbox
should say "OOPS!" (or something like that).
After cycling through all 60 lines (blank rows
separate the each set of 60 lines, so the cursor
will know when to terminate), the cursor
moves back to the top of the same column,
starts at D3, stores that
value, and compares the value in D3 to all cells
in the column directly below it, until a
blank row is found. By the time the cursor
starts comparing the last values in the columns
(such as cell D55/D56, etc.)
there would be only four values to compare with the
three cells below, then three, then two,
and finally the cursor will be comparing
the last value in the column only to itself.
( I suppose the process could terminate before
the last cell is reached).

Upon completing the column, the cursor moves
back to the top of the column, moves Right1,
and starts in column E with cell E2,
until all twelve columns have been audited.
Don't want to compare values between columns
(i.e. cell E55 with cell F55), just the cells in
column E with all the other cells below it in column E.
There are only 250 rows of data, so the whole
process should only take a few minutes.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Loopy? AnthonyG Excel Worksheet Functions 2 January 16th 06 01:54 PM
Going loopy on a loop John in Surrey Excel Programming 4 December 20th 05 04:58 PM
Loopy Code Cody Excel Programming 4 July 29th 05 05:17 PM
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you [email protected] Excel Programming 0 April 27th 05 07:46 PM
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you [email protected] Excel Programming 23 April 23rd 05 09:26 PM


All times are GMT +1. The time now is 03:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"