I have a sheet with many rows and i need to filter out old versions of the row in questions, example Mr Smith blah blah aaa bbbb cccc 1 Mr Smith ...

I have several columns of information (i.e addresses) and one of the columns has duplicate numbers. I want to remove the duplicates rows and retain the...

I am looking for a template where I can keep track of my rental properties income and expenses. I have 7 apts total. Six apts in one building in one city and...

Can anyone assist me in summing columns that have alphanumeric data, where the data ends with m2? Thanks.

For example: For sheet 2, Cell C 5, and C7 already got data as 1015 and $30 respectively when I'm in sheet 1, at cell G 5, if I link "Sheet 2 C 5" to this...

I created a drop-down menu in an excel spreadsheet, but when I attach the spreadsheet to an e-mail and send to a recipient, the drop-down menus dissappear in...

Ive created a form in Excel 2000 that uses text boxes and im attempting to enable tabbing form box to box. Help!!

how do I add cells within a cell that is used as a function

4k 16bit 4k 16bit 4k 10bit 4k 16bit HD...

What function formulation is required to round up calculated dollar amounts in half dollar increments?

Hi: I have a worksheet with these columns: D = first name E= last name F = sandwich order G= date There are many duplicate D and E entries: that person may...

I am pasting two columns into Excel...the first is supposed to be a date and is in format YYYYMMDD, the second a simple integer...here's an example: Date,...

Is there a function or code to enter 'carriage returns' in a text string? I am using concatenate functions to extract and combine text and field names from...

Hi, I need a formula or a mathematic help. Basicaly i have 6 cells. I need to tell it to be 0.1 when 1 cell if filled in 0.2 when 2 cells are filled in 0.3...

Thanks for reading this :D ive made, and been using a cricket score sheet for some time now on excel. for those who dont know all i do is write down names of...

I have a long list of data, from which I need to calculate the Maximum, Minimum and Average values for each seperate year. The data spans many years. An...

I have two worksheets of data. The 1st (Fuel) contains the following headings: Date | Econ | Dist | Cost per | Total $ The 2nd (Service) contains: Date |...

There are many threads on this Forum dealing with merging tables, worksheets, and workbooks, but I cannot locate one that suits the problem I am trying to...

I am trying to do a VLookup from one worksheet to another. When I Filter the source worksheet and use the Vlookup function it reads both the filtered and...

I have an Excel spreadsheet of names, addresses, etc. that I need to use in a mail merge to create labels. Several of the columns contain data with trailing...