Skip to main content
lvl10720-Turquoise
20-Turquoise
Aug 31, 2022 5:03 PM UTC
Solved

Clean (and UnClean) ScatterPlot Points ?

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.

 

Werner_E
Werner_EAnswer
25-Diamond I
Aug 31, 2022 5:13 PM UTC

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

 

 

View in thread

2 replies

Werner_E
Werner_E25-Diamond IAnswer
25-Diamond I
Aug 31, 2022 5:13 PM UTC

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

 

 

Translate
    lvl10720-TurquoiseAuthor
    20-Turquoise
    Aug 31, 2022 5:53 PM UTC
    @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.

     

    Translate
    Terms & ConditionsAccessibility statement