Search results

hi, i have a column of data that is linked to a drop down cell and few conditional formulas. how can i hide it so nobody can ever see it besides me? i've thought of setting the password in excel but its easily crackable, even if i change the font colour to white and hide the column - when the...

hi, i want to look up data so i can do some conditional formatting. =VLOOKUP(E1,A1:C10,2,FALSE) E1 says: 'oranges' so the vlookup looks at the cell range of A1:C10 for oranges, it finds it and gets the value next to oranges and reports it back. but say E1 was 'oranges + 2 pips' could i...

hi, i have a graph with results data plotted against time. the graph time range is now extended from (originally 2007) up to dec 2008. each month i will put the data in the table so the graph updates, but for the future months (may onwards) when the data is not preset, the graph line flatlines...

if i set a 20 character password, is it possible to crack it? i want my excel document to be secure from people modifying it but i know there are cracks available for MS Excel.

hi, i have attached a excel worksheet for calrity of my formula problem. When cells B1 and B2 are empty i want the formula (cell D5) to return a True answer, similarly when cells B1 and B2 have data in them i also want it to return a True answer. otherwise return a False answer...

hi, im trying to wrap my formula around the IS Error function: =SUMPRODUCT(($J$174:$J$274)*($C$174:$C$274=$B$406)*($F$174:$F$274>=$C$393*($F$174:$F$274<=$D$393))/SUMPRODUCT((1)*($C$174:$C$274=$B$400)*($F$174:$F$274>=$C$393)*($F$174:$F$274<=$D$394))) thats the original formula, now with is...

hi, this is a progression from a previous thread with a thankyou to Helicopter's help:) EDIT: see 2nd post below. thanks

hi, i would like to streamline the way my IF formula works. at the moment it is: =IF(AND($C500="Panasonic",AND($F500>=39356,$F500<=39447)),$J500,0) it looks at rows of data, if for instance the date the entry was added was in december 07, it would be flagged by the serial dates in the...

hi, i have a IF formula. =IF(AND($C175="product A",AND($F175>=39448,$F175<=39532)),$J175,0) were i have highlighted in red, rather than it looking directly at the cell reference in question as it is now. i'd like it to look at 2 cells: i.e. cell A would have the letter C in it and cell B2...

hi, im trying to solve my if statement: =IF(D88>1,"-","") i want it to do this: if there is any text in cell D88, then show a dash (-) otherwise display nothing. i need to get rid of the >1 , but i dont know what to replace it with that signifies as text. any help please?

hi, i have a excel sheet where i keep a log of some information in each row. Per row, there is a unique reference, e.g. J:\a) Non Standard\A123.xls. this represents an excel document in another folder. Now, i would like this reference column to be live, so that when i click on the reference of...

hi, my formula looks at a column of values and gets the average. problem is when there are no values in the column, it gives an error of #VALUE. the formula is: =AVERAGE(IF(ISERROR(AP155:AP184<>0),"NA",AP155:AP184)) can any1 help me please?

hi, i want to enhance my IF statement to include 2 more conditions. my current IF statement has 1 condition of only checking if IBM is present. =IF($C3="IBM", $J3, 0) what i want to do: (IF statement with '3' conditions). if cell C3 = IBM, and if cell F3 = 'Jul-07' or 'Aug-07', then display...

hi, i have an average statement which calculates the average prices =AVERAGE(IF(AG7:AG16<>0, AG7:AG16,"")) from a list of figures, this list of figures looks at table and selects the prices using an IF statement which looks at a drop down list and selects the corresponding value from cell 'J7'...

i have to set up a invoice. my database is about selling books, if a customer wants 20 copies of a book, then i enter the book id into the table, but how do i get the books unit price to appear at the same time as well ?

im trying to create a field where by, 2 other fields are multiplied together: "qty" and "cost". so i set the criteria to: ="qty*cost" but all fields return blank. im at a loss at where the problem is, this should be one of the easiest things to do in Access, but its not for me.

i would like to list all people if they are under 35, i thought it would be "=now()-35" but it isnt, anyhelp please?

I have a problem with a Paramount query. All I would like the query to do is, look through all the dates of the customer table. Use the date of birth to devide the customers into two tables for the 35 year olds and under. And 36 and over. But I just cannot seem to get my head around it. I...

im consistanly getting error boxes when i try to type in a phone number such as e.g. : 0113 2346410 the input mask for the phone number field is: 9000#\ 0000000 could somebody tell me on what i need to change in the input mask code?

i have a form which needs to be in Data sheet view. but when i double click on it in the objects window it goes into 'Form View'. i've changed the properties to: Allow Formview as 'No' and the other views bar Data sheet' view. how do i make it go into 'Data sheet' each time i double click on...