Join us now. It is free, and it takes less than 1 minute to register.
Register now
Subscribe to our daily newsletter. It is free, and it comes with many benefits.


+ Reply to Thread
Page 4 of 4 FirstFirst 1234
Results 46 to 56 of 56

Thread: Excel help

  1. #46
    Super Grandmaster KT-B's Avatar
    Join Date
    Feb 2014
    Location
    Pretoria
    Posts
    8,952
    Mentioned
    41 Post(s)
    Tagged
    0 Thread(s)

    Default

    You could just filter for the "N"s and then use the Delete button and Delete Rows.
    You may want to use the Find and Select - Visible only depending on how your machine selects the rows. Then Delete Rows.
    Last edited by KT-B; 03-08-2018 at 10:23 AM.
    And crawling on the planet's face
    Some insects called the human race
    Lost in time, and lost in space
    And meaning

  2. #47
    Senior Member
    Join Date
    May 2008
    Posts
    163
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Quote Originally Posted by I.am.Sam View Post
    yeah so some team managers need to do evaluations and some capture more than 5 evaluations per person . So the pivot will show how many evaluations were captured by the TM in total

    but only taking the ones where the person evaluated was 5 times or less
    cool you can do it with a countifs as well

  3. #48
    Grandmaster Xino_sam's Avatar
    Join Date
    Aug 2012
    Location
    Wild West
    Posts
    1,507
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Quote Originally Posted by KT-B View Post
    lol. Actually it is a little more complex than I thought.

    I am actually using the CountIF function to get the no of rows if it is repeated.
    =COUNTIF($A$2:$A$13,A2)
    But now my brain has slowed down a bit. I think I am doing this the complicated way. I am sure there is an easier way.



    I am really hoping we can just ignore all those with more than 5, and not include 5 of the rows
    Try changing =COUNTIF($A$2:$A$13,A2) to =COUNTIF($A$2:A2,A2), this will give unique numbers to each row, then compile pivot with count rows in the filter and select only unique number 5 and less. Hope this help. After this you can double click on the total, right bottom of your pivot to extract the unique data to a new worksheet

  4. #49
    rehabilitated troller I.am.Sam's Avatar
    Join Date
    Jun 2011
    Location
    In my own mind....
    Posts
    76,881
    Mentioned
    13 Post(s)
    Tagged
    0 Thread(s)

    Default

    Quote Originally Posted by Xino_sam View Post
    Try changing =COUNTIF($A$2:$A$13,A2) to =COUNTIF($A$2:A2,A2), this will give unique numbers to each row, then compile pivot with count rows in the filter and select only unique number 5 and less. Hope this help. After this you can double click on the total, right bottom of your pivot to extract the unique data to a new worksheet
    nice easy way to do it ...and then yeah just filter on 1-5s

    perfect
    Quote Originally Posted by Mike Lowrey
    We're on the internet to troll not to make bonds.

  5. #50
    Super Grandmaster KT-B's Avatar
    Join Date
    Feb 2014
    Location
    Pretoria
    Posts
    8,952
    Mentioned
    41 Post(s)
    Tagged
    0 Thread(s)

    Default

    Quote Originally Posted by Xino_sam View Post
    Try changing =COUNTIF($A$2:$A$13,A2) to =COUNTIF($A$2:A2,A2), this will give unique numbers to each row, then compile pivot with count rows in the filter and select only unique number 5 and less. Hope this help. After this you can double click on the total, right bottom of your pivot to extract the unique data to a new worksheet
    Yes that only came to me this morning Sometimes my brain takes a while to get where it is going.
    And crawling on the planet's face
    Some insects called the human race
    Lost in time, and lost in space
    And meaning

  6. #51
    rehabilitated troller I.am.Sam's Avatar
    Join Date
    Jun 2011
    Location
    In my own mind....
    Posts
    76,881
    Mentioned
    13 Post(s)
    Tagged
    0 Thread(s)

    Default

    i wanted exactly that ...but my brain didnt even go into 1st gear

    thanks all
    Quote Originally Posted by Mike Lowrey
    We're on the internet to troll not to make bonds.

  7. #52
    Super Grandmaster KT-B's Avatar
    Join Date
    Feb 2014
    Location
    Pretoria
    Posts
    8,952
    Mentioned
    41 Post(s)
    Tagged
    0 Thread(s)

    Default

    Quote Originally Posted by I.am.Sam View Post
    i wanted exactly that ...but my brain didnt even go into 1st gear

    thanks all
    Glad you are sorted - I shall put the spreadsheet away now.
    And crawling on the planet's face
    Some insects called the human race
    Lost in time, and lost in space
    And meaning

  8. #53
    rehabilitated troller I.am.Sam's Avatar
    Join Date
    Jun 2011
    Location
    In my own mind....
    Posts
    76,881
    Mentioned
    13 Post(s)
    Tagged
    0 Thread(s)

    Default

    Quote Originally Posted by KT-B View Post
    Glad you are sorted - I shall put the spreadsheet away now.
    sometimes a little few minds gets it done quicker and easier and simpler

    excel is a very good tool ..jsut need to know what to google or ask
    Quote Originally Posted by Mike Lowrey
    We're on the internet to troll not to make bonds.

  9. #54
    Super Grandmaster KT-B's Avatar
    Join Date
    Feb 2014
    Location
    Pretoria
    Posts
    8,952
    Mentioned
    41 Post(s)
    Tagged
    0 Thread(s)

    Default

    Quote Originally Posted by I.am.Sam View Post
    sometimes a little few minds gets it done quicker and easier and simpler

    excel is a very good tool ..jsut need to know what to google or ask
    I have an advantage - I train it.
    And crawling on the planet's face
    Some insects called the human race
    Lost in time, and lost in space
    And meaning

  10. #55
    rehabilitated troller I.am.Sam's Avatar
    Join Date
    Jun 2011
    Location
    In my own mind....
    Posts
    76,881
    Mentioned
    13 Post(s)
    Tagged
    0 Thread(s)

    Default

    Quote Originally Posted by KT-B View Post
    I have an advantage - I train it.
    guess who will be PMing you more often
    Quote Originally Posted by Mike Lowrey
    We're on the internet to troll not to make bonds.

  11. #56
    Super Grandmaster KT-B's Avatar
    Join Date
    Feb 2014
    Location
    Pretoria
    Posts
    8,952
    Mentioned
    41 Post(s)
    Tagged
    0 Thread(s)

    Default

    Quote Originally Posted by I.am.Sam View Post
    guess who will be PMing you more often
    You are welcome to. I love problems and challenges - as long as they are software related.
    And crawling on the planet's face
    Some insects called the human race
    Lost in time, and lost in space
    And meaning

+ Reply to Thread
Page 4 of 4 FirstFirst 1234

Similar Threads

  1. Replies: 19
    Last Post: 01-02-2014, 10:46 AM
  2. Excel
    By DDV TECH in forum Software and Web Development
    Replies: 6
    Last Post: 11-10-2008, 12:03 PM
  3. Excel help
    By Beginner in forum Forum suggestions
    Replies: 10
    Last Post: 10-10-2008, 12:59 PM
  4. Excel Help
    By renvilo in forum PC Hardware and Gadgets
    Replies: 5
    Last Post: 09-09-2008, 01:23 PM
  5. PHP and M$ Excel
    By Lord-Nikon in forum Software and Web Development
    Replies: 5
    Last Post: 28-08-2008, 08:31 AM

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •