Recent content by tastie

Hi - hope you can help. I have two list of numbers that I want to create one list of anything that is in both lists. Example extract: List 1 List 2 123 456 456 132 789 987 465 321 132 798 798 The new list being: 456...

Hi I have accendetally saved an excel file that I didn't want to save. Is it possible to "unsave" the file? Any help greatly appreciated! Tastie

Graham Thank you for your reply The problem seems to have cleared since yesterday - but I still would like a solution in case it happens again. I tried what you suggested - but the icon for the filter and on the menu bar were not faded out when I had the problem over the last couple of days...

Geoff Sorry - I meant arrows (yesterday was not a good day for me)- The autofilter arrows do not appear at the top of the columns, So I can't even filter. Thanks Tastie

Hi all Since yesterday I can't get the Autofilter to work ie the errors appear in the selected columns, on any of the excel spreadsheets that I use - even a new one one with gook in. I have done the follow: Switched the autofilter off Unhide all rows and columns deleted any merged cells The...

Hi I have had this problem before check: 1. That in the look up table the company names are in descending order. 2. That none of the company names are repeated - the fist one will be picked and if this is a blank or does not match what is being looked for then the result will be N/A I know...

This happens to me a lot - when I have created a table in Word, when it is displayed in the Normal view its how I want it, but in print layout view the rows are broken up with breaks in between, and some of the rows are repeated with the same words. How do I get what the normal view and the...