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

Click For Summary
SUMMARY

This discussion addresses the need for a method to select groups of rows in Excel, identify the highest or lowest value in a specified column, and delete the other rows within that group. The suggested solution involves using Visual Basic for Applications (VBA) scripting to automate this process. Participants emphasize the efficiency gained by utilizing VBA to handle repetitive tasks in Excel, particularly for data analysis and management.

PREREQUISITES
  • Familiarity with Excel and its interface
  • Basic understanding of Visual Basic for Applications (VBA)
  • Knowledge of data grouping and sorting techniques
  • Experience with Excel functions and formulas
NEXT STEPS
  • Learn how to write and execute VBA scripts in Excel
  • Explore Excel's data manipulation functions, such as SORT and FILTER
  • Research advanced VBA techniques for automating data analysis tasks
  • Investigate best practices for managing large datasets in Excel
USEFUL FOR

This discussion is beneficial for data analysts, Excel users, and anyone looking to streamline data processing tasks through automation in Excel using VBA.

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.
 

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
6K
Question on Android phone system: Moving files & the Gallery
  • · Replies 16 ·
Replies
16
Views
6K
MATLAB MATLAB GPU Cross-Correlation Code Fails with OOM on 8 GB Supercomputer
  • · Replies 4 ·
Replies
4
Views
8K
My Website For Creating Interactive Visuals Linked To Equations
  • · Replies 4 ·
Replies
4
Views
4K
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
6K
How Can We Efficiently Parallelize the N-Queens Problem?
  • · Replies 11 ·
Replies
11
Views
5K
MySQL: Best way to warehouse older data
  • · Replies 9 ·
Replies
9
Views
2K