Free Microsoft Excel 2013 Quick Reference

How do I clean a .csv mailing list file against a .txt file?

I have a mailing list in .csv and I need to remove the entire entry if the email address is in a .txt file.

I can't figure out how to do that function.

I'm using MS Office 2000.

If anyone could help me, I would greatly appreciate it!

RedRhino


Post your answer or comment

comments powered by Disqus
How do I create a drop down list in Excel 2003. I've tried to use the help
menu and I cannot figure it out.

I have a mailing list in .csv and I need to remove the entire entry if the email address is in a .txt file.

I can't figure out how to do that function.

If anyone could help me, I would greatly appreciate it!

RedRhino

I have seen worksheets that have an arrow where you click and you can select portions of the list. Example the worksheet has east, west, north and south information, but I only need to see north. How do I add a drop down list so I can choose the location to show up?

I have a budget file that contains 8 spreadsheets and charts how do I make a
copy of the file, rename and update?

I have created a drop down list for the first cell in the column using the
data, validation method but I want the list for each cell in the column. How
do I do this without having to go to each cell to create the list?

Hi

I need to make a sheet which has activities and sub activities. Each
activity has 4-5 sub activities.

I want to find how do i use the if or the vlookup function so that once user
selects a particular activity in a from a drop down list in a cell the
corresponding column will automatically show a another drop down list for the
sub activities related to the chosen main activity.

I have a worksheet with named lists. I have a second worksheet that has
validation references (=listname) to those lists to create dropdown lists.
This is working fine. I have now distributed this spreadsheet to multiple
users.

I want to now update one or more lists in my master file and re-distribute
the list worksheet and give the users a method to replace the lists worksheet
in their local copy.

What is happening is that when I copy the updated list to the local
worksheet, and delete the original list worksheet, the second worksheet no
longer sees the named lists. The same thing happens if I first delete the
list worksheet and then copy the new list worksheet. The lists are still
correctly visable in the lists worksheet.

How do I get the second worksheet to see the named lists again?

How do I add a dropdown list in a spreadsheet? for the user to select from

....what i mean is, how do i prevent a user from just leaving the cell
empty.

i have a list of countries in column A, and in column B i have created
a data validation list (of prices). but users can simply leave column
B empty if they wish to - how do i force them to 'pick' from the list?
hope this makes sense. thanks

column a column b (drop down list to choose from)
belgium
denmark
uk
etc

how do i link a list of items in a workbook to worksheets in the same
workbook and also link the format? I able to accopmplish each individually
but not both.

How Do I create a list in my form. Where when I click on a cell in the form a list is displayed for me to pick from that will fill the cell?

Can this list be on a seperate work sheet?

I have a File that I down Load from another system (AS400) which I converted
to CSV Format. Some of the Alphanumeric fields (cells) have legimitate
values that start with 0 (zeros).
When I open the file in EXCEL it strips the leading zeros from those fields.
How do I prevent that.?

I tried using " as a delimiter but it did not work.

I have a csv file seperated by a ; in a notepad. one line has 10 bits of data, there are upto 40 lines or records. I want to import the data to excel, when I use the Data/Import wizard, it places each record within the notepad to one column, how do I get it to split the data within each of the ; into a seperate column, using one row for each record.

Lorraine

How do I get a calendar pull down list in Excel?

im working from a Shelly Cashman text book and one of the steps asks me to
define a range as a list. my problem is, there is no list option in my data
menu. How do i get to the create list option when there is no list option?

How do I sort a list of cities in US by randomize in MS Excel or Access?
Thanks
Tam

I have a current customer list in Excel 2010. I have other lists I want to mail or e-mail to but do not want to include those already on my customer list. Eliminating duplicates does not work. I want to eliminate the names in other lists that are already on my customer list. Lists are too big to do by sorting and deleting.

I had a formula once - but can't find it - it was something like -

=IF(OR(TRIM(A1)=TRIM(A2),TRIM(A2)=TRIM(A3),**,TRIM(A2))

But this doesn't work.

How do I create a list of names and addresses?

I have a list of Data:

DATA
a
b
b
c
c

How do I create a chart from this data to show:
a 20%
b 40%
C 40%

Do I have to perform separate calculations, or is there a way this will just
work?
Thanks,
Jim

Hi

I need to make a sheet which has activities and sub activities. Each
activity has 4-5 sub activities.

I want to find how do i use the if or the vlookup function so that once user
selects a particular activity in a from a drop down list in a cell the
corresponding column will automatically show a another drop down list for the
sub activities related to the chosen main activity.

I have a spreadsheet where I want two command buttons: one that says "Print" and one that says "E-mail". I have the code that will make these actions possible. I just need to know how do I link the code with the command buttons. Example, if I hit the print command button, the macro for printing will run. Also, how do I create a command button?

Please Help!
Thanks!

I've messed around with right click and "Create List" but just can't seem to get it right.

I have a column labled "instrument" at the top. In that column, I'd like a drop down list for every row. The drop down list contains 4 items:

Euro
GBP
JPY
CHF
How do I go about making this list as it's just not happening for me at the moment?

Thanks

I am creating an excel file for employees to enter their time. I want to have a formula set up that will automatically total the number of hours spent on specific project categories. For example, cell C6 is a drop down list having multiple categories to choose from. Cell D6 is the total number of hours spent on that project. Cell C7 is a drop down list and D7 is the total number of hours, etc... How do I create a formula that will total only the total number of hours for a specific category selected in the drop down list?

For Example:
Totals hours spent on administration: =D7 if C7 = administration

I don't know if this is possible, but I hope so! If I'm confusing, I apologize because I'm not well versed in computer terminology.

Thanks,

When I record a macro to sort the contents of a sheet it seems to have a lot of extraneous code and uses .select which I've heard time and again is unnecessary.

The recorded code is as follows. How do I clean this up to simplify it?

Code:
    Sheets("agg").Select
    Cells.Select
    Selection.Sort Key1:=Range("B2"), Order1:=xlAscending, Header:=xlYes, _
        OrderCustom:=6, MatchCase:=False, Orientation:=xlTopToBottom, _
        DataOption1:=xlSortNormal



No luck finding an answer? You could always try Google.