Skip to main content
L
lvl10720-Turquoise
20-Turquoise
August 31, 2022
Solved

Clean (and UnClean) ScatterPlot Points ?

  • August 31, 2022
  • 1 reply
  • 877 views

Hi Everyone.
From the following :

Clean_UnClean.PNG

How to Clean (and UnClean) ScatterPlot Points ?
Thanks in advance for your time and help.
Best Regards.
Loi.

 

Best answer by Werner_E

Here you are!

Hoping not to be followed by "related ..." 😉

 

EDIT: Replaced worksheet by a version with correct "Clean" function

EDIT 2: Added an alternate version for each of the two functions

 

You may even have it cleaner than clean 🙂

Werner_E_0-1661966950381.png

 

 

1 reply

W
Werner_E25-Diamond IAnswer
25-Diamond I
August 31, 2022

Here you are!

Hoping not to be followed by "related ..." 😉

 

EDIT: Replaced worksheet by a version with correct "Clean" function

EDIT 2: Added an alternate version for each of the two functions

 

You may even have it cleaner than clean 🙂

Werner_E_0-1661966950381.png

 

 

    L
    lvl10720-TurquoiseAuthor
    20-Turquoise
    August 31, 2022
    @Werner_E wrote:

    Here you are!

    Hoping not to be followed by "related ..." 😉

     

    EDIT: Replaced worksheet by a version with correct "Clean" function

    EDIT 2: Added an alternate version for each of the two functions

     

    You may even have it cleaner than clean 🙂

    Werner_E_0-1661966950381.png

     

     

    Hoping not to be followed by "related ..." 

    lvl107_0-1661967789940.png

    Y..ea...h, with this one, will not be having "related" query, because your answer is very clear, neat and complete to my question.😉😉. Now, I have say: "Thanks, Thanks and Thanks"

    Best, Best Regards.

    Loi.

     

    Terms & ConditionsAccessibility statement