|
Conditional Formatting
Alright folks I have been breaking my head with this problem and here
you go. I have a sheet which has about 250000 records. There is one
column which will be the base of this question.
Home Country
Albania
<blank>
<blank>
Australia
<blank>
<blank>
<blank>
<blank>
<blank>
<blank>
Austria
<blank>
<blank>
<blank>
&...
|
7 |
12/7/2008 4:53:40 PM |
|
|
Creating a csv
I have a spreadsheet with a list of email addresses in the first column. I
want to create a CSV file. If I choose Save as---> csv and then open the csv
file in Notepad the list is saved as a list with carriage returns after each
email address and no commas. So how do i turn the list into a continuous list
with no breaks and a comma seperating each one? I'm using Excel 2007
Thanks
Tony...
|
5 |
12/7/2008 3:15:00 PM |
|
|
Sorting automatically to different tabs.
Hi
Every monday i do the following drill.
Export from "application that sucks" to Excel to be able to sort.
Mark all posts that are "cancled" or "denied" with red (one colum).
Mark all posts that are not "implement" with yellow (another colum).
Make a tab called delete (a third colum).
Copy all rows that has a colum with "delete" to the tab called delete
(a fourth colum).
I guess thi...
|
4 |
12/7/2008 1:15:20 PM |
|
|
Search Multiple Workbooks Possible?
Hi,
Right now in my company, oddly enough, we have lots of workbooks with only
one worksheet in it (I know, know, . . not particularly the best way to go
about it. But since I have to work with these files, other than merging the
worksheets into one workbook, is there another way where I can search
multiple workbooks all one once?
Thanks
...
|
4 |
12/7/2008 9:16:16 AM |
|
|
Adding totals of cells depending on contents of another cell
Hi All,
I am working on a Excel 2007 workbook which tracks sales made by our
company. We have two columns 'Total Agent Commission' and 'Total Company
Profit' then another column with 'Order Status' there are three status's
used "D, F & C".
What I need to do is calculate the total of the Agent Commissions and
Company Profit based on the status of the order, i.e. I need to know the
t...
|
3 |
12/6/2008 10:10:43 PM |
|
|
Unable to activate Trace Precedents or Dependents in Excel 2003
I have an Excel 2003 file and Formula Auditing is activated on the
Menu bar. But on the Formula Auditing menu the Trace functions do not
"activate" or light "light up" when I I have my cursor on a cell with
a formula. Thus, no Trace lines appear. I activated Circular
Reference in menus as well and the same thing happens, i.e., the
Tracer lines will not activate on the menu (the buttons do ...
|
6 |
12/6/2008 7:44:39 PM |
|
|
Merging data from different workbooks
A list of excel files with complete path is entered into column A of
the workbook. Is it possible to open those files and paste the visible
rows into new excel workbook. There are more than 50 files to be
opened and pasted. One thing need to be sure while pasting, that when
second file is opened and pasted, numbers are pasted at the last row
of new excel workbook created.
Thanks in advance...
|
2 |
12/6/2008 6:51:41 PM |
|
|
Lookup in a 2 dimensional table
I want to look up a value in a table. I would like to specify a value which
determines which column to look in and a value that determines which row and
then return the value in that row and column.
For example, I have this table (not a real table) that shows the
friction/pressure loss in a pipe depending on its size and flow in
gallons/minute (GPM). Given a pipe size and a flow i...
|
2 |
12/6/2008 6:16:43 PM |
|
|
Rounding
Is there a way to round to the nearest 5%. For example if I have a result
of a formula equal to 84% I want to have it rounded up to 85%, and if the
result is 87% I want it rounded up to 90%. Is there a formula to do this?
Thanks for any help!
...
|
5 |
12/6/2008 5:06:16 PM |
|
|
Database functions to find unique entries on a date.
Hi All
I have some data as shown below in an Excel worksheet. Date and name -
each in seperate columns:
Date Name
1/1/8 Chris
1/1/8 Sam
1/1/8 Chris
1/1/8 Dave
1/1/8 Chris
I am using database functions (i.e DCOUNTA etc) to analyse this data.
However I cannot work out how to calculate the number of unique names
on a date.
That is, from the above data the answer I want for...
|
3 |
12/6/2008 2:51:51 PM |
|
|
Cell text not displaying (Excel 2003)
I'm having a problem with Excel. Some cell text is not being displayed.
However, the text does display in the formula box if you select one of the
"bad" cells. The
files that do this are on a network share and work fine on my other
computer. I've uninstalled and re-installed Office and the problem won't
go away. I also tried copying the files over to the computer in question and
...
|
6 |
12/6/2008 1:05:55 PM |
|
|
Circular Reference
One of my works book keeps telling me there is a circular ref
somewhere. I used this:
Sub FindCirRef()
Dim RefCell As Range
Dim Counter As Long
For Counter = 1 To 4
Set RefCell = Worksheets("Sheet1").CircularReference
RefCell.Copy
Worksheets("Sheet2").Cells(Counter, 1).PasteSpecial
Paste:=xlPasteFormulas
Worksheets("Sheet2").Cells(Counter, 2).Value = CStr(RefCell.Addre...
|
2 |
12/6/2008 6:45:01 AM |
|
|
Excel 2007: question on macro and XLSStart
Hi everybody,
I have created a macro (thanks to the help I got from this NG) and I would
like it to be available in every worksheet I open. Right now, it is only
available in the particular worksheet that was open when I created it.
How can I do this?
I found this folder named XLSStart. I was wondering if It could be a good
idea to create again my macro in a specific worksheet (that...
|
3 |
12/6/2008 5:45:13 AM |
|
|
Pivot Page field filter based on cell value
Hi, I am new in VBA and I have created a code that gets information
from an access query and set up a pivot table. The worksheet contains
multiple pivottables. All pivot tables have at least one page field
(product). The worksheet should be copied and then every pivot on the
active sheet should be filtered on one product (example: worksheet for
milk, worksheet for cheese, worksheet for etc). ...
|
4 |
12/6/2008 3:12:00 AM |
|
|
Pivot Table - External Data with Parameters
Dear All
I built a pivot table by getting the data from an external datasource. It
works fin all the time but now I want to add a parameter to the source so
that everytime when I placed the parameter and click refresh. The pivot
table will give the result according to the parameter.
Do you have any idea on it?
Thank you very much!!
Regards,
...
|
2 |
12/6/2008 2:58:04 AM |
|
|
change color in graphs?
I have a graph with a combo box form control, so that the data it
plots changes according to the data set I choose in the combo box. Is
it possible to also change the color of the plot lines according to
what the combo box choice is?
Thanks....
|
2 |
12/6/2008 2:53:00 AM |
|
|
Re: Characters selected within a cell
Hi All,
Is there a way to count the number of characters selected within a
cell using VBA?
Thanks,
Sundar...
|
4 |
12/6/2008 2:48:10 AM |
|
|
Excel 2003 - VBA - Closing workbooks without error
Hi guys:
WorkBook "A" - The primary workbook I am working with.
WorkBook "B".Sheet "B" - the worksheet that has data I need on a worksheet
in workbook "A"
Workbook "A" is open to a blank worksheet, Open WorkBook "B" Sheet "B". copy
the data off the page, paste the data in the worksheet in Workbook "A", then
want to close WorkBook "B" Sheet "B".
' Open Returns Document
RTNFileNa...
|
5 |
12/5/2008 10:08:01 PM |
|
|
CountIF
I want to do a count of patients that are divided up into two groups.
Patients in the morning (before 11:59) that waited more than 20 mins
Patients in the afternoon (after 11:59) that waited more than 20 mins
Here's what I have, but it doesn't seem to calculate right.
=IF(E:E,"<0.5",COUNTIF(H:H,">" & TIME(0,20,0)))
which gives me <0.5
I'm missing something, but I can't figure ...
|
11 |
12/5/2008 9:10:32 PM |
|
|
trying to concatinate based on values matching in certain cells
I have the following info:
A_________________B________C________D______
Sarah Schwartz A1 1163233
Anne Schwartz A2 1163233
Marcus Lehr A2 1582167
Eric Lehr A1 1582167
Matthew Weiss A2 2194223
Kari Weiss A1 2194223
Ryan Mc Cartney A1 2299079
Kelly Mc Cartney A2 2299079
Cornelius Brendan-Guiney A1 2301508
Roberta Guiney A2 2301508
Nancy Trojan A3 2302575
Kenneth Trojan ...
|
5 |
12/5/2008 8:11:46 PM |
|
|
Excel 2007: is it possible to get in the title bar the complete file name & path?
Hi everybody,
not a major issue but...
Is it possible to display the complete file name & path in the title bar of
Excel 2007, by means of some kind of AutoOpen macro, for example?
If so, what code should I write in the macro?
Many thanks in advance for your kind help.
with Brgds,
Daniel
Office 2007 newbie
...
|
6 |
12/5/2008 7:53:14 PM |
|
|
Row number in another cell (in row and column)
I have a grid of names. I'd like to assign a number to each name,
simply to make it easy to find each name in the row and in the
column. To minimize confusion, I'd also like to have this number
being the same number as the row that the name appears in.
If that is unclear, perhaps a picture might explain what I'm trying to
do. http://i37.tinypic.com/eah509.jpg
The red ovals encircle the ...
|
7 |
12/5/2008 5:06:39 PM |
|
|
Cells Right Click Menu Problem
I have added the following code to my Personal.XLS.
Sub Create_Unlock_Cells_Right_Click()
'Set up Unlock Cells on Right Click Menu
With Application.CommandBars("Cell").Controls.Add(, , , 6, (temporary))
.BeginGroup = True
.Caption = "Unlock Cells"
.OnAction = "Unlock_Cells"
End With
End Sub
Its purpose is to add a 'Unlock Cells' item to the right cl...
|
3 |
12/5/2008 4:31:31 PM |
|
|
adding columns in 2-d array
I have a 2-d array named TEST. Is there a way of adding the contents
of a specific column of that array; e.g., a formula along the lines
of:
=SUM(TEST(1st column))
without using absolute cell references?
Thanks....
|
2 |
12/5/2008 4:13:54 PM |
|
|
tables
I am trying to convert a table of data into individual rows of data. I
would like to convert the row heading, column heading and table data
into rows. More specificaly, I would like to make the column heading
part of the individual data in a row. Can anyone help?...
|
5 |
12/5/2008 3:10:57 PM |