Search results for query: *

grgrgrrg... One simple question. How can i see what is the number associated with a specific date? So how can i see in excel what number 12-12-2008 is? What function do i need for that?

I will do that later today: i have to create a sheet. I have one problem at the moment: for the query to work, the sheet u base ure query on has to be formatted as a table. I tried doing that via the Data-Table, but cant seem to get that correct. It asks about the row and column. What should I...

But doing it like that, with the Query, u cant get the values in different sheets i think? Anyway , u do a select where date/time between date/time1 and date/time2 where column j = 0 and a same select where column j not 0 ?

Ok, so the time will always be between 0.00 and 1.00?

I think though FAQ68-5829 does help in some ways, its not what i really want. We have to do above mentioned procedure many times a day, always with different sheets, and different dates/times etc. Which means the query has to change many times a day, and the users who need to work with it, not...

I have read the FAQ, and it does answer some of my questions.. But I still am puzzled on how to use it? As mentioned cell Cx contains a date and cell Dx contains a time. I guess i need to create strings from the values in both cells and concatenate them with a comma or dot to keep both values...

I need 3 new sheets in fact. One sheet with the original data without duplicates, one sheet where column j = 0 and one sheet where column j not 0. And they have to be seperate sheets, because they have to be emailed to different departments, but all those departments just want to see the data...

Just new here, and i guess i have a simple question. I have a sheet with columns a to n. In column c, all filled rows, is a date, and in column d , all filled rows, is a time. I want to be able to convert those 2 cells to 1 unique number. I want this as i have to create a new sheet based on...