Summary: On worksheet 1 - I have a 2 columns and several rows of data. Column A has product names that are repeated. On worksheet 2 I want Cell A3 to show a l...
Summary: Hi guys I have an excel worksheet containing a list of supplier product codes and corresponding company product codes. I have set up another worksheet...
Summary: I'm trying to produce a summary of the words in a specific document, with a list of each word and how often they appear. Is there such a function or a...
Summary: I have a table of employee details i.e. Name Surname Employee ID In addition to values such as: Site ID and a week ending date. All contained on one ...
Summary: Hi, Make sure that you are entering dates that Excel recognizes. When Excel recognizes an entry as a date it converts it to a number, and formats it a...
Summary: After Hours Support Roster THE PROBLEM I have to prepare a weekly after hours support roster with the following criteria: The roster changes each Wedn...
Summary: Hi, You can do this manually, but reasonably quickly, and once you have followed this a couple of times it will be really easy! 1. Select all the date...
Summary: You might be able to automate Humar's suggestion by checking the Country Code for each machine upon opening the spreadsheet. See here for more info, i...
Summary: Create a new folder under your Contacts. Import the file data to that folder. Then, create a Distribution List, adding the names from the newly crea...
Summary: THis is only achieved in 2 steps and you must have a copy of works in order to manage it! SO send the file to a friend by email and get them to do th...
Summary: Thanks for your help. I'm aware of that, and it will work, but... My problem lies in that I'm copying a list of almost 200 objects, but the copy shor...
Summary: In an excel file I have a list of names and want people to enter comments for the latest status. Is there a way for excel to calculate that date the c...
Summary: The first column is a list of names and the first row is a list of dates. A time is put by the date they are working. This information then has to ...
Summary: I have a list of about 185 names in an Excel spreadsheet that I want to create an individual worksheet tab for each one with the name in the list as t...
Summary: It sounds like your second question calls for VLOOKUP. e.g. with your Client Numbers in TabName!A1:A5 and your Client Names in TabName!B1:B5, you woul...
Summary: You should try to use a subject line more relevant to the contents of your post. If everyone posted with a generic subject line like "Excel Help" it w...
Summary: Hi, Following up on the information you provided in response to DerbyDad03's question, It appears that you can simplify this substantially. As each st...
Summary: I have a list of buys that I receive and they are in one excel file with about 10 different worksheets. The worksheets have the date the product is ...
Summary: Hi there, I have a question which I hope you will have a simple answer too as I can't belive Microsoft would make it so difficult and I am just recko...
Summary: Shortcut to open a Word document: (I have Word 2000 but 2003 should be the same.) 1. Create a new shortcut (right click>on desktop>click on "new">cli...
Summary: Found this in OE Help; To create a group of contacts You can create a single group name (or alias) to use when sending a message to several contacts a...
Summary: Hello all, I just have a quick how to question. I have a list of dates and a list of numbers and I have to order the numbers (with the correspnding da...
Summary: I have a list of items as follows: car 3 ball 2 car 6 car 4 ball 5 car 3 ball 8 I want to look up the list and find the MIN for item car. The result s...
Summary: Good morning, all. I am trying to automate our version control process so we don't get smacked by ISO auditors and I'm having some difficulty. Current...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
