|
|
Find duplicates in a column by
rock
Hi,
I have 6000 emails addresses in a col and wish to know if there are any
duplicates.
How can I do this please.
I have Excel 2002.
rock
|
|
1 |
150 |
|
|
Add column to file with numbers by
rock
Hi,
I am manipulating data from one db to another and have found that I need
to have the ID numbers 1 to 6000 in the left side 1st column.
How do I get...
|
August 21st, 2009 03:34 AM
by rock
|
4 |
150 |
|
|
|
|
14 |
330 |
|
|
Macros by
Davo1
How do I get a mcro to run at a certain time during the day?
|
|
2 |
199 |
|
|
Add a space in data by
israel
Hi,
Is there a formula that would add a space between two characters?
I have "12:13:09", I would like to add a space before the first colon. (12
:13:09)
--...
|
August 20th, 2009 09:40 PM
by israel
|
5 |
197 |
|
|
HLOOKUP: specify table array in a cell by
Melanie
I am looking to specify the range of cells for the table_array in a cell.
For example:
=HLOOKUP("ABC", A1, 5, 0)
where A1 would contain the info on my range...
|
|
3 |
343 |
|
|
What Should I do in this situation by
Dave
hi,
I am on Excel 2003, I have spreadsheet with a range of cell that
contain cell refrences to other cell in the same spreadsheet. Once I
protect this sheet...
|
August 20th, 2009 06:07 PM
by Dave
|
5 |
170 |
|
|
|
August 20th, 2009 05:07 PM
by Eduardo
|
1 |
152 |
|
|
Lookup by
Tarig
Hi,
I have customer master codes in sheet 1, and customer codes and sales value
in sheet 2. I want to update sheet 1 with sales amounts from sheet 2, my...
|
August 20th, 2009 01:05 PM
by Eduardo
|
1 |
126 |
|
|
Online Training by
Agbaje Olufemi
i'm a beginner and i would really love to get some thorough training in
excel
i would be glad if soeone could guide me through in getting an online
training...
|
|
1 |
227 |
|
|
Time Formula by
John Calder
Hi
I run Excel 2K
I download data from a mainframe. This data has a date & time format in it
(dd/mm/yyyy hh:mm:ss)
I work in a place that has a 3 shift...
( 1 2)
|
|
11 |
214 |
|
|
How can I get rid of these colons by
rock
Hi,
Here is one entry row of 7000 I have imported from a text database which
I will want to eventually export as a csv file for another database.
You will...
|
August 20th, 2009 03:33 AM
by rock
|
2 |
163 |
|
|
|
August 20th, 2009 03:18 AM
by roshan
|
0 |
127 |
|
|
|
August 19th, 2009 09:23 PM
by lunastu
|
3 |
144 |
|
|
Formula by
MissM07
How do I enter a formula to calculate a 7% sales tax?
|
August 19th, 2009 08:09 PM
by Eduardo
|
2 |
176 |
|
|
filling a column by
Mary M.
I'm not an experienced excel user. I'm trying to fill a column with times
beginning with 8:45 AM through 3:00 PM. This is painful. I can fill but the...
|
|
6 |
163 |
|
|
|
|
1 |
122 |
|
|
Time Format Problem by
John Calder
Hi
I run Excel 2K
I have a column of dates that are downloaded from a mainframe. The date
format of these are 18/08/2009 7:58:00 AM.
I am trying to...
|
|
3 |
139 |
|
|
vLookup but choose either of 2 columns by
Hugh self taught[_2_]
Hi All,
I have a scenario where I want to lookup a value in column A but would like
to choose either column 4 or 5 from the resultant row in a drop down...
|
|
3 |
157 |
|
|
Time to Number Conversion by
John Calder
Hi
I run Excel 2K
I download data from a mainframe.
One of the entries that is download is a value that represents minutes (or
hours) that reflect the...
|
|
2 |
111 |