The most pointless combination of functions

[arkusM]

maybe "pointless" is simply a level of "having a point" that we do not yet understand

 

[Oorang]

Might be more fun to do the seemingly pointless functions. Like did you know:

Range("A1").Value = Range("A1").Value

actually does something? (Free cookie to the first person who knows the value of it )

 

[MrKowz]

Might be more fun to do the seemingly pointless functions. Like did you know:

Range("A1").Value = Range("A1").Value

actually does something? (Free cookie to the first person who knows the value of it )

=A1?

(circular reference mind boggling!)

Sub Pointless()
    Dim i as integer
    Dim LR as integer: LR = Range("A" & rows.count).End(xlUp).Row
    For i = 1 to LR
        If Cells(i + LR,"A") = Cells(LR + 1,"A") Then
        Msgbox "Press OK to Continue"
    Next i
End Sub

 

[Cindy Ellis]

Might be more fun to do the seemingly pointless functions. Like did you know:

Range("A1").Value = Range("A1").Value

actually does something? (Free cookie to the first person who knows the value of it )

Assuming A1 had a formula in it, wouldn't this replace the formula with the value of the function at that moment?
--Cindy

 

[Lewiy]

It performs the act of PasteValues

 

[Lewiy]

Perhaps a challenge to find the most interesting results of a function or formula, where ALL of the arguments are “A1”. To kick things off, can anyone tell me which of the following is the odd one out:
=REPLACE(A1,A1,A1,A1)
=SUBSTITUTE(A1,A1,A1,A1)
=LEFT(A1,A1)
=TEXT(A1,A1)

 

[kgkev]

I've always like multile random numbers in function

=IF(RANDBETWEEN(1,3)=1,1,IF(RANDBETWEEN(1,3)=2,2,IF(RANDBETWEEN(1,3)=3,3,0)))

Maybe more pointless would be

=IF(RANDBETWEEN(1,3)=1,1,IF(RANDBETWEEN(1,3)=2,2,IF(RANDBETWEEN(1,3)=3,3,randbetween(1,3))))

 

[kgkev]

got another one

=left(a1,len(a1))

 

[Gerald Higgins]

On the random theme

=if(rand()=rand(),rand(),rand())

Strictly speaking, you could argue this does actually does SOMETHING, but nothing very useful.

Lewiy - post #36
I tested these - as far as I can tell there are several odd ones out.
The TEXT formula is the only one that doesn't return an error if A1 contains text.

If A1 contains 0, TEXT returns 0 and LEFT returns blank, the others return errors.
If A1 contains a 2 digit number, or a decimal such as 1.1, thing start to get interesting. Also the results for A1=10 are different from A1=11.

 

[barry houdini]

Maybe more pointless would be

=IF(RANDBETWEEN(1,3)=1,1,IF(RANDBETWEEN(1,3)=2,2,IF(RANDBETWEEN(1,3)=3,3,randbetween(1,3))))

I don't think this qualifies as pointless. It produces a specific distribution, i.e. more 1s than 2s and more 2s than 3s [in fact, if you have that formula in 81 cells then, on average, you'll get 35 1s, 26 2s and 20 3s] so if you require that distribution the point of the formula would be to produce it!

Time for my tablet, I think.................