Re: problems with using camera tool to make dashboards
Fri, 03 Jul 2009 15:49:50 -0400
jenmoocat wrote:
> Hi.
>
> I am using the camera tool to create a complex dashboard in Excel
> 2003, using Windows XP (service pack 3)
[snip]
> When I Print-Preview or Print, the result looks strange: some
> annotations are missing, chart titles have changed size, the pie chart
> itself has changed size -- ...
|
calendar pop-up
Fri, 3 Jul 2009 09:05:22 -0700 (PDT)
How can I have a calendar pop-up box for me to make date selection
when I click on a cell? ...
|
Data aggreggation issue, need macro!
Fri, 3 Jul 2009 02:19:05 -0700 (PDT)
Hi,
I have this data:
column A B C D
timestamp bs bp as ap
00:07.0
00:07.0 30 2402 9 2403
00:07.0
00:07.0 29 2402
00:07.0
00:07.0 8 2403
00:07.0
00:07.0 19 2402
00:07.0
00:07.0 17 2403 30 2404
What I want to do is have a macro that can combine the d ...
|
Excel data to Google Earth kml
Thu, 2 Jul 2009 19:31:24 -0700 (PDT)
Hi,
I would like to export a list data from an access database based on a
filter to view in Google Earth.
Within google i need a simple place holder and a short description.
I have found some links that suggest that there are tools in excel
which could convert this on the fly for me but unfortunately many of
t ...
|
Re: Time sheet calculations
Thu, 2 Jul 2009 13:15:33 -0700 (PDT)
well, if ur asking for a suggestion, here`s some easy way which i
think ur familiar with.
y don`t u just move the (D-C) formula to some other column (i.e Column
L), and then, enter the number 8 in column E, and then in the OT
column (Say, F) enter L-E?? ...
|
Re: Removing hidden Format,formula preventing V-lookup from pulling
data
Thu, 2 Jul 2009 13:01:33 -0700 (PDT)
I am not sure i fully understand your case, however, i have two
comments on the limitations of the Vloopup function that might help
you.
1st: while using the vlookup function, the cell u r trying to look for
(lookup value) should be in the 1st column (to left) in the "Table
array"
Otherwise, it will return # ...
|
Lookup Mulitple Values, Return Results in One Cell
Thu, 2 Jul 2009 13:01:03 -0700
Hello ~
I'm trying to create spreadsheet that looks up the criteria in column A and
return the results (and there could be multiple results) from column B and
put it all into one cell.
I found this on the Microsoft site:
http://office.microsoft.com/en-us/excel/HA012260381033.aspx and, although
it's sor ...
|
|
|
Re: Show only rows with duplicate values in a column?
Thu, 2 Jul 2009 12:40:39 -0700 (PDT)
YES u can have duplicate data in two coumns sorted out,
repeat the same procedure, in column G and then filter for "TRUE" in
column F, and for "TRUE" in column G.
...
|
Entering multiple literal values in a spreadsheet
Thu, 2 Jul 2009 10:55:09 -0700 (PDT)
Hi,
I have to enter 6 digit numbers in a CSV file. When I re-open the CSV
file, it will delete the leading 0s in the number. So 00001 looks like
1.
If I enter =0001 in a cell, then the cell displays the literal value.
This is good. However, how do I do this for 400 different cells in a
row.
THanx! ...
|
display an empty cell
Thu, 2 Jul 2009 09:04:48 -0700 (PDT)
I used to reference cells in our worksheets (e.g. =Sheet1!C6). if
Sheet1!C6 is empty i will get a 0 in my cell. How can i get a blank
cell if Sheet1!C6 is an empty cell?
thanks ...
|