Recent content by rvd48

well, when i distribute the file to people, they can easily use a excel password cracker and get into the locked cells and look at the hidden data, etc doesnt really seem a way around this.

guess i will have to give up on this front as my vb skills arnt up to scratch

tar, i plan to go to the states this year, then east asia/aus or new zealand nxt yr. got to make the most of my time before i get bogged down with a real job :D bird and responsibilities.

thanks brian, you've made it look simple, guess i was trying to over complicate it by referring the div/0! in my formula. business stds at uni. i've been in education for far too long, gcse's, a'levels and now uni. will be glad to graduate and travel around the world for a bit.

brian, i've tried this but i keep getting an error; =IF(SUMPRODUCT(($B$2:$B$7=$A$21)*($C$2:$C$7>=$J$18)*($C$2:C7<=$K$18))=0,0,if(SUMPRODUCT(($B$2:$B$7=$A$21)*($C$2:$C$7>=$J$18)*($C$2:C7<=$K$18)*($D$2:$D$7)/SUMPRODUCT(($B$2:$B$7=$A$21)*($C$2:$C$7>=$J$18)*($C$2:C7<=$K$18)*(D2: D7<>""="#div/0!"...

thanks brian for the detail when both price fields are empty i get a div error. i tried a if(is error formula but it doesnt seem to work properly i've added the xls sheet and highlighted the cell with the div error, should i be using the IS error function? cheers

thanks brian, i see the green bit means anything under or over 0 tar :D

hi guys, i have another issue on this. when it comes to the dividing part of the equation, it does not recognise that when a price cell is blank, it should ignore it. i've added the formula and comment in the .xls file attached, thanks, rvd

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...

mailman, that just leaves a #value error :(

ok, this is proving to be a problem for me. the vlookup template: VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) now, in the 'lookup_value' cell the user can enter a text like "RS5000 + racket" but my table array will contain a specific product list such as: col 1 ...... col...

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...

shades, thanks, i've got it working ;p

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...

darnit :( cant win em all