Hi all, thanks in advance for looking at my issue.
I have a graph made out of a list of 10,000 data points, and I want to remove 99% of the data and end up with about 100 data points. Is it possible to take down data like this?
Last edited by joeblog60; 11-30-2011 at 12:12 PM.
you would make a data dump from your list of 10,000 and the data dump would consist of a criteria for whittling away and leaving just the 100 and use the data dump as your chart data. An sample would help, as would the criteria for creating the smaler list
Windows 7 using Office 2007 & 2010
Remember your [ code ] [ /code ] tags, makes reading soooo much easier
Basically I want to keep every 100th value. So I want a new list for which the first 3 entries would be:
Old value 1
Old value 101
Old value 201
etc. I don't want to parse it to get the data with certain values, I just want to take 99 or every 100 cells out.
Also, thanks for the reply!
In an adjacent column
=MOD(ROW(), 100)
Autofilter on that column and select one value.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
You're amazing, thank you.
A different approach
With data in A2:A10,000 this will get you every 99th row of data. Formula in B2 and drag down
=OFFSET($A$2,99*ROWS(B$2:B2)-1,0,1)
Windows 7 using Office 2007 & 2010
Remember your [ code ] [ /code ] tags, makes reading soooo much easier
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks