I have a data validation dropdown list box in "sheet1" cell $J$1. Depending on what I have selected in that dropdown list I would like it to match or lookup...

I need assistance creating a formula to extract the supplier name associated with the lowest supplier bid. A sample of the data looks like this. I need to...

Trying to count the times "YES" occurs in column C3:C5 for each time "Bill" indicated in column B3:B5? -- Thanks - liz

How do I get the data labels to stay where I put them in pie charts. I have a series of pie charts set up and update the data they are based on monthly. I...

I select the text of a cell name (A1, for example), hit F4, an nothing happens. I have to go in and type my $. How do I reset F4 to work?

I input my formula, but would like to fill in the data later. How do I save the Formula without there being data. I am trying to create time sheet that will...

I am trying to fill in an amortization years column. The first 12 rows are "1", the next 12 rows are "2", the next twelve rows are "3" and so on. I've got...

I have a spreadsheet which across the top has the months Jan to Dec and Total. Under each month is 4 categories Days/oil/gas and would like to simplify a...

i have 12 columns with data on days and each new day i want to add a new day to the set of 12 columns without adding a 13th one. So the oldest day are...

I have a s/s that has the months of the year across the top and below 3 categories for each month and I want a weighted avg for each product. eg: A B ...

Hi, see table below. Col A Col B Col C a 1 7 s 4 9 x 8 4 d 9 3

I want to find the percent for each column. Which tab do I click to get the drop down choice for percent. I found it once and forgot to remember it. I...

I have a spread sheet and in it i have data validation tables when i finish picking from them and email the sheet i then want to clear the info in the tables...

How to remove error notification when X7/M7=0 when one or both cell values are 0

Can someone show me how to accomplish the following by using the LARGE function "WITHOUT" using an array ? I'm trying to rank each product (most, second most,...

I have a survival dataset (see below). I want to fit to Weibull function S(t)=EXP(-alpha*Time^gamma). If I use Excel Solver, alpha=0.00367 and gamma=2.32. If...

I have information in column A of a task sheet. The information goes from row 1 thru 35. Column B is where I place a "x" to say the task need to be completed....

I was so impressed with the wonderful responses and spot on answers to my first question on this site I thought I would give this one a try. I did try to...

If a date is a friday, I want to display the previous Thursday (MM/DD/YYYY). If a date is a Saturday - Thursday, I want to display the Thursday as a date...

I have excel 2000. I am trying to get this formula to work. It does not give me any errors or anything It just will not return the number in the cell that it...