I need a function to search an entire column on another sheet (K:K) for a text string that returns the first cell reference (K34) that contains the string. ...

Please help - Macro to find "E4" value in column A. If found, copy found value from the A column and paste in cell A5. All info are in sheet named is...

My apologies if this is a duplicate post..... Maybe I should've done this to begin with, but here's my example From worksheet MAIN ALLEN,...

Hi there, I wonder if anyone can give me a good piece of advice in how to find a specific value in a table. For example I have the next table: A ...

I have a spreadsheet that has many cells linked to other cells on the same sheet From the links I want to know the row number of the reference. Eg: A1 value...

Hello everyone, I am a bit stuck on this problem and I don't know if this is possible to do in Excel 2007... I have multiple worksheets in a workbook. first...

I want to write an if statement that will allow me to pull information from several columns and give me one result at the bottom of my sheet. Example: IF...

Hi, is there any solution to extract the text written in a comment box to a specific cell I tried the following but this message “#name?� appeared ...

Hi, I have seen that you can use GETPIVOTDATA with more than one field on Excel 2003 and 2007. But is there any way of doing this with Excel 2000. I am...

Ok, my spreadsheet skills may be showing a little out of date here, but I am hoping an Excel-God can show me the light. I have an array consisting of column...

From a cell on my "Summary" worksheet, I need to find the last cell that has data in it in Column E on the "Account" worksheet and copy the data from that...

i need a formula that will do the following function: If A1 equals either D/S, Sunday, or Daily and write 16.84 for D/S, 8.48 for Sunday, 8.06 for Daily

I figured out how to add a calendar control to my excel spreadsheet. For example, when I click in cell B7, the calendar appears, I click on a November 11,...

Is there a way or formula in the excel that could help to add the nearest month to get the figure for Column F. The month added up can be greater than or...

Hello I am trying to put a list of data into a table. I would like to use a formula to do this as the list is updated on a regular basis. If the ‘data’...

Hi, I was trying to apply conditional format for A2. That is if the value of A2 repeats in either Column D or Column H or Column L, A2 should be highlighted.

Hello, I have a start days and a number (representing days for a given project). I want to calculate the end date and exclude weekends and certain...

How can i set up a formula or spreadsheet to calculate how many item have occurred in the last year based on today's date?

I have a regular spreadsheet with large number of data lines. I would like to identify new items that appear on the spreadsheet each time it is run but I...