Search results for query: *

I have had to get the Windows User Profile reset which has resulted in the Outlook settings getting lost-no E-mails were lost and the views look the same but I have lost all the categories I have added to the Master Category list and about 7 additional mailboxes-shared through Exchange which...

Also is there a way to prevent users clearing the Data Validation from the cells in the spreadsheet

I have manged to get this to work with the Data Validation as follows:- Cell D1 =B9<>"" Ignore blank I have copied this to the other cells and the validation is now working however if a user enters data into B1 and then D1 following the validation and then subsequently deletes the data from B1...

That would be great thanks.

The validation doesn't require drop down just to prevent useres from entering data if the cell referred to in the formula is blank. I have tried the following in the Data Validation formula and it seems that it could work but there is an error:- =NOT(D9)="" (Select 'Ignore blank') However...

I am trying to create a formula in the Data Validation (Excel 2002) that only allows data to be entered if data has been entered into another cell in the same row-this needs to follow the same logic for 4 columns i.e. is it possible to use Data Validation to control the order that data is...

Please can anyone advise if it's possible to use named ranges oin the vlookup function.

Thanks for everone's help with this.

I have exported a large number of E-Mails to a PST file from Outlook 2003 in the unicode format-however when trying to import this into Outlook 2002 an error message advises that the file isn't compatible-it's suggested that the PST is exported using Outlook 2002 format however the problem is...

Thanks Geoff-please could you advise how the VLOOKUP formula should be written based on the Area in Coulmn A and the look-up table in Column M/N-this seemed to return 0 values last time-thanks for your help with this.

Thanks for the replies to this-the problem with 'SUMIF' is that it only allows for a single value to be added to the criteria e.g. it's possible to sumif A1:A100 is Area 1 but not if A1:A100 is Area 2 and Area 10 However, I have got round this using the 'SUMPRODUCT' function-the problem with...

There isn't any logical relationship between Area and Region-this would need to be grouped manually, however the aim would be once the Areas are matched to the regions this logic can be saved and applied whenever the source data changes. There seems to be several tools for analysing groups of...

Thanks-I have tried this-does the data need to be grouped together in order for this to work correctly as the areas that need to be grouped together are not in any order and the rows are seperated by various sub headings e.g. COLUMN A COLUMN B BASIC COST Area 1 £250 Area 7...

I have exported a large number of E-Mails to a PST file from Outlook 2003 in the unicode format-however when trying to import this into Outlook 2002 an error message advises that the file isn't compatible-it's suggested that the PST is exported using Outlook 2002 format however the problem is...

I am analysing data in a spreadsheet and need to group together records-the problem is the data is exported from an application and therefore the data is dynamic-also the application creates section headings that make it difficult to sort the data. I need to group areas into regions then sum...

Thanks for the replies-the source data is exported from a SQL application that is hosted on a Citrix Server-the application export function requests the location of where the spreadsheet should be exported to-it then creates the spreadsheet. I can use the suggestion of copying the colour...

I am trying to copy some information to a new workbook however the colours are not copying over-the cell background on the source data is Dark Blue and the font colour is white, however when this is pasted the cell background is black and the font colour is red. This doesn't happen when pasting...

Thanks-is there any way to design a pivot table to give these results without formatting the source data this needs to saty the same-have managed to get the same results by using the 'countif' formula which counts the number of instances for each year in the selected range, however I would like...

I am trying to set up a pivot report to summarise the following data:- Adress Type A Type B Type C Type D 1 Smith Street 2008 2009 2018 2008 2 Smith Street 2018 2008 2010 2008 3 Smith Street 2014 2015 2015 2015 4 Smith Street 2015 2017 2018 2014 5 Smith Street 2012 2014 2015 2014 6 Smith...

Thanks-this is now working.