Friday, September 2, 2016

Prevent Duplicate Entries in Excel

This example teaches you how to use data validation to prevent users from entering duplicate values.
1. Select the range A2:A20.
2. On the Data tab, click Data Validation.

3. In the Allow list, click Custom.
4. In the Formula box, enter the formula shown below and click OK.


Explanation: The COUNTIF function takes two arguments. =COUNTIF($A$2:$A$20,A2) counts the number of values in the range A2:A20 that are equal to the value in cell A2. This value may only occur once (=1) since we don't want duplicate entries. Because we selected the range A2:A20 before we clicked on Data Validation, Excel automatically copies the formula to the other cells. Notice how we created an absolute reference ($A$2:$A$20) to fix this reference.
5. To check this, select cell A3 and click Data Validation.



As you can see, this function counts the number of values in the range A2:A20 that are equal to the value in cell A3. Again, this value may only occur once (=1) since we don't want duplicate entries.
6. Enter a duplicate invoice number.
Result. Excel shows an error alert. You've already entered that invoice number.





Sunday, August 28, 2016

meaning zihaal-e-miskeen mukon ba-ranjish, bahaal-e-hijra bechara dil hai



First the meaning of the mukhda:

---------------------------------





zihaal-e-miskeen mukon ba-ranjish, bahaal-e-hijra bechara dil hai




zihaal = notice

miskeen = poor

mukon = do not

ba-ranjish = with ill will, with enimity

bahaal = fresh, recent

hijra = separation




Thus the meaning is: Notice the poor (heart), and do not look at it (heart)

with enimity. It (heart) is fresh with the wounds of separation.




Hindi mein (and more clearly): Ye dil judaai ke gamo se abhi bhi taaza hai.

Iski bechaargi ko ba-ranjish (without enimity) dekho.




Now the full song (it's really beautiful).

--------------------------------------...

(There is equally beautiful remark after the song)




zihaal-e-miskeen mukon ba-ranjish

bahaal-e-hijra bechara dil hai

sunaai deti hai jisaki dhaDakan

tumhaaraa dil ya hamaaraa dil hai




vo aake pahaloo meiN aise baiThe

ke shaam raNgeen ho gayi hai

zaraa zaraa si khili tabeeyat

zaraa si gamgeen ho gayi hai




kabhi kabhi shaam aise Dhalatee hai

jaise ghooNghaT utar rahaa hai

tumhaare seene se uThta dhuaaN

hamaare dil se guzar raha hai




ye sharm hai ya hayaa hai kya hai

najar uThaate hi jhuk gayi hai

tumhaari palakoN se girke shabanam

hamaari aaNkhoN meiN ruk gayi hai







Now a remark

--------------

Many words of this song are in Persian. The phrase "Zihaal-e-miskeen"

comes from a poem of Amir Khusrau. This original poem of Amir Khusrau

is a unique masterpiece. The beautiful thing about this poem is that

it it written in Persian and Brij bhasha simultaneously. The first

line is in Persian, second in Brij bhasha, third in persian, and so

on...!! What an unbelievable talent. And here are first four lines of

that poem.




zihaal-e-miskeen mukon taghaful (Persian)

doraaye nainaan banaye batyaan (Brij)




ke taab-e-hijraah nadarum-e-jaan (Persian)

na laihyo kaahe lagaye chatyaan (Brij)




This showcases Hazrat Amir Khusrau's mastery over the two languages and the

role played by him in the genesis of Urdu.




The complete poem taken from http://www.alif-india.com/ is




Ziehal-e miskeenn makun taghaful, duraye naina banaye batiyan;

ki taab-e hijran nadaram ay jaan, na leho kaahe lagaye chhatiyan.




Shaban-e hijran daraz chun zulf wa roz-e waslat cho umr kotah;

Sakhi piya ko jo main na dekhun to kaise kaatun andheri ratiyan.




Yakayak az dil do chashm-e jadoo basad farebam baburd taskin;

Kise pari hai jo jaa sunaave piyare pi ko hamaari batiyan.




Cho shama sozan cho zarra hairan hamesha giryan be ishq aan meh;

Na neend naina na ang chaina na aap aaven na bhejen patiyan.




Bahaqq-e roz-e wisal-e dilbar ki daad mara ghareeb Khusrau;

Sapet man ke waraaye raakhun jo jaaye paaon piya ke khatiyan.




And the English translation is:




Do not overlook my misery by blandishing your eyes,

and weaving tales; My patience has over-brimmed,

O sweetheart, why do you not take me to your bosom.

Long like curls in the night of separation,

short like life on the day of our union;

My dear, how will I pass the dark dungeon night

without your face before.

Suddenly, using a thousand tricks, the enchanting eyes robbed me

of my tranquil mind;

Who would care to go and report this matter to my darling?

Tossed and bewildered, like a flickering candle,

I roam about in the fire of love;

Sleepless eyes, restless body,

neither comes she, nor any message.

In honour of the day I meet my beloved

who has lured me so long, O Khusrau;

I shall keep my heart suppressed,

if ever I get a chance to get to her trick

Monday, May 23, 2016

How to fix Corel Draw save fix (C.A.R.M) ARM Recovery Fix


Corel Draw is one of the most expensive pieces of junk I ever saw. I take that back ðŸ™‚ Considering that still X3 was decent compared to 11 and 12 and also that X5 is pretty good considering Corel’s history and also most important because I’ve seen much more expensive piles of junk since I wrote this.
Nevertheless I, and probably you too have to use and maintain it. I had the following problem on a fresh installation of Windows XP SP3: every time I wanted to export, save as or open a drawing Corel Draw X3 would crash regularly with it’s darned Crash Wizard.I tried applying the patches found on the Corel support page but it didn’t help. After some digging I found that it’s a problem related to theCommon Dialogue function found in comdlg32.
You must launch regedit (ALT+R or START->RUN and type regedit and press enter) and go to:
[HKEY_CURRENT_USERSoftwareMicrosoftWindowsCurrentVersionPoliciescomdlg32]
and change NoFileMru from 0x00000001 to 0x00000000
Windows Registry Editor Version 5.00

[HKEY_CURRENT_USERSoftwareMicrosoftWindowsCurrentVersionPoliciesComDlg32]
"NoFileMru"=dword:00000000
If on your computer it’s already 0 it’s worth trying the other way around, just remember to set it back if it doesn’t help.
UPDATE: I encountered the very same problem with Corel Draw X4 (even after applying the Corel Service Pack for X4) with the ugly difference that the cause of the crash is not reported. Fortunately repeated crashes on open, save, save as and export made me remember this article and sure enough this was the cause.
UPDATE: Users are reporting the same problem of crashing with Corel X5 and Windows XP.
Am I the only one thinking Corel is getting crapier and crapier by the version? Well not really, updating this article now, after some time I feel that x4 is really an improvement over the x3.
UPDATE: Some users reported the same problem on other Windows versions. Also X5 had the same issues.

=============================================================================
i will show you how to fix coreldraw save, save as ,open and import problem 
When you try save coral a.r.m wil run and you cant save your work
this is fix 
1.run regedit (start-run-type regedit)
2.go to [HKEY_CURRENT_USER\Software\Microsoft\Wi­ndows\CurrentVersion\Policies\comdlg32]
3.and change NoFileMru from 0×00000001 to 0×00000000 
thats all save and other options will work now 

Sunday, February 28, 2016

Remove Extra Spaces from Excel Data

Does this sound familiar? You are searching for data that you know you’ve entered, but a query for Joe Smith simply doesn’t return any results. Or, how about – you are trying to add up two columns of numbers, but you keep getting errors.
Often, these issues are caused by extra spaces hiding before, after or between the text and numbers in your data. Especially when information has been copy/pasted into a spreadsheet, extra spaces can come along for the ride and lurk unnoticed until something goes wrong.
Excel offers several ways to help you remove spaces and clean up your data, but you will want to choose the right technique for the type of data you are working with. The following tips will describe two methods using functions and formulas to remove unwanted spaces from your data.
These steps will apply to Excel 2007-2013. Images were taken using Excel 2013 on the Windows 7 OS.
Use the Trim Function
The TRIM function removes all spaces from text except a single space between words. Use this function when you have text data that contains hidden spaces in the cell. In our example, you’ll see that there are multiple “Joe Smiths” in our data. At a glance, several of them even look the same. However, the # of Characters column reveals that there are hidden spaces buried in the text.
To use the TRIM function, you will need to create a temporary, or helper, column for the corrected data at the end of your spreadsheet. For the purposes of this demonstration, we’ve called the column “Trim.”

To follow using our example above, download Excel Remove Spaces Formula Template 1.xlsx
Next, click in the first cell of the Trim column. On the Formulas tab, click the Text dropdown menu in the Functions group and select TRIM.

After the dialog box appears, click on the cell that contains the text you would like to remove spaces from to complete the function. Click OK.

Copy the function to the remaining cells in the column to apply the function to the rest of the Name cells. You can see that the TRIM function cleaned up the extra spaces and the character counts are now all the same except for the “JoeSmith” that did not have any spaces between the first and last name. Note that TRIM will not ADD spaces.




Now you just need to replace your original data with your clean data. To do this, select all of the cells in the Trim column, then hit CTRL+C to copy the cells to the clipboard.
Then, select the first cell in the Name column and right-click. Select Paste Values under the Paste Options heading. Now you can Delete the Trim helper column and your Name column is clean.



Use a Formula to Remove All Spaces
If you need to prepare your data for import into a database (such as MS Access) or have a combination of number and text data that simply needs ALL spaces removed, you can use a formula instead of the TRIM function to remove ALL blanks in a cell.
Create a temporary, or helper, column for the corrected data at the end of your spreadsheet like you did for the TRIM function. In this example the column is called No Spaces.


Next, click in the first cell of the Trim column. On the Formulas tab, click the Text dropdown menu in the Functions group and select SUBSTITUTE.


When the dialog box appears:
  • Click on the first cell in the column that you need changed
  • In the “Old_text” field, enter the character you want replaced separated by quotes. To remove spaces this would then be ” “.
  • In the “New_text” field, enter the character you want to appear instead. Since we want NO characters to replace the space, type “”.
Click OK to apply the formula to the cell.


Copy the formula to the remaining cells in the helper column. Then copy the data to the data column as you did before using CTRL-C and Paste Options.
Fred Pryor Seminars_Excel Formula Remove Spaces_9
Bonus Hint!
You can also remove spaces using the Find/Replace feature in Excel. Click CTRL+F to open the Find dialog box, then click theReplace tab. Enter one space ” ” in the Find what: field and leave the Replace with: field empty to remove all spaces.
Warning: This technique will search for and replace ALL spaces in the entire sheet or selection area. Use carefully so that you don’t remove spaces you still want or need!
Fred Pryor Seminars_Excel Formula Remove Spaces_10
With these tips, you can clean up data entered from multiple sources and ensure that it is consistent and less prone to unintended duplication. Use these tips to remove spaces when you want to:
  • Find unintended duplicates in your data
  • Prepare someone else’s data before you import it into your own spreadsheets
  • Prepare your data for export into a database
When do you find the need to find and remove unwanted spaces?


Tuesday, February 16, 2016

Blocking web sites with Windows Firewall

First of all Go to Command Prompt and Do Ping URL to get IP address of that website:
Ping example .com
and you get IP Address of website
Pinging example.com [93.184.216.119] with 32 bytes of data:
Reply from 93.184.216.119: bytes=32 time=287ms TTL=43
Reply from 93.184.216.119: bytes=32 time=286ms TTL=43
Reply from 93.184.216.119: bytes=32 time=285ms TTL=43
Reply from 93.184.216.119: bytes=32 time=294ms TTL=43
Ping statistics for 93.184.216.119:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 285ms, Maximum = 294ms, Average = 288ms
go to Control Panel > windows FireWall > in the left side click Advanced Setting
go to Outbound Rule and in right side Click New Rule enter image description here
  • in New OutBound Rule Wizard select Custom and click Next
  • in Program Screen Select All Program And click Next
  • in protocol and ports Leave default Setting and click Next
  • in Scope Screen Under Which remote IP address Does This rule apply to? select These IP address and click add Button
  • in IP Address Dialog under This IP address or subnet: enter IP address of website and click ok and then click next enter image description here
  • in Action screen select Block the connection and click next
  • in Profile screen leave all 3 check box selected and click next
  • in Name Screen choose name for rule and click finish
    test what you do by enter URL in any browser that you want
    good luck!

Sunday, February 14, 2016

HOW TO GET FACEBOOK GROUP ID


How do I find my Page or Group ID?




https://lookup-id.com/

Lookup-ID.com helps you to find the Facebook ID for your profile or a Group. Facebook ID is a many-digit number, eg. 10453213456789123. 
Facebook ID for of certain Facebook social plugins, like the "Like Box" ; Like Button or application....

Q: What's my Facebook profile URL?
A: Your Facebook profile URL is the URL you get to when you click on your name in upper left of the Facebook home page. It should look like this:
- https://www.facebook.com/lookupid
- https://m.facebook.com/lookupid
- https://www.facebook.com/profile.php?id=278754422284374

Q: How to copy my Facebook profile URL when I'm on mobile?
A: It is very easy to copy your Facebook profile URL when you are on mobile and PC too.
1. Open your Facebook Profile page on a web browser.
Or you should be able to click here, it will redirect you to your profile page if you are logged into in your web browser
2. Copy the URL at the top of your browser and paste it in Lookup-id.com's search bar