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

Thread starter wxrocks
Start date Nov 1, 2006
Tags

Computer Delete Value

AI Thread 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.

Nov 1, 2006

wxrocks

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

Nov 1, 2006

NoTime

Science Advisor

Homework Helper

You can use the VB script language built into excel.

Thread 'AI Marketed To Students: "Hello easy A's!"'

Seen on Facebook. An ad for AI. "hello easy A's!"

View full post »

Thread 'Is AI hype?'

In my discussions elsewhere, I've noticed a lot of disagreement regarding AI. A question that comes up is, "Is AI hype?" Unfortunately, when this question is asked, the one asking, as far as I can tell, may mean one of three things which can lead to lots of confusion. I'll list them out now for clarity. 1. Can AI do everything a human can do and how close are we to that? 2. Are corporations and governments using the promise of AI to gain more power for themselves? 3. Are AI and transhumans...

View full post »

Thread 'MS 365 Profile Badge colour'

Sorry if 'Profile Badge' is not the correct term. I have an MS 365 subscription and I've noticed on my Word documents the small circle with my initials in it is sometimes different in colour document to document (it's the circle at the top right of the doc, that, when you hover over it it tells you you're signed in; if you click on it you get a bit more info). Last night I had four docs with a red circle, one with blue. When I closed the blue and opened it again it was red. Today I have 3...

View full post »