Search results

Thanks for that ! The function doesn't work from 'imported' data which is what I hadn't taken into account ie. ignores cells where the data is coming from a separate Worksheet, eg. = Sheet2.a5. Silly me !

Thanks PO, trouble is I'm not sure which function I should be using or disabling. In a spreadsheet where there are recurring items, I want them to 'autofill' which in some spreadsheets they do but not in others. I am referring to this function in a column within a spreadsheet where all the...

Open Office Spreadsheet, I am trying to make use of the predictive function ( in the same column in the spreadsheet having already loaded the options as parameters in that column. It seems to work sometimes and not others. Can anyone suggest what I may be missing here ? And yes, I have tried...