Computer Questions: Find Highest/Lowest Value & Delete Other Rows

Click For Summary
The discussion centers on a request for a code solution to efficiently process data in Excel by selecting groups of rows, identifying the highest or lowest value in a specific column, and deleting the other rows within each group. The suggested approach involves utilizing Visual Basic (VB) scripting, which is integrated into Excel, to automate this task and save time in data management. The focus is on creating a streamlined method for data analysis and manipulation.
wxrocks
Messages
130
Reaction score
0
Yikes -- 2 computer questions in the same day??!??!?

Does anyone have code for selecting a group of rows, checking one column for the highest/lowest value of the group, deleting the other rows -- then moving to the next group?

Just trying to save some time. Thanks!
 
Computer science news on Phys.org
You can use the VB script language built into excel.
 

Thread 'How far will we let AI control us?'

I’ve spent nearly my entire life online, and witnessed AI become integrated into our lives. It’s clear that AI is apart of us now whether we like it or not, unless your a anti tech cabin lover. AI has some form of control over your life. But what I’ve seen very recently is that people are loosing their ingenuity and deciding to use AI. I feel as if it’ll bleed into STEM which is kinda has already and, every idea or thought could become fully reliant on AI. Yeah AI makes life easier but at a...
View full post »

Similar threads

Should Excel macros self-adjust when you delete lines above the affected cells?
  • · Replies 27 ·
Replies
27
Views
4K
Python Partial pivoting in getting the reduced row echelon form of a matrix
  • · Replies 2 ·
Replies
2
Views
2K
Understanding DRAM Refresh Operations
  • · Replies 14 ·
Replies
14
Views
5K
Question on Android phone system: Moving files & the Gallery
  • · Replies 16 ·
Replies
16
Views
4K
My Website For Creating Interactive Visuals Linked To Equations
  • · Replies 4 ·
Replies
4
Views
3K
Python Radiobutton choices auto-filled before selection
  • · Replies 3 ·
Replies
3
Views
1K
Computer languages tend to be transient
  • · Replies 44 ·
2
Replies
44
Views
5K
How Can We Efficiently Parallelize the N-Queens Problem?
  • · Replies 11 ·
Replies
11
Views
4K
MySQL: Best way to warehouse older data
  • · Replies 9 ·
Replies
9
Views
2K
How to delete one's own question? Mentors?
  • · Replies 10 ·
Replies
10
Views
3K