Recent content by is1ma1il

thank geoff for you quick reply.

I have a pivot table where the drop PAGE field which in the sheet covers a1 and b1, the drop Column is also in column B. But in the pull down menu for the drop PAGE i want to be long maybe covering 3-4 columns as i can expand the column width but this also expand the drop column so looks funny...

=IF((FIND("sold",A1))>=1,"S","B") try this.

sorry it worked when the data was cleaned, it had blanks in there. Thanks guys

it says that i cannot group by the date selection

I have columns in an excel spreadsheet with thousands of rows of data that is based on date e.g. 01-JUN-03 or 10-JUN-03. I need to count how many rows are present per month. tried dcount but not sure what am doing.

can you send the spreadsheet to is1ma1il@hotmail.com for me to look at?

have you tried countif?

Hi, can someone help me out and inform me what the exit codes mean e.g. exit code 0,1,2,3,4,5, etc... for scheduled tasks. Thanks in advance.

Hi, I am trying to do a microsoft query to pull data from a csv. And in field date is as a string. but once the microsoft query has run i need the date field to be a date field, so i can sort it by date. Can it be done in the query?

Ray, I would like more explaination if you dont mind. where is the <ALL> option? do you stick the like part in the query? what if one of the pull downs is blank sorry ken

Hi, I am trying to query a table using a form which the user selects their desired options from a number of pull down, the person may not want to use all the pull down just some, can anyone help me on this, i have set up the form with the pull downs on which gives the user his selection...

Thanks

HI, Am in Excel, in cell A1 I have =today(), this is formatted as custom ddmmyy(which is 300902). when I reference the cell in a2 (=A1) it comes out as a1 (300902), BUT when I reference it in a3 (=d1&&quot;/&quot;&a1&&quot;/&quot;&f1) it comes out as 37502, which i guess is the unformatted...

thanks guys