Dear all, Suppose i have a workbook containing a worksheet, whose cells r linked to another a worksheet in another workbook. now the problem is, i want...

Thanks so much to all of you who take time to help us out! You have no idea how much we appreciate it! I have two different sets of data. One is a complete...

I am missing probably a simple step in creating a macro for a worksheet. The problem seem to be when I "carry out the actions I want to record." Objective:...

Although the two columns I am comparing in my VLOOKUP look exactly the same (for example, both say MMM 001), they came from different sources and so must look...

Hello from Steved I have an index in Columns which has a Label the cell below has a Label and below that a Constant. The index is C4:AT125 In A1 and A2 I type...

I do hope somebody can help me! I've used Excel 2002 since it was released, and have never met this problem before. Basically, I have a very simple...

I am trying to import a text file that is larger than the number of rows in a worksheet. Excel imports the data into the first column only, then gives me a...

I'm trying to import info. from an Access table into an excell spreadsheet and when I try to finish the Query Wizard and error message comes up saying 'Syntax...

my excel sheet is a huge one and I have a column that has a disply of the hyperlink of all the cells I mean any cell linked with a path by hyperlink to the...

Even though we have Office set to Canadian $ currency - when we go to format cells - we get English pound sign currency. We can change the cells to $, but...

Hi All, Is there an option available in the analysis toolpak to do 2-Way ANOVA with replication (with unequal number of replicates in each group). I am using...

I am getting a value by using a vlookup. what do I need to do to get the address of the cell that I found with vlookup? thanks

How do I set a formula to convert feet and inches to inches? Ex. 10'9.25" to 129.25"

Hello from Steved How would one go about writing a formula to search for 2.0 (Which is distance)I have over 1,000 places in my worksheet. below is one sample...

What does the function or symbol ^ mean?

You can do a sum over sheets the same way you do a sum on=20 one sheet. On your New Sheet =3DJanuary!A2+February!A2... etc, where A2 is the cell with=20 the...

I have a spreadsheet with a number of columns (Product, Stage, Campaign, Batch, Page, Operation, Operator, Detail and Category). The spreadsheet is used to...

I'm having problems retrieving stock quotes. I'm following the directions (typing symbol in cell in all caps, then clicking outside the cell), but only...

Does anyone know if there is a formula for displaying the current time? I know =TODAY() exists for displaying the date and also =NOW() for displaying both the...

I was trying to use COUNTIF to see if a value in a cell was also in a range of cells, but the range is non-contiguous. For good reason, the range is sorted in...