Hello, I have been searching for two days on the internet and haven't found anyone attempting this so far. I would like to find a formula for this: Cell's...

Hi, I have 2 tables and i have to compare this 2 tables and find out what are the new thing added to the second table and what are the things missing...

Excel 2003 SP3 I want to check data before and after it has been migrated between 2 systems - and prove it has survived intact - using a checksum or...

I have two workbooks linked, and if I add a row to the data source, the cell that the receiving worksheet holds, looses that new row and everything shifts. ...

How to return with an "OK" if the value falls between -10 and 30

I am able to count the values followed by a comma in each cell within a given range: C7(3,6,23) E7(5,8-h,10) N7(12,13,23,25-H) The below formula will...

I have an Excel Bingo template which links vocabulary words on one worksheet to 36 Bingo cards and game cards. This was created using Paste Special and paste...

We are designing a quotation sheet. The data is derived from a table above on the same worksheet that has three columns: A - Catalog #, B - Manufacturing...

I have a spread sheet with 5000 lines. Column A has 1000 different part numbers (P/N) Column C has MTBF data for the 5000 line. Column D has “Actual” or...

My question is how due I sum all values in a column that have a numerical value, and exclude the data in the same column returned #N/A. For example the...

What does the symbol ^ mean when used in a formula like =1/(1+'3)WACC_WARR'!$G$13)^F52

Hello I am looking for the directions and code for visual basic language for imput boxes. Please help

Hi -- I'm trying to use MATCH to return the column # of the first non-blank cell in a row. It works great until I try to use a variable lookup...

I have a formula: =INDEX('Sign-Up Sheet'!B3:B124,MATCH(SMALL('Sign-Up Sheet'!F3:F124,1),'Sign-Up Sheet'!F3:F124,0)) B3:B124 are names in my list of...

I am creating an evaluation form with a 1-5 scale in each category. If you choose the button under the "1" rating column, the number "1" is added to another...

Is it possible to have rows at the top and bottom of the screen remain static and rows inbetween that scroll? -- Regards Tom G

Hi, I need to sort a large document by a certain column. That column consists of numbers that are six digits and five digits. I need to insert a leading zero...

I need to count the number of characters repeating within a cell. For example, assuming the following in range A1 through A4: eee ee aaaae af A count of...

using a profit management program and on my wooksheet "REF" has appeared how can i get rid of it

Is there a way to look up between multiple columns on the same worksheet. I have 297,000 serial numbers that I need to search through. I exceed the allowed...