Talk to me

[Helen1974]

Hi All,

I was wondering if it is possible to ask excel a verbal question via microphone and have excel respond verbally.

Example.....

You create a data table concerning your customers, rather than use a vLookup function you would simply ask a question and excel would simply answer its findings.

Thanks All

H

 

[shg]

Excel does not do that, no. Watson does.

 

[shg]

In response to your PM, Watson is the IBM computer that won Jeopardy.

https://en.wikipedia.org/wiki/Watson_(computer)

 

[Helen1974]

Hi SHG,

I am not familiar with Watson, so any extended help you can give to me would be very much appreciated.

In relation to my original question i want to set out a better example of what i want to achieve. From the following Spreadsheet table my goal is to get the Ref Number by searching both the Estate Name and Town, However, instead of manually searching the spreadsheet i would like to speak 2 words "Railway View, Clara" and have the returned value of "2".


[TABLE="width: 298"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Estate
Name[/TD]
[TD]Town
Name[/TD]
[TD]Ref Number[/TD]
[/TR]
[TR]
[TD]

Beechmount[/TD]
[TD]

Clara[/TD]
[TD]

1[/TD]
[/TR]
[TR]
[TD]Ashfield[/TD]
[TD]Clara[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Beechfield[/TD]
[TD]Clara[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Railway View[/TD]
[TD]Clara[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Redville[/TD]
[TD]Clara[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Clonshanny[/TD]
[TD]Clara[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Erry Mill[/TD]
[TD]Clara[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Erryarmstrong [/TD]
[TD]Clara[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Beechmount[/TD]
[TD]Tullamore[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Ashfield[/TD]
[TD]Tullamore[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Beechfield[/TD]
[TD]Tullamore[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Railway View[/TD]
[TD]Tullamore[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]Redville[/TD]
[TD]Tullamore[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Clonshanny[/TD]
[TD]Tullamore[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Erry Mill[/TD]
[TD]Tullamore[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Erryarmstrong [/TD]
[TD]Tullamore[/TD]
[TD]8[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

As shg mentioned in post#2, There is no way of doing that with Excel

 

[Helen1974]

Hi Fluff, have you any ideas how i might achieve this. I really thought it would be a simple task but i have obviously underestimated it.

 

[Fluff]

It can't be done.

 

[Helen1974]

Hi Fluff,

When you say it cant be done, do you mean it cant be done in excel, can it be done in any other software ?

 

[sheetspread]

Look at text-to-speech and speech-to-text software, Excel cannot handle this task alone.

 

[Helen1974]

Fluff you have been very helpful.

I will look into the software types which you have mentioned. Thanks for your responses to me.

Helen