+ Reply to Thread
Results 1 to 6 of 6

selecting the rows that have all the rows with negative cells

  1. #1
    Registered User
    Join Date
    07-08-2015
    Location
    Madrid
    MS-Off Ver
    MS Office Professional Plus 2016
    Posts
    14

    selecting the rows that have all the rows with negative cells

    Hi there
    I am using the MS O 2013.
    The table that I have has 487592 rows. I have 49 rows that represent different dates. On each date was collected a value that can be positive or negative.
    The final goal is to identify major trends isolate in a different table and connect afterwards this table to GIS software and check its representation in the terrain.
    I use the sparkline to create a graphic for each row and show the trend of that line. The problem is the amount of rows that I would need to check manually...
    Therefore I was thinking that I could select the rows that show only negative rows. Is there any formula or conditional formatting for selection or any other way for doing this??
    or maybe something that selects similar rows or sparklines?

    cheers,
    pmss

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,671

    Re: selecting the rows that have all the rows with negative cells

    Do you mean all data in the row is negative?

  3. #3
    Registered User
    Join Date
    07-08-2015
    Location
    Madrid
    MS-Off Ver
    MS Office Professional Plus 2016
    Posts
    14

    Re: selecting the rows that have all the rows with negative cells

    Yes exactly that. All the values in the row must be negative.

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,671

    Re: selecting the rows that have all the rows with negative cells

    Filter on first column of data for data < 0 and copy/paste ?

  5. #5
    Registered User
    Join Date
    07-08-2015
    Location
    Madrid
    MS-Off Ver
    MS Office Professional Plus 2016
    Posts
    14

    Re: selecting the rows that have all the rows with negative cells

    yup that will work. for the selection of the rows! thanks!
    any suggestion about automatic identification of the trends on sparklines ?

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,671

    Re: selecting the rows that have all the rows with negative cells

    No ... just discovered what "sparklines" are!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Selecting rows with highlighted cells
    By jsuma in forum Excel General
    Replies: 3
    Last Post: 10-06-2014, 02:34 PM
  2. Selecting rows of selected cells
    By jdskin2 in forum Excel General
    Replies: 2
    Last Post: 02-09-2012, 04:34 PM
  3. Selecting cells/rows
    By dororke in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-31-2006, 09:57 PM
  4. [SOLVED] after selecting 50 rows of a column i can't reference the cells in the rows
    By Bob Salzer in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-21-2006, 05:35 PM
  5. Selecting rows from cells
    By sakk555 in forum Excel General
    Replies: 4
    Last Post: 06-04-2005, 07:21 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1