Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming all is required, the following 342 results were found.

  1. Select unique values in Microsoft Excel columnhttps://joellipman.com/component/content/article/select-distinct-values-in-microsoft-excel-column.html?catid=110&Itemid=165

    Thought I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum: Quick Count =INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&""))) This returns the number of unique values in the range...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  2. Can't play music after Firmware Update Version 3.0https://joellipman.com/component/content/article/cant-play-music-after-firmware-update-version-30.html?catid=116&Itemid=165

    Well we're all happy that the iPlayer from the BBC has come to PS3 in Europe but I'm less impressed about the multi-audio output. My setup is that the sound goes from the Playstation to the Sound System via Optical Out. I found that if you do enable...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
Results 341 - 342 of 342