Is there some sort of rigorous criteria you can set to define the peaks?Like min-max difference something, deviation of max/min from median as a% of median, a high VAR for the whole row, quartiles massively different?Then you could always make a 'helper column' where you tested if this criteria was met for the row or not (TRUE/FALSE), then just sort your data according to the helper column, and copy all of your FALSE data (that isn't outliers) to a new table (or deleting the TRUE values). Recent ClippyPoint Milestones!Congratulations and thank you to these contributors DateUserCP1010050A community since MaDownload the official to convert Excel cells into a table on reddit using. PROVIDE YOUR DATA!Include a or use the website to generate the reddit table markup from your spreadsheet. TO APPLY CODE FORMATTING Use 4 spaces to start each lineYou can select code in your VBA window, press Tab, then copy and paste into your thread or comment. PLEASE FULLY READ THE SIDE-BAR BEFORE SUBMITTING A POST! SUBMISSION GUIDELINESFAQPROBLEM SOLVED?OPs can reply to any solutions with:This will award the user a and change the flair to SOLVED.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |