Challenge #432: Sequential Logic
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
11 - Bolide
07-09-2024
06:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
c432
Spoiler
Did an iterative macro, no multi-row

Tofel
9 - Comet
07-09-2024
07:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
sfarnham1
7 - Meteor
07-09-2024
09:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
HardikJani
8 - Asteroid
07-09-2024
09:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, thanks for a good challenge. I first created three dummy columns as per the rules then I created a macro to fill the rows using three multi row tools and then recreated the dummies. Looped this for 22 times to get the data and filtered the unwanted rows and columns
JAKupchik
7 - Meteor
07-09-2024
01:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
tammybrown_tds
9 - Comet
07-09-2024
03:27 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Powerhouse_21
10 - Fireball
07-09-2024
03:53 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
21 - Polaris
07-09-2024
04:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@AkimasaKajitani
Nice way of thinking. 😁
10 - Fireball
07-09-2024
04:53 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My solution!
Smatthias
7 - Meteor
07-09-2024
11:50 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Spoiler
Spoiler
Somebody know how to use just one multi line expression rather than 4, like calc all columns in one? Anyway, solution is simple, take the last row, which is the only relevant row, A is the sum of all, hence for further calc you just calc [row-1:A]*2. Then you calc the rest based on the last relevant row. Reattach the solution with the previous rows and voila, solution. I used an excel to read in the data.My Solution: