Tuesday, 29 April 2014

Oscar Wilde

Oscar Fingal O'Flahertie Wills Wilde was born in Dublin, Ireland in 16 October 1854, he became most popular playwrights in London early 1890s.

He regularly written fairy stories for magazines he published The Happy Price and Other Tales in 1888. Then he starts longer prose which were published in major literary-intellectual journals

Wilde died on 30 Nov, 1900, initially burried Cimetiere de Bagneus outside Paris; in 1909 transferred to Pere Lachaise Cemetery inside city.

He is well known for his Poems, fairy stories,essays and dialogues, plays also he wrote a novel. some from his work is.

The Happy Prince and Other Stories

Lord Arthur Savile's Crime and Other Stories

House of Pomegranates

The Picture of Dorian Gray

The Soul of Man under Socialism

The Duchess of Padua

Monday, 14 April 2014

Reset PhotoShop to its Default settings.

Sometimes during working we always customizing our work area in Adobe PhotoShop, as we customize most of things, or there are certain settings we changed.
If you want to go back to its standard settings.

Follow bellow simple procedure according to your OS.

For Windows
Before opening Photoshop
Press and hold Left (Ctrl+Alt+Shift)
then open Photoshop.

For Mac
Before opening Photoshop
Press and hold Left (command+Option+shift)

then open Photoshop.

it will prompt to delete Photoshop settings file.

Press "Yes" to proceed or "No" to stay on current settings.

Snapshot Reset PhotoShop

Tuesday, 8 April 2014

Find duplicate value in excel through Countif

Find duplicate value in excel through Countif

In latest versions of MS Excel finding duplicate values is very easy by selecting desire column/ range and go to conditional formatting and select duplicate values.

But today I am going to tell you other way to find duplicate values, also it will tell you number of repetition of a value.
If value is single it will display “1” if value is repeat two times it show “2” and number will increased as repetition increased.
It performed with a very simple formula, lets demonstrate it.

Syntax of “countif” formula is

Countif(range, criteria)

Range:            range is a specific row or column/columns, which need to be check for count
Criteria:            Criteria is what to be count.

Now I am going to use same formula to find all duplicate values.

Here I have a sheet with numbers which have multiple values.

In “A2” write formula

“b2:b2” as range and make first value absolute by adding “$” like “$b$2”.
second will not as absolute in range.
Criteria is also “b2”
By doing this it will search in range b2 to b2 and count b2 it will give one.
By copying formula in entire column it will change as
=countif($B$2:B3,B3) and so on.
It means it will search range b2 to b3 and count b3 value in range.

you can also add a simple conditional formatting for values more than one “1” will highlighted and it will ease to find duplicates.
and values greater than 1 will be highlighted red, which means value repeat in 2, 3,4 etc. times.