Sorry, I posted this to new users as well. I have a worksheet containing sales data and hours worked for several employees for a period of one month. the...

Hi, All! I have such pivot table: Answer2 Quest1 Answer1 male female Do you have a hobby? Yes ...

Can Excel 2000 advanced filter be used to select rows in a list that do not match the comparison criteria? Or, otherwise, once advanced filter is employed and...

Hi, Sorry for the newbie question, but from my lurks the --() operator seems to be important and I can't figure out what it's supposed to do. Does it...

I have two formulas that work great by themselves This sums the product of all my trades on another worksheet that have the same...

I have entered this formula: =IF(B52000,"WARNING",IF(B52000,"OK")) I want the word "WARNING" to show up RED and BOLD-TYPED. Is there a way to do...

Let's say I have one tab with just my formulas and then 3 tabs of data which we'll call RED, BLUE, & GREEN. In cell A1 on my formula page I created a dropdown...

Hello Experts, When I paste the visible cells, all of my numbers are pasted as values. How do I paste visible cells and keep the formulas? Thanks in...

I want to have a formula that I can put into cell P4, Q4, and R4 that will sum the range "A4:D4" that contain the text "CE", "LS", and "LA". I have tried...

Can someone please help? On timesheet in Excel, there are 4 columns: Travel Time to site Arrival time at site Departure time from site Return Travel time If...

I need to sort 4 random numbers into numerical order. the numbers would be entered into a row for example, A1:A4. Now, I need to be able to check each of the...

hello, i click on help, enter "any words" and press enter and we just sit there watching the little serarching thingy run. tried setting nis 2005, tried...

Bonjour J'ai le problème suivant. En exécutant une fonction mathématique sur une cellule contenant un nombre, que ce soit directement "=5+6" ou "=5*6" ou...

i am trying to use and change a macro in one of excel 2000's templates. ( Expence statement) i want to use this macro in a differnt worksheet for a stock...

Hi, I have an excel spreadsheet and need to create average times in between a start time and finish time within a single column. For instance, if A1 contains...

assign numbers to sales invoice in exccel 2002 and move the invoice to a data base for reference. numbers assigned should start from number 1 to 999

I like the Change Case function in Word, especially the shortcut version, Shift+F3, but I cannot find any similar function in Excel. I found the "=UPPER", but...

I'm trying to build a rule in one cell that will look at 5 other cells' data, and populate a grade from 1-5, based on the value in the cells. The rule should...

I would like to produce a chart/graph (one worksheet on excel) which gives as much performance details (financial) as possible. This worksheet would be linked...