Search results for query: *

Just going one step back now that we have the solution, would it not have been possible to use: =IDENTICAL(A1:A7, "Bird") I suppose it would need adapting a bit, because there were additional words within the cells (e.g. small black bird, bird without feathers, bird on a roof) so it wouldnt be...

Good thought Geoff. Could you give me an example of how to do that? I've never worked with pivot tables before...

Many thanks Geoff, we found the bird! Your last example worked whilst trying it in the same row. So in future a golden rule, for me, is to ALWAYS put the formula in the SAME ROW at the end (next to the data in subject)?? Otherwise the formula won't work? Thanks also to Ken and Gavona for your...

No I wanted the output to be on a new spreadsheet. But for test purpose I entered your command into a cell several rows underneath the last data on the original spreadsheet and this is what I got: 'The formula contains an error' and the last command is highlighted: ,"","Bird found" If I put a...

Maybe there is just a minor error in my command?

Do I need the 'upper' phrase within? Actually this is just an example another word is used (Bird - only first letter in capitals). This is how far I got but there is still an error: =WENN(ISTFEHLER(FINDEN("BIRD";('ALL CUSTOMERS'!J2&K2&L2&M2&N2&O2&P2&Q2&R2))),"","Bird found")

Thanks for your quick reply Geoff. No wonder I didnt find it out! :) Is there no formular for this standard filter, which surely would be widely used? I mean, it is only the result from a data filter of several cells!? Are you sure there is no standard function in that big list? I tried your...

I cant find out how to output data (e.g. BIRD) that is within several columns of one Excel datasheet into a new datasheet. The thing is that BIRD isnt always in one of the 9 columns, so I only want the rows pasted that actually have the word within the row's nine columns. This is what I think...

tar! :)

What is that?

Instead of the usual http://192.168.0.1 I mistakenly put "127.198.0.1" in the browser to access my Internet router. Usually if I put a wrong number in it says "this page cannot be found". But this time, by coincidence, it asks for pw etc. Under the above ip I couldnt find anything in Google...

Is there an expert here who can explain the difference?

Thanks to both of you. I changed the account name to the same as the Win2000 computer, but the login window still appears. Then I took out the password (same as on main computer) and now it logs on automatically. Though the original name still shows up on windows logon, the account name is now...

Howcome it seems to be that just when a solution is about to come around, either someone else tells me another thing or the last person doesn't finish...!? :( Maybe someone else can tell me: is it really necessary to passwort secure MySql against hackers? How secure is this, seing as I have it...

Do you need to buy that software? Can it not be done with TELNET, which is already integrated in Win2000? mk:@MSITStore:C:\WINDOWS\Help\telnet.chm::/CHM=Telnet.chm%20META=a_telnet_overview

On my laptop I have a normal windows login. After that I have to logon to the network (server). As I dont want to have to do the 2nd step each day, how can I automatically configure the logon to "accessible folders" upon Windows logon? The laptop uses WinXP home, the main PC is Win2000. Two...

Yes, and I responded giving the output "Empty set (0.05 sec)". I think you were the closest to getting there, but there must be something else to it. I got no additional row of info. Just the 'mysql>' command again.

I understand that this has gotten far-fetched, as it should be a simple, standard procedure (passwort setting)!? In my first post, you see what the OpenCMS has told me to do to set the password. But I get: ERROR 1136 (21S01): Column count doesn't match value count at row 1 I suppose my 3rd post...

I can log in normally btw: Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 5.0.23-community-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql>

Empty set (0.05 sec) Thanks for helping, what next?