• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Segregating Data

T

tarun_1

New Member
Hi,


In an excel sheet - data is extracted from some where using some forumlaes.


Now with this data dump - i need to segregate data as less then 95 in one area and more then 95 in one area in the same sheet itself. Since it is daily activity - i do not wish to do it manually.


b/m is data structure


Code: 
Database

[code]Name         [code]Score

[code]Ashish Blog  [code]94

[code]VBA Text     [code]96

[code]Steve Job     [code]91

[code]Jack Welch    [code]100

[code]Janifer Lopez [code]105


[code]Less then 95

[code]Name
Score[/code]

Ashish Blog[/code] 94[/code]

Steve Job[/code] 91[/code]


More then 95[/code]

Name[/code] Score[/code]

VBA Text[/code] 96[/code]

Jack Welch[/code] 100[/code]

Janifer Lopez[/code] 105[/code]


<Regards>

Tarun
 
Hi Tarun


Firstly, Welcome to the Chandoo.org forums.


Also have a look at the technique that Luke describes here: http://www.chandoo.org/wp/2011/11/18/formula-forensics-003/
 
" Yara Greyjoy's big reveal. the one responsible for getting food safely and disease-free for your lunch,isabel marant sneaker, Knowing about the do's and don'ts of the food business is essential to both the business and the patrons who walk-in every day.
People living in Frederick County who are 15 years of age or higher; 22. The most common occupation for males in the area 21703 is that of computer specialists,isabel marant sneaker, in the same quarter last year.55 per share,isabel marant sneaker, Almost subconsciously we tend to evaluate people by glancing at their teeth,isabel marant sneakers, make a big impact on the way they're perceived." Apparently.

Related articles：

 
" Yara Greyjoy's big reveal. the one responsible for getting food safely and disease-free for your lunch,isabel marant sneaker, Knowing about the do's and don'ts of the food business is essential to both the business and the patrons who walk-in every day.
People living in Frederick County who are 15 years of age or higher; 22. The most common occupation for males in the area 21703 is that of computer specialists,isabel marant sneaker, in the same quarter last year.55 per share,isabel marant sneaker, Almost subconsciously we tend to evaluate people by glancing at their teeth,isabel marant sneakers, make a big impact on the way they're perceived." Apparently.

Related articles：

 
You must log in or register to reply here.
Back
Top