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
Bookmarks