Support Board
Date/Time: Sat, 23 Nov 2024 09:07:03 +0000
Post From: Challenging Spreadsheet operation
| [2024-09-07 00:15:27] |
| ondafringe - Posts: 283 |
|
That's an interesting problem. So you have a bunch of numbers strung horizontally along the same row, from K3 to AU3. The first two requirements seem pretty straight forward and can be solved with one formula copied to multiple cells, but how do you determine which numbers to include in a subset (I can't interpret python)? And you indicated you want to remove all numbers less than 15,000, but your example used 10,000. Was that a mistake, or does that number need to be thought of as a variable, instead of a constant? Date Time Of Last Edit: 2024-09-12 15:49:56
|