is there any way to show only Distinct values in the column i.e in the column Dept. IT Finance Accountants Adminstrations Finance IT THE result shoud be IT

I have several people that share files. I need to set each person up to be able to view and edit only the data partaining to them with out seeing other peoples...

Hi all! Is there any way that I can repeat the same page about 100 times with a header reflecting the page number? I need to print out one page 100 times, but...

I have a problem that i'm sure someone can help me with. I have a list of every area code in the USA and it's corresponding State. I want to be able to read...

I have been requested to create charts by the week of the year, which display the number of patient discharges day of the week (Sunday through Saturday),by...

I can a very large excel workbook that contains over 80 worksheets. I would like to create a recap that looks at each worksheet and returns a value. All of...

Thru the DOS Prompt I created a txt file of a directory. I then opened it in Excel. I created a report in Access of similar data and copy/pasted it into the...

I am trying to determine total elasped time of an event. For instance if something starts at 6:40 A.M. and stops at 16:30 P.M. what is the total elapsed time? ...

I'm creating a form that has 120 rows. Each row will have the same functionality. There will be a combo box at the beginning of each row. This combo box...

I have a worksheet where I am pulling a price range from a website (example: (cell b2) $177-$219) and I need to extract the smaller number for a sum of formula...

I am tring to do a Lookup on a negative number. Not a specific negative number, but the first time the number becomes negative. I don't know to put this into...

Is there any way to allow excel to permit more than 7 funtions in a formula. I have several formulas in a worksheet with up to 7 functions, but if I try to add...

On my job I get paid waiting time when I arrive at terminal. But the waiting time stops when the overtime starts. Example: Arrive at terminal: 17:00 Overtime...

Hi, I would be very grateful if anyone could help me out in entering this mathematical equation into Microsoft Excecl 2000: y = e^x - 3x^2 All help is...

On one of my worksheets, I can't change a cell from showing the formula to showing the results of that formula. Regardless of what cell I go to, all I see...

First of all sorry for my English (I'm from Italy...) Is it possible to link a color (green for example) to a number? This to have the possibility to make a...

I would like to be able to add the values of one column based on values in three other columns (no problem with that), but would also like to be able to do...

Hi: I don't know if this has a function or is straightforward. I have used a simple multiplication of number of hours times rate per hour to calculate...

Please help! When working in Excel both headings in the column and row areas are numerical, making it difficult to do simple addition using the SUM feature. ...