Thank you Mohit.

--------------------------------------------------
From: "Mohit Gupta" <[email protected]>
Sent: Monday, September 24, 2012 2:33 PM
To: <[email protected]>
Subject: Re: [AI] excel formula

hello Friends

f you want to prevent duplicate data from being entered into a range, here
is a pretty simple solution by using *Data Validation*.

  1. Select the range of cells in which you want to prevent duplicates
  (for example, A1:A50).
  2. From the *Data* menu select *Validation*.
  3. Click on the *Settings* tab.
  4. From the *Allow* dropdown box select *Custom*.
  5. In the formula box type *=COUNTIF($A$1:$A$50,A1)=1* *(see explanation
  below)*
  6. Click on the *Error Alert* tab.
  7. In the *Title* box type "*Duplicate Entry!*"
  8. In the *Error Message* box type "*You cannot enter a value already in
  the list.*"

*Explanation:*
This formula tells Excel to count how many times the data from the current
cell is included in the validation range. If the answer is equal to 1 then
the formula =COUNTIF($A$1:$A$50,A1)=1 is TRUE and everything is OK.
However, if the answer is not equal to 1, then the formula is FALSE and an
error occurs causing the Error Alert.

Instead of typing the cell ranges in the formula, you can select them with
the mouse. For the validation range (i.e. A1:A50) select the range, then
press the F4 key to make it an absolute reference (includes dollar signs).
For the criteria range (i.e. A1) click on the first cell in the validation
range (no dollar signs). You do not need to copy this formula. When you
select the range first and then apply Data Validation, the validation
applies to the whole range. The cell reference you use in the formula is
not limited to one column. You can use a range such as $A$1:$C$50.

regards

CA mohit gupta

On Mon, Sep 24, 2012 at 10:37 AM, <[email protected]>wrote:

Send AccessIndia mailing list submissions to
        [email protected]

To subscribe or unsubscribe via the World Wide Web, visit

http://mail.accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in

or, via email, send a message with subject or body 'help' to
        [email protected]

You can reach the person managing the list at
        [email protected]

When replying, please edit your Subject line so it is more specific
than "Re: Contents of AccessIndia digest..."


Please do not reply to this digest mail. You should put your comments into
a new mail with appropriate subject line.
_______________________________________________
AccessIndia mailing list
[email protected]

http://mail.accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in


Today's Topics:

   1. Hos usd to open an E MAILS in microsoft outlook?
      ([email protected])
   2. Fwd: New Radio services for sensory impaired people. (Wahid Raza)
   3. FW: AFB blog post: A Review of the Humanware Communicator App
by Scott Davert, Helen Keller National Center: Part 1 (Bhavesh Shah)
   4. Re: excel formula correction (Mukesh)
   5. Audio Description for the Movie Barfi (Swati Sinha)
   6. Google Books Accessibility (with focus on tallyho); Tesseract
      OCR accuracy specially for Hindi? (Amar Jain)
   7. Re: how to restrict youtube from opening
      ([email protected])
   8. Re: Save start up time (Zujar Shabbir Kanchwala)
   9. Re: Problem with the login page of gmail.
      (Zujar Shabbir Kanchwala)


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

Message: 1
Date: Sun, 23 Sep 2012 19:05:04 +0000
From: "[email protected]" <[email protected]>
To: "[email protected]" <[email protected]>
Subject: [AI] Hos usd to open an E MAILS in microsoft outlook?
Message-ID: <[email protected]>
Content-Type: TEXT/PLAIN; charset=UTF-8


Sent from my Nokia phone
plz tell me procedure



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

Message: 2
Date: Mon, 24 Sep 2012 01:25:11 +0530
From: Wahid Raza <[email protected]>
To: accessindia <[email protected]>
Cc: list <[email protected]>
Subject: [AI] Fwd: New Radio services for sensory impaired people.
Message-ID:
        <
caejdvbjyiefcrwm6ywdwzhpo1wfumnp+d1knby4-uvsot3n...@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

Hi all,
hope all are doing fine
pasting below article, which get from another list.
Regards
Wahid

---------- Forwarded message ----------

new radio services on horizon

NPR, Harris Corporation and Towson University Launch Global Effort To Make
Radio Accessible to Hearing and Sight Impaired

Tuesday January 8, 12:00 pm ET

First Over-The-Air Transmission From Special CES Station

LAS VEGAS, Jan. 8 /PRNewswire-FirstCall/ -- (LVCC S227) -- NPR, Harris
Corporation and Towson University today announced a new initiative to make
radio more accessible to the hundreds of millions of hearing and visually
impaired people around the world.
At a press conference at the Consumer Electronics Show in Las Vegas, the
three organizations announced the global accessible radio technology
initiative and provided the first live demonstration of the accessible
radio technology. The group also announced a new research center for
developing future technologies on the campus of Towson University near
Baltimore, MD. Additional plans call for the establishment of an
international consortium of equipment manufacturers,
broadcasters and other organizations to help foster broad adoption of the
initiative. The initiative will be spearheaded by the three founding
organizations and will leverage cutting-edge HD Radio(TM) technology to
enable hearing-impaired people to "see" live radio content on specially
equipped receivers by applying television closed-captioning processes to
radio broadcasts. The technology also will provide audio cues and voice
prompts, as well as advanced radio reading services, for those visually
impaired and blind.
"Digital radio technology makes it possible -- for the first time -- to
serve the sensory impaired," says Mike Starling, vice president and chief
technology officer of NPR. "Beyond developing the technology, this
initiative will ensure the accessibility of these radio services at minimal costs." During the press conference, the organizations showcased the first over-the-air transmission of the accessible radio technology using a signal from WX3NPR, a special temporary station authorized by the FCC for the live broadcast. Attendees at the press conference watched the text transcript of
the NPR flagship morning news magazine "Morning Edition" on the HD Radio
receiver's viewing screen, which is what a hearing-impaired listener will
see using the technology.
Additionally, the demonstration carried a digital radio reading service
that will assist the visually impaired with daily readings of current
books, newspapers and magazines.
Following the demonstration, the participating organizations unveiled
details for the International Center for Accessible Radio Technology
(ICART), which will be headquartered at Towson University in Towson, MD.
Towson will house the primary administrative and academic research office
for the initiative, with NPR Labs in Washington, DC, providing technology
R&D and software development, and Harris Corporation supplying transmission
and research support at its radio broadcast technology center in
Cincinnati, Ohio.
Members of the global initiative went on to detail plans to further study
and understand the challenges faced by the sensory-impaired population in
accessing radio broadcasts, and develop methodologies to address those
issues through cutting-edge technologies. To ensure that the effort
represents the widest range of participants and fosters the broadest
possible adoption, organizers
said they will work to bring together policymakers, broadcasters,
transmission equipment companies and receiver manufacturers from around the
world. Presently, the initiative has more than a dozen members,
representing virtually every aspect of the "microphone to loudspeaker"
chain: broadcasters, network
content providers, infrastructure and transmission equipment companies, and
receiver manufacturers. In addition to founding members NPR, Harris and
Towson University, supporting organizations include iBiquity Digital
Corporation,

elphi, NDS, Radiosophy, Helen Keller Institute, Carl and Ruth Shapiro
Family National Center for Accessible Media at WGBH(NCAM), Northern
Virginia Resource Center for Deaf and Hard of Hearing Persons, and the
G3ict, an Advocacy Initiative of the United Nations Global Alliance for ICT
and Development. NPR, Harris and Towson will jointly determine strategic
direction of the organization, with assistance from the initiative's full
membership. NPR will provide much of the content, Harris will provide much of the transmission- related technologies, and Towson will provide research
into the needs of the sensory-disabled
population and will house the primary ICART facility on its campus.
"We're working very closely with radio stations around the world to ensure they have the right technical infrastructure in place for this initiative,"
said Howard Lance, chairman, president and chief executive officer of
Harris Corporation. "The new HD Radio transmission systems we're installing are tailor-made for this effort, as their digital capabilities will make it
relatively easy for stations to transmit live textual transcripts to HD
Radio receivers." "There is tremendous need for accessible radio for
sensory-impaired people, including the deaf, hard-of-hearing, blind,
visually impaired, print impaired, deaf/blind, and mobility impaired," said
Dr. Ellyn Sheffield, assistant professor of psychology at Towson and
co-director of ICART. "There is no question this initiative will have a
profound impact on the quality of millions of people's lives. Finally,
sensory-disabled individuals will have access to all radio programming, as
well as radio emergency alerts and vital disaster
recovery information."
HD Radio enables station operators to split their broadcasts up into
multiple channels, providing several CD-quality channels for their
audiences. Through this accessible radio initiative, a small amount of the
total data capacity will be used to carry textual data that will be shown
live on a screen on new versions of HD Radio receivers, essentially
providing a closed- captioning transcript of live broadcasts for the deaf.
Initially, the closed-captioning text will be created by live,
court-reporting-type captioners at individual stations and networks.
Ultimately, the initiative is hoping to leverage advanced speech-to-text
translation software applications that one day allow expansion of
captioning across the radio dial. Specially equipped HD Radio
receivers are in development with several features to provide the visually
impaired audience with better access to broadcasts, such as audio prompts
that notify which direction the tuner is going, what channel the radio is
on, and larger, easier-to-read text on the radios.
More than 1,500 radio stations are currently broadcasting in HD Radio in
the United States. Over half of the CPB-qualified stations have been
awarded HD Radio conversion grants by the Corporation for Public
Broadcasting. According to current estimates, by 2013, all 825 public radio
stations should be broadcasting digitally.
More information on the initiative can be found at
www.i-cart.net.

----



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

Message: 3
Date: Mon, 24 Sep 2012 09:30:20 +0800 (SGT)
From: Bhavesh Shah <[email protected]>
To: [email protected]
Subject: [AI] FW: AFB blog post: A Review of the Humanware
        Communicator App        by Scott Davert, Helen Keller National
Center: Part 1
Message-ID:
        <
1348450220.70573.bpmail_high_noncarr...@web193005.mail.sg3.yahoo.com>
Content-Type: text/plain; charset=utf-8






----Forwarded Message----
From: [email protected]
To: [email protected]
Sent: Mon 24 Sep, 2012 12:56 AM BST
Subject: AFB blog post: A Review of the Humanware Communicator App by
Scott Davert, Helen Keller National Center: Part 1

bhavesh shah thought you'd be interested in this blog post from
VisionAware. "A Review of the Humanware Communicator App by Scott Davert,
Helen Keller National Center: Part 1" This post can be found on the web at:
http://www.visionaware.org/blog.aspx?BlogEntryID=456 Visit VsionAware at:
http://visionaware.org



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

Message: 4
Date: Mon, 24 Sep 2012 08:03:53 +0530
From: "Mukesh" <[email protected]>
To: "Access India" <[email protected]>
Subject: Re: [AI] excel formula correction
Message-ID: <8D99D246213B4000B56886C2C0B2EB2B@MukeshPC>
Content-Type: text/plain;       charset="iso-8859-1"




From: Mukesh
Sent: Monday, September 24, 2012 5:56 AM
To: Mukesh
Subject: Re: excel formula correction


Hello Friends,
Sorry for trouble. Now I realized my mistake in formula and I have
corrected it successfully. With your kind cooperation and guidance I have
completed my database today. Now I have a problem of prevent duplicate
entry only. If anyone of you know how to prevent duplicate entry rather
than removing it later using remove duplicate function in excel. Waiting to get a positive guidance from you to complete my database today. Thank you.

Regards

Mukesh Baviskar
Mobile: 9403161157


From: Mukesh
Sent: Sunday, September 23, 2012 8:44 PM
To: Access India
Subject: excel formula correction


Dear Friends,
I have created a formula in excel but I found a error in which I can not
identify. Therefore I request all of you to correct my mistake in the
following formula.


=COUNTIF(AN5:AN1000,"NSKMVIJAN",COUNTIF(AN5:AN1000,"NSKMVIFEB",COUNTIF(AN5:AN1000,"NSKMVIMAR",COUNTIF(AN5:AN1000,"NSKMVIAPR",COUNTIF(AN5:AN1000,"NSKMVIMAY",COUNTIF(AN5:AN1000,"NSKMVIJUNE",COUNTIF(AN5:AN1000,"NSKMVIJULY",COUNTIF(AN5:AN1000,"NSKMVIAUG",COUNTIF(AN5:AN1000,"NSKMVISEPT",COUNTIF(AN5:AN1000,"NSKMVIOCT",COUNTIF(AN5:AN1000,"NSKMVINOV",COUNTIF(AN5:AN1000,"NSKMVIDEC"))))))))))))
Waiting for your correction tomorrow. Thank you.

Regards

Mukesh Baviskar
Mobile: 9403161157

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

Message: 5
Date: Mon, 24 Sep 2012 09:26:37 +0530
From: Swati Sinha <[email protected]>
To: accessindia <[email protected]>
Subject: [AI] Audio Description for the Movie Barfi
Message-ID:
        <
cafent5tqhy8oa1wayc28sh+iklmmgs-y-2octryp-4pu27v...@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

Dear list members,
Can I get the Oscar nominated Movie Barfi with audio description?
I watched this movie, but as the movie is all about a deaf and dum
boy, and a MR girl, there were not much of dialogs only actions. So
this movie did not interest me much.
But I seriously want to comprehend the theme and the emotions in the flim.
 Or, can we do anything to make this movie audio descriptive?
I have heard that it is an excellent movie to watch.


Regards!
Swati M Sharma
when things don't seem to be going your way, always know that God has
a plan for you. If you place your trust in Him, He will give you great
gifts. We don't always know what God's plans are for us. We just know
that His ways are not our ways, but His ways are always best!

--
when things don't seem to be going your way, always know that God has
a plan for you. If you place your trust in Him, He will give you great
gifts. We don't always know what God's plans are for us. We just know
that His ways are not our ways, but His ways are always best.



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

Message: 6
Date: Mon, 24 Sep 2012 09:38:16 +0530
From: Amar Jain <[email protected]>
To: accessindia <[email protected]>
Subject: [AI] Google Books Accessibility (with focus on tallyho);
        Tesseract OCR accuracy specially for Hindi?
Message-ID:
        <
cajpc6hq_ah++gx9cssmqbjtsn+qqvk2_x5+tc0zojpjox6c...@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

Hi All,

We all know; google books presents information in scanned form. Mobile
Preview (which to my knowledge presents things in text using OCR) does
not work for many books. So, is there any workable solution at this
time? Has anyone tried Tallyho (the screen reader) as a solution for
reading google books?

I would also like to know the accuracy of Tesseracts OCR (specially for
Hindi).

Regards,
Amar Jain.



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

Message: 7
Date: Mon, 24 Sep 2012 04:16:28 +0000
From: "[email protected]" <[email protected]>
To: "[email protected]" <[email protected]>
        ,       "[email protected]" <
[email protected]>
Subject: Re: [AI] how to restrict youtube from opening
Message-ID: <[email protected]>
Content-Type: text/plain;       charset="utf-8"


-----Original message-----
From: Sheik mohammedali
Sent:  09/21/2012, 10:21  am
To: [email protected]
Subject: Re: [AI] how to restrict youtube from opening


internet explorer:
go  to internet options usually under control pannel or type inetcpl.cpl
under run.
then, pres control+tab until you get privacy page.  then, press tab until
you get sites... and type the site which you want to block and press tab
until you get block.
----- Original Message -----
From: "Shona Man" <[email protected]>
To: "accessindia" <[email protected]>
Sent: Thursday, September 20, 2012 11:05 PM
Subject: [AI] how to restrict youtube from opening


> Hid friends I am using internet explorer 8 and mozilla 15, I want that
> nobody could open youtube from my system because it waste my time. So
> friends please guide me how can i restrict youtube from opening in
> these browsers.
>
> --
> LL.M candidate
> at Faculty of Law in University of Delhi
>
>
> Search for old postings at:
> http://www.mail-archive.com/[email protected]/
>
> To unsubscribe send a message to
> [email protected]
> with the subject unsubscribe.
>
> To change your subscription to digest mode or make any other changes,
> please visit the list home page at
>
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
>



Search for old postings at:
http://www.mail-archive.com/[email protected]/

To unsubscribe send a message to
[email protected]
with the subject unsubscribe.

To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in





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

Message: 8
Date: Mon, 24 Sep 2012 10:23:56 +0530
From: Zujar Shabbir Kanchwala <[email protected]>
To: [email protected]
Subject: Re: [AI] Save start up time
Message-ID:
        <
cab0qppzc8owxhgxpg+9qn0g2sdzx9cksop5m_8rrubz9u7b...@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

Here's one tip to disable programs/services that you may not want to
run at startup thus saving startup time:

1. Open the Run dialog box by pressing WINDOWS+R.
2. Type "msconfig" without quotation marks in the edit box and press
ENTER to open the System Configuration dialog box.
3. Switch to the Startup tab of the dialog box by pressing CTRL+TAB as
many times required.
4. This tab lists programs that are marked to start automatically at
startup. Uncheck the ones that you wish to disable.
5. Activate the OK button to apply changes and close the System
Configuration dialog box. Restart if required.

A word of caution:-
Disable programs that you are sure of not hampering your system. Use
the :Disable All" button only if you are 100% sure of what you're
doing.

On 9/20/12, Sheik mohammedali <[email protected]> wrote:
> which is your operating system?
> ----- Original Message -----
> From: "Mukesh" <[email protected]>
> To: "Access India" <[email protected]>
> Sent: Wednesday, September 19, 2012 10:22 PM
> Subject: [AI] Save start up time
>
>
>> Hello friends,
>> Please suggest me how to save the computer start up time by removing
>> unwanted programmes while starting up the computer. Thank you.
>>
>> Regards
>>
>> Mukesh Baviskar
>> Mobile: 9403161157
>>
>> Search for old postings at:
>> http://www.mail-archive.com/[email protected]/
>>
>> To unsubscribe send a message to
>> [email protected]
>> with the subject unsubscribe.
>>
>> To change your subscription to digest mode or make any other changes,
>> please visit the list home page at
>>
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
>>
>
>
>
> Search for old postings at:
> http://www.mail-archive.com/[email protected]/
>
> To unsubscribe send a message to
> [email protected]
> with the subject unsubscribe.
>
> To change your subscription to digest mode or make any other changes,
please
> visit the list home page at
>
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
>
>


--
Best Regards,
Zujar...

An optimist laughs to forget, whereas a pessimist forgets to laugh!



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

Message: 9
Date: Mon, 24 Sep 2012 10:37:37 +0530
From: Zujar Shabbir Kanchwala <[email protected]>
To: [email protected]
Subject: Re: [AI] Problem with the login page of gmail.
Message-ID:
        <CAB0QppZYxSMAORbMdHEhbS_k_-0EGqip=
[email protected]>
Content-Type: text/plain; charset=ISO-8859-1

Thanks for sharing this tip. Anyway I cannot implement it on my N79.

On 9/19/12, Vikas Kapoor <[email protected]> wrote:
> Yes, there's no doubt that the log in page for some of the sites has > been
> redesigned and it has become inaccessible over a phone through a screen
> reader, but if you are using the qwerty keyboard, you can still type > your > login phrase by locating your cursor at the appropriate position and > let
the
>
> keyboard be in Alfa mode and not in numeric mode because this way the
> special Talks navigational keys won't be active, and once you are done
with
>
> that, you can change it to numeric mode to be able to use the > navigation
> mode.
> ----- Original Message -----
> From: "Zujar Shabbir Kanchwala" <[email protected]>
> To: <[email protected]>
> Sent: Wednesday, September 19, 2012 9:19 PM
> Subject: Re: [AI] Problem with the login page of gmail.
>
>
> yes - I've experienced this issue. The textbox appears correctly after
> disabling Talks, I login with sighted assistance after disabling
> Talks.
>
> On 9/19/12, [email protected] <[email protected]> wrote:
>> Hi friends,how are you all?friends i'm having a problem with the login
>> page
>> of gmail,when i try to login to my gmail account from my nokia e5
>> mobile,i'm
>> unable to login friends are you all facing the same problem?please
>> reply.regards.
>>
>>
>>
>> Search for old postings at:
>> http://www.mail-archive.com/[email protected]/
>>
>> To unsubscribe send a message to
>> [email protected]
>> with the subject unsubscribe.
>>
>> To change your subscription to digest mode or make any other changes,
>> please
>> visit the list home page at
>>
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
>>
>>
>
>
> --
> Best Regards,
> Zujar...
>
> An optimist laughs to forget, whereas a pessimist forgets to laugh!
>
>
> Search for old postings at:
> http://www.mail-archive.com/[email protected]/
>
> To unsubscribe send a message to
> [email protected]
> with the subject unsubscribe.
>
> To change your subscription to digest mode or make any other changes,
please
>
> visit the list home page at
>
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
>
>
>
>
> Search for old postings at:
> http://www.mail-archive.com/[email protected]/
>
> To unsubscribe send a message to
> [email protected]
> with the subject unsubscribe.
>
> To change your subscription to digest mode or make any other changes,
please
> visit the list home page at
>
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
>
>


--
Best Regards,
Zujar...

An optimist laughs to forget, whereas a pessimist forgets to laugh!



End of AccessIndia Digest, Vol 58, Issue 1639
*********************************************


Search for old postings at:
http://www.mail-archive.com/[email protected]/

To unsubscribe send a message to
[email protected]
with the subject unsubscribe.

To change your subscription to digest mode or make any other changes, please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in



Search for old postings at:
http://www.mail-archive.com/[email protected]/

To unsubscribe send a message to
[email protected]
with the subject unsubscribe.

To change your subscription to digest mode or make any other changes, please 
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in

Reply via email to