ColumnA Column B ColumnC ColumnD $2,958.73 Kelly RSP 5-Feb-07 $91,000.00 Sherri Non-Reg 12-Feb-07 $15,648.47...

Hi, I have a list something like this: A B P-no. Week 336 2 421 2 421 3 643 3 643 3

I used to routinely use the concatenate formula in excel, with either syntax: =CONCATENATE(A1,B1,C1) -OR- =A1&B1&C1 Lately, sporadically, it just...

I have 2 workbooks open and want to lookup data from one and display it in the other. The workbook with the data in contains the customer name in column A...

Hi, I have a series of dates and time in each row. I want to create a formula that will only take the dates. ex: before ...

I'm trying to create and If/then statement from the following table: I have a drop down list with the values on x I have a drop down list with the values on...

for a drawing: for every three X, 1 ticket is received. How do I set up a formula to recognize increments

Hi All My client just sent me this weird report to consolidate. It has four tabs for four diferrent months. which have some data like this. A ...

I have plotted out a worksheet, but the problem is that it is trying to calculate empty cells as having a value of zero. This means that whenever it is a...

I tried to use all the formulas in the response,but could not get them to work. This is the formula I used, ...

I want to click a button and have 5 different cells return 5 numbers between 1 and 6 i want each cell to pick number randomly it does not matter if some...

I'm trying to create and If/then statement from the following table: I have a drop down list with the values on x I have a drop down list with the values on...

I have a table with names going down the column, and then numbers in the 7 columns to the side. Below that, I created another column of all the possible...

I have a column used to insert dates for a certain activity. Is is possible for me to restrict someone from entering a date that falls on a specific day of...

I had a column of about 41,000 values. I needed to extract any set of consecutive integers into separate cells. There could be any number of letters or...

My co-worker sorted the "client #" column, without sorting the rest of the worksheet; then freaked and saved it. Without having to re-enter all of our...

Hi, I am trying to set up a validation sourced to another worksheet. Also, how do I set up a filter to sort only on select options? Thanks, Julie Harvell

I have a column of names that get's updated daily. I would like to keep a tab on unique names in the list on a daily basis. So if I look at the weekly...

I know how to use option buttons and group the option buttons in a group box. I have a worksheet in which I the option button groups are separated from each...

I have uploaded to the freely downloadable file at http://home.pacbell.net/beban some additiional procedures for handling 3-D arrays, including a function to...