|
Count Multiples in Column
Hello-
I have a very large file. In column "G" are company names sorted alpha. But
they can be repeated row after row.
I need to know which companies are listed 3 or more times.
Adam
Adam
Bob
Bob
Bob
Charlie
Doug
Doug
Doug
Doug
So, do I put a count in a new column "H"?
Adam 2
Adam 2
Bob 3
Bob 3
Bob 3
Charlie 1
Then I need a report show if count is...
|
12 |
27.09.2006 20:56:27 |
|
|
Vat formulas
I would like to be able to set up a template for my vat returns each month,
using the correct formulas for total, standard and vat. Can you please help...
|
4 |
27.09.2006 16:05:57 |
|
|
Summation of a filtered column
Hi, I've been using SUBTOTAL(9, C3:C396) to sum a column. This works when I
filter the column - it sums only the rows that are displayed. However, it
doesn't allow me to easily add more rows as I have to keep changing the
range in each column that uses SUBTOTAL (there are 12). Is there a statement
that will allow me to sum the columns of only the number of rows that are
displayed after m...
|
4 |
27.09.2006 15:54:19 |
|
|
How do you arrange text alphabetically in a column?
Well I have this list of names in a excel sheet, and I want to arrange them
alphabetically. Is it possible? If so how??...
|
2 |
27.09.2006 15:20:31 |
|
|
"Tab" range
How do I change the Tab range from "next page" to "next cel"l? Just started
new job and format is set to go to next page instead of next cell and cannot
find "how" to change in HELP....
|
2 |
27.09.2006 14:31:02 |
|
|
New to office 2003
Is there a way to get rid of the orange color when working in excel.
The orange shows up to indicate what Column and row you are in... but it is
very annoying......
|
3 |
27.09.2006 13:51:02 |
|
|
Capturing Date
I have tried writing a macro that would let me capture the date from my
computer and place it in cell D2. The captured day will be moved intact at
the end of the day
Is there a command that will let me do that?
Thanks for the help in advance.
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/excel-new/200609/1
...
|
5 |
27.09.2006 12:40:50 |
|
|
What is the best work sheet used to calculate monthly expenses?
I would like to compare salary against monthly expenses and would like to
know if there is such a template available....
|
2 |
26.09.2006 22:13:01 |
|
|
More than one line in a single cell?
How do I enter multiple lines in a single cell in a column? I need more than
one line of information to fit it all in a cell of a row in a column. Please
help....
|
2 |
26.09.2006 17:47:02 |
|
|
Macro Help
' Macro1 Macro
This macro works except I need to be able to find a blank cell in column C.
The first time I run the Macro it works. The second time it copies over the
first entry not the cell below it. I am not sure how to change "Range(c9).
select"
Please see macro below
Thanks for the help
' Macro recorded 9/25/2006 by
'
' Keyboard Shortcut: Ctrl+a
'
Range("C1:G1").Select
...
|
8 |
26.09.2006 17:08:57 |
|
|
combo box and access
i want to know about the combo box. how it used.what its uses.
can anybody suggest me from where i can get the information about combo box.
is there any special website of combo box.
and also about access.
iam the new user of excel
so pls help
regards
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/excel-new/200609/1
...
|
2 |
26.09.2006 15:04:03 |
|
|
data entry
I am trying to write a macro that will copy data from, lets say cell c3 and
paste it to cell c6. Each day I will be adding new data to cell c3 and
coping to the next blank cell c7, c8, c9, c10 etc.
The macro is more complicated than this and I can do everything I need to
except to add the data to the next blank cell.
Thanks for the help
...
|
7 |
26.09.2006 13:06:01 |
|
|
Deleting Duplicate Numbers In A Column: How ?
Hello,
Have a long list of numbers, formatted the same, in a column.
Would like to delete duplicate numbers.
How can I do this, please ?
Thanks,
Bob
...
|
2 |
26.09.2006 12:15:51 |
|
|
Excel User Conference in October...
There's a wonderful conference for Excel Users. Led by Excel MVP's and Excel
gurus. Find out details at
http://www.exceluserconference.com and sign up! This is the 4th time it's
been done - Fort Worth, Atlantic City, London, and now Marina Del Rey,
California.
Come one, come all!
...
|
4 |
26.09.2006 11:42:02 |
|
|
combobox into another combobox
i got 2 combo boxes in a worksheet. i want to link the 2 combo boxes
together. combo2 will depend on which is selected to the combo1.
eg:
combo1 - accessories, card, ram
list in combo2 will vary on the item selected from the combo1.
let say:
combo1 - accessories have been selected
combo2 - slot fan, usb to ps2 convertor.
can someone helps me!!!
thxns in advance
...
|
2 |
26.09.2006 09:31:17 |
|
|
reset a combobox
hi
i'm kinda new on excel.
i want to create a button command linked to combobox; so that when i
click on the button, it reset the combobox to nil.
thxns in advance
Girlie
...
|
2 |
26.09.2006 09:02:55 |
|
|
How do I get the same contacts to show up on all of my computers.
In our office we have five computers that all have the same program, however
when a new contact is entered some contacts you can access it from all the
computers and some you can't, how can I make so that all of the information
shows up on all of the computers?...
|
3 |
26.09.2006 06:41:01 |
|
|
contact page to be the first page I see when I open outlook
How can I get my main contact page to be the first page I see when outlooked
is opened?
Thanks...
|
2 |
26.09.2006 06:39:02 |
|
|
Find a specific posting
How do I find a posting that I posted so I can see the replies...
|
17 |
26.09.2006 00:54:02 |
|
|
How do I add up a column of figures? on excell spreadsheet
I am doing my accounts in an excell spreadshee and want to add the coloumn of
figures where my income is. How do I do it. Normally I would go to formula
and just say add, but it does not work the smae on my home computer. Thank
you. Dxx...
|
2 |
25.09.2006 23:05:25 |
|
|
printing formula version and values togheter
How can I print formulas and values togheter froma excel worksheet?...
|
3 |
25.09.2006 21:01:36 |
|
|
contact page to be the first page I see when I open outlook
How can I get my main contact page to be the first page I see when outlooked
is opened?
Thanks...
|
3 |
25.09.2006 20:55:07 |
|
|
"Control" plus "click" doesn't allow me to select multiple cells
In excel (and a number of other applications) holding down control and
clicking with the mouse doesn't let me select multiple cells, photos, files
etc.I think I may have fiddled with the keyboard settings somehow but how do
I put it all right? I don,t appear to have a CD with my keyboard so I can't
just re-plug and play....
|
1 |
25.09.2006 15:46:02 |
|
|
adding money amounts in excel
I am using a formula to calculate 10% of an amount which is rounded off to 2
decimal places. The amount is $1,952.48 and it is rounded off to $195.25
which is what I want it to do. The problem I am encountering is when I click
on the cell the actual value of the number is 195.248. When I add 10 amounts
of the value 195.25 it is calculated to be 1952.48, which is not correct.
The cor...
|
2 |
25.09.2006 14:52:25 |
|
|
How do I resize a complex Excel template?
I bought a template to make a calendar, the template is wonderful but doesn't
fill a full 8.5X11 sheet of paper, I've tried adjusting the margins, fiddling
with the print at %, and everything else I can think of. Is there anyway to
enlarge the calendar without resizing every cell?...
|
1 |
25.09.2006 14:39:01 |