I have a data AGR DEL AGR JAI AGX BLR AGX COK AJL CCU AJL GAU AJL IMF AMD BHO AMD BLR

An If statement in column AA asks whether entry in col B is = "L2" and gets a 'FALSE" result even though the entry in col B is "L12"? What am I doing...

I have to make a price change, it involves approx. 50 different cells. They will all increase by 9.25%. Is there a function or a formula that I can use to...

I have an email database that has duplicate entries and I need to know how to search them and delete duplicates. Then I need to merge 2 different...

How do I get the check mark to appear in the box I have placed on my spread sheet i.e for reply, urgent, for review

Hi i need to write a macro and have no idea how to do it if some one can show me form scratch Ihave different formalus in different column which calculate...

Hello All, I am try to do some coding to open to a certain tab in a different workbook. I am creating the sheet tab name that I need to open with concatenate...

I have a column of data (col1) with text entries like " California Metal Works, Inc." I have another (col2) with entries like "Metal extrusions." What I...

I've got 2 worksheets, one labelled Data File and one labelled Lookup. The Lookup sheet is to be maintained by colleagues, as and when they go out on a visit...

How do I tell excel to add a column of numbers without regard to +/- sign. I want to know the gross total of all adjustments, not the net. Here's the...

Vendo coche seat ibiza, 1999 . en buen estado, color plata, Precio ,4900 euros. Precio 4566 Euros. Tfno: 91452123334 Puedes ver mi anuncio gratis...

How can I run both versions on the same PC at the same time Paul

Hi all, Why does Text Wrap produce two results when a cell holds long text string: sometime a cell is expended vertically and sometime a cell height keep...

how to edit a excel template

I have this type of data to sort: C-1, C-2, C-3, C-4, C-5, C-6, all the way up to C-500, but it doesn't sort into number order. How can I make it sort by...

The advice you gave me on 18th April last results in the whole worksheet changing colour to blue and it stays like that after I make the necessary changes in...

I m a new user please detailed breaf for that

I have conditional formatting on some columns in my spreadsheet. I would like to put that same formatting on some rows. Is there a way to copy conditional...

where the template is stored