Hello, I am looking for a formula which looks for 2 specific text values which are there in sheet1, matches with the same text in sheet2 and displays the...

Hi, can nayone help please?(using excel 2003) I am using a table, part of which is shown below, which needs to show the % of correctness of predictions given...

Hi, I have a spreadsheet where I am working out the correctness of an expected result in % but have a problem with dividing 0 by 0. example from my...

Hello, I have an excel file with a large amount of data that i need to make accessible to a large number of users in the office. There are also a couple of...

excel version 2003 i have 4 cells that once one is select i dont want the user to be able to type in the others is there anyway to control this

I have Range of cells that all have drop downs with a list of names in them - these come from a named range n another sheet. Is there a way to filter this...

I have created an inventory excel setup whereas we have: Central server for storing data and each location saves the files to the same server There is my...

I am using the code below which runs whenever a cell is edited -I think. I would like to change this code so that it can be 'run' against a range of cells...

the column A1 has custom format 000-000 having the data like this 123-456 001-789 313-245 456-779 084-321 The column B1 has the following...

Each week a new date and amount is entered, and the sum for YTD is updated. I would like to copy only those columns that have a date entered and the YTD, to...

I have pasted data into Excel that has the latest date at the top of the column. How do I invert the data to get the earliest date at the top?

I applied the following formula to find the matching and write the data of the corresponding next cell. Sheet1. the column C:C has custom format 000-000...

Hello, I make a comparative analysis in order to decide which "method" to use to access data in office documents from .net application. Data should be both,...

Somehow the "View" option in Excel went missing. Now there's a thin white line where the word use to be. So the it reads: File Edit (white bar) ...

Hi, in Excel 2002 I'm able to create a customized button to execute a macro that is saved in another workbook and another path (a server for exemple), so...

i have a large database with many of the email address' doubled or tripled, how can i easily filter all the doubles out?

I have sheet1 and sheet2 both sheets have same data but there are some new material # in sheet1. Problem is when apply Vlookup formula in sheet2 then...

trying to deploy a vb.net dll to clients; on some machines the following run-time error occurs: Unable to case COM object of type...

my column references are displayed in numeric rather than alphabetic. eg. the first column is 1, instead of A. Can anyway help me? thanks Kaz

Hi! how can i make this formula to return the leftmost number only? this is an array formula =INDEX(A6:AA6,,MIN(IF(A6:AA6"",COLUMN(A6:AA6)))) Thanks!