filter columns

I have several cells with only one phone number. How can I filter those which have more than one cell phone? For example, I want to find cells like this: MCCLANAHA Juan `RR I Box 1488 Alton 778-6076; Mcdonald S `1820 N Main St 417-926-4747 The amount of numbers in the phone number...

I have searched thoroughly the forums on how to keep only columns whose header is the text "x","y" or "c".. and saw a common formula pasted below: Option Explicit Option Compare Text Public Sub DeleteColumns() Dim iLastCol As Long Dim iPtr As Long iLastCol = Cells(1...

Hi, Please see the attached spreadsheet image. Column B to I has one row per record, Column J onward each record has additional data in the additional rows. For example if you see in attach image, a record in row3 (John, Hernandez), the record is associated with row 3 to row11 but Column...

Hi there, I have exported a report to Excel from a BI tool called ZAP. Unfortunately the cells in the columns are merged by group eg. salesperson, product, country. I need to be able to filter by each of the columns - the only way i can think of is to unmerge and copy the information to...

Hi there, I have exported a report to Excel from a BI tool called ZAP. Unfortunately the cells in the columns are merged by group eg. salesperson, product, country. I need to be able to filter by each of the columns - the only way i can think of is to unmerge and copy the information to...

2 column ranges column AA=PayDate range column AB=Wages range What I have done is list all my bi-weekly pay dates for the next 3 years in column AA. The range is named 'PayDate'. I listed my net pay in column AB and this range is called 'Wages'. I want to create a budget based on the number...

I have a filtered column and would like for it to match a report filter on a pivot table. Is there a way to do this? Right now I have to go in manually and uncheck the ones to make it match the filtered list in column B. Thanks.

Normally when I select a row (typically column headings) and then turn on Auto Filter, only the columns with data show the Filter drop down symbol. However, when working on pre-existing worksheets, the filter symbols appear way out to the right...like columns DZ, CA, etc. even there is no data...

Basically, I am trying to use Excel as a contact data base. I have all the typical columns (ie. Name, Address, Phone, etc), but I also have a "Category" Column. I would like to be able to filter this column and my problem is, sometimes the cells in this column have more than one value. For...

Hi, This is my first post here (though I have read the forums for resolving my earlier doubts). As a sample, I have attached screenshots of the 2 sheets of data. I am trying to find maximum value of Profits in each year 2008, 2009 & 2010 (Columns B, C & D) for each unique item (Column A)...

Hi all, I'm trying to create a filter macro that will select a specific column from a given worksheet and filter on a given variable. I'm also trying to do the same thing with an OR operator. Ex: I need to filter: equals THIS OR equals THAT. I want to try and keep them general so that I...

i make excel spreadsheets from .csv files that are generated by brdata. 70% of the columns of information i don't need and have to manually delete each time. i haven't found a way in brdata to not give me these fields, so i'm asking for the easiest way to delete specific columns of info before...