You beauty handsome boy great god predecessors:

Here I have a question want to ask you, can you give me some ideas or solutions to

Is a problem about Excel vba programming, first meet this problem, feel more difficult, also nothing important ideas
Specific question is like this, need such a batch of data, data about vehicles, each column data is such as model name, engine type, brand, model, cars, cars and other car relevant properties parameters,

To A group of data models, about 8 k, A column of data in the data for the model: such as A column: audi Q3 2015 35 TFSI quattro million mark comfortable enjoy type of data are separated with A comma,

C: engine type D: drive E: body structure goal as K column: price

Hereby request: through A column of data: audi Q3 2015 35 TFSI C + D + E data together only determine A models,
Then through in the same model data according to A list of some of the data (models) : quattro million mark comfortable enjoy type here may be empty, to deal with price list, the highest price is set to 1, prices, minimum is set to 0;

Can excuse me this use vba programming, thinking how?

My train of thought is implemented by Excel function distribution, by using the finite-step iteration of A column data first part of the string, and then was conducted in the C D E column data after joining together into the new M column,

But M column for grouping the whole data arrangement, but how to implement, after arrangement on how to deal with prices listed cannot solve?

Everyone a great god, can you take time to help me analysis analysis, best can give yo code
I in this very grateful! O ~ O (studying studying)

CodePudding user response:

Start recording macros in Excel 2003, manual, complete the required function end record macros, press Alt + F11 key, check just record macro corresponding VBA code,

CodePudding user response:

Hello, see your reply is not very clear
That under specific manual operation is how to operate it, I now need to group according to a certain field, the combination of the field for multiple column data and then for each set of data in a column for example: prices for processing:

Increases the processing logic for a line of a price level, the price of the highest data set 1 lowest price is set to 0, do excuse me such manual operation can achieve a

Now I added a column of auxiliary columns: grouping variable column, fill of assembled field by Excel function well,

CodePudding user response:

The building Lord description of "problem", good "hazy feeling"...

CodePudding user response:

I only know that car is good

CodePudding user response:

Similar to retrieve luo
The audi Q3 2015 35 TFSI
Split (" audi Q3 2015 paragraph 35 TFSI ", "") j remove the keywords into an array
Then, line by line keyword matching
Such as read instr determine whether "the audi Q3" in A column in this business, if you have, then look at "2015" is also in the column A...
To determine if all have, then hit a line, continue to the next line, such as traverse all rows, bring all hit the price order

CodePudding user response:

Data structure design has a problem, the need to separate the data used, all alone takes up a column, then consider screening questions,

CodePudding user response:

Who put me on the 6th floor reply deleted???????
What is the reason for delete??? Which violated, you'd say!!!!!!


I remember last year, "report" once someone swearing reply, no "administrator" how to deal with!!!!!!
(once it is in CSDN "only" one time I report)