Sort and return unique single digit numbers


 

5 Responses to “Sort and return unique single digit numbers”

  1. You could always use the brute force method (which eliminates the need for any helper cells)...

    =IF(COUNTIF(A1:A4,"*0*"), 0, "")&IF(COUNTIF(A1:A4, "*1*"), 1, "")&IF(COUNTIF(A1:A4, "*2*"), 2, "")&IF(COUNTIF(A1:A4, "*3*"), 3, "")&IF(COUNTIF(A1:A4, "*4*"), 4, "")&IF(COUNTIF(A1:A4, "*5*"), 5, "")&IF(COUNTIF(A1:A4,"*6*"), 6, "")&IF(COUNTIF(A1:A4, "*7*"), 7, "")&IF(COUNTIF(A1:A4, "*8*"), 8, "")&IF(COUNTIF(A1:A4, "*9*"), 9, "")

    And for the VBA code fans out there, one could use this UDF (user defined function)...

    Function UniqueDigits(Rng As Range) As String
      Dim X As Long, Digits As String
      Digits = "0123456789"
    For X = 0 To 9
        If Application.CountIf(Rng, "*" & X & "*") = 0 Then Mid(Digits, X + 1) = " "
      Next
      UniqueDigits = Replace(Digits, " ", "")
    End Function
    
  2. mahmoud-lee says:

    Can you bring unique within a single cell

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file

Print screen the entire worksheet


 

One Response to “Print screen the entire worksheet”

  1. pmsocho says:

    Great tip!
    Thanks for sharing!

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file

Highlight unique values in a filtered excel table


 

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file

Customize excel maze


 

One Response to “Customize excel maze”

  1. Terry says:

    Great work!!
    Thank you.

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file

Solve a maze


 

2 Responses to “Solve a maze”

  1. Wassim says:

    Hi, This is very cool, but I wonder what controls the thickness of the maze. In other words how can I make the maze a bit wider so my elderly mother can trace it with her aging eyes.

    Thanks and a very neat project.

    Wassim

    • Oscar says:

      Wassim,

      1. Go to "View" on the ribbon
      2. Enable "Headings"
      3. Select column B:DG on the sheet
      4. Change the column width

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file