one more time index/match
I know I asked this same type of question yesterday but for some reason
I cannont get it to work. Here is my problem:
B2 � has a list to choose from either 5kv, 15kv, 25kv, �
B3 � has a list also to choose from 8, 10, 12, 500
B4 � here is my problem:
I need B4 to look up B2 and match the size to sheet2 column B
Then take the value in B3 match it with the value in sheet2 column D
And input the number located in column F in that same row across.
I am pretty sure this can be done but I am having a hard time trying to
index and match where I need to find two values from two comumns.
Thanks fo...Auto Populate Time
I am trying to create a employee time tracking sheet, I can auto populate the
time and date no problem for each record i.e. login, logout however once I
perform that task I need that data to write to a different cell on a
different worksheet based on the date criteria and remain there when the date
changes. Any suggestions?
did you try copy=pastespescial-values (not testex)
"JAG" <JAG@discussions.microsoft.com> wrote in message
> I am trying to create a employee time tracking sheet, I can auto populate
>...Rotate Time Line dates
This is my last question (for the time being).
How to rotate the dates on a time line bar by 90 degrees (left or right)?
In my attempts, the dates are unreadable because they overlap.
I will overlook the proper command.
...Cells not recognised for charts
I have a table of public domain data from Nomis (The UK Gov't office
that provides data on employment).
I have created the table manually and it works fine. The Nomis one will
not display as a chart. I have copied the formatting of the manual one
to the Nomis version, so it's not that. All cells are 'general' in both
If I double click in each cell, it does something to it and it will
then be recognised but I cannot see anything which tells me what the
difference is before and after.
If anyone can help me understand what the issue is, and even better,
how to solve i...Excel chart, changing into sections to color
I have a line chart. The user is dividing the chart, manually, with verticle
lines. In one section, he wants the chart to be red, in the next section he
wants it blue and the third section he wants it yellow. I think it's a neat
concept but in trying everything I can think of, I'm not thinking it's
possible. The lines color cannot be changed mid-stream. Any thoughts??
Do you want the lines or the background to change color?
Here are examples showing in principle how to change colors behind the
- Jo...Automatically entering a number of tables when prompted.
Hi im new to this.
Through work I have created a table of activities and persons details for a
youth centre. I use a word document to enter and track the usage.
The Problem is only some of the tables are relevant depending on the
activity / day of use. So I want to only show these when required, and auto
insert x amount of tables when prompted. i.e.
Day (Field box)
Activity (Field box ) =Depending on the activity choosen will insert
relevant table of information required, ie court size, number of persons,
refs, book ref etc
No of Participants (Box type in number) =Pr...Special chart
I'm getting desperate, trying to make a non standard chart with excel
It's so simple i don't get why i can't achieve to do it. I join a jp
of the chart i'm thinking of (not enough confident with my english t
try to explain it here !).
You guys sure know how to make it : actually, it's very very ver
important for me (three years of study nearly depend on it !).
Thank u all by advance
Attachment filename: dd.jpg
Download attachment: http://www.excelforum.com/attachment.php?postid=40519
Message posted from ht...Labelling at xy scattered chart
I am working on a xy scattered chart which has in x number of days and in Y
depth. I want to put labels on different points but respecting a x-y location
(I mean at a cetain depth on a certain day).
I want these labels to be automatically written and updated as chart grows
bigger with time passing and depth increasing.
Thanks for help !!
There are several third party Excel add-ins which allow you to link data
labels to the contents of worksheet cells. Two good (and free) ones are:
Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-...Third Party Charting Add-ons/Plug-ins/Controls
Can somebody suggest any third party Charting
Add-ons/Plug-ins/Controls that expand the charting capabilities of MS
Such that may be code-controlled in VB or VBA.
What is it you are trying to accomplish? The capabilities of Excel
charting are broader than most people imagine.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
Hans Wolf wrote:
> Can somebody suggest any third party Charting
> Add-ons/Plug-ins/Controls that expand the charting capabilities of MS
>...how to display full path instead of filename
In a MDI app, how can I display full path of the doc in the titlebar of the
first u get the full path of the file by using CFile::GetFilePath. it
returns the full path of the file. then update the window title bar by using
"Václav Jedlièka" wrote:
> In a MDI app, how can I display full path of the doc in the titlebar of the
Thank you very much
But I had the CFrame CDocument CView architecture in mind.
In the meantime I found I...Charting Smoke drift in winds based upon varying speed and altitud
Does anyone have any idea how Excel might be used for the subject problem.
Hoping to get some sort of a chart that would show a predicted downwind
pattern of smoke particles at a particular distance based upon wind speed.
Presumably you have a model that makes numerical predictions of smoke
particle distributions? If so, you need to think of a way to graphically
display this predicted data.
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
"Jott" <Jott@discussions.microsoft.com> wrote in messa...How do I count odd numbers in a range?
Could someone please help me!!!
I am trying to count how many odd and even numbers there in a range. I have
tried to use the 'countif' , 'iseven' and 'isodd' formulas. However, I have
Can someone please let me know if this can be done?
Here's a formula from an older post by Peo Sjoblom that seems to do what you
Adjust the range as necessary.
> Could someone please help me!!!
> I am trying to count how many odd and even numbers there in a range. I have
> trie...Pivot charts in powerpoint
I'm trying to create a presentation that includes pivot charts. The reason I
want to do this is that there are numerous permutations to cover - thus the
In the interim I have copied the charts as a link - but this is not ideal
because I have to keep going back to the spreadsheet which looks messy during
It would be great if the pivot chart filter could be used in ppt.
I'm using PPT 2007.
Open the custom animation pane.
Select the Excel object on the slide. Choose Add Effect | Object Actions |
Open (or Edit -- I don...Change default Contract View to Active instead of Draft
When you are itn eh account view and select the contracts link the default
view will show you DRAFT contracts instead of Active Contracts. Since this is
a entity that is embedded within an Entity there is no way to modify the
default view to show Active.
To reproduce what I am reffering to:
Open an account record and click on the contracts link, it will show you the
Draft contracts and then you have to manually change it to Active contracts
with no way to make this default.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the mos...2007 has a fit each time i want to hyperlink text
I have a project where i need to add many links to a document, however each
time i select text and click the "linking" button, Publisher has a fit for
around 40 seconds then I am able to add a link.
I cant find any "product service pack updates" for publisher 2007, just for
office (which i will see now if that will update publisher (as i only have
publisher 2007, not office.
When i say has a fit, it freezes up with 99% CPU useage, then after 40
seconds or so springs back into life, I have maybe 1000 links to add to my
document and cant have publi...Working Time calculation
I would like to generate report for those who late to work. But the database
time is in text format, so i change it to short time using code as below. Is
it correct ? & how do i set a calculation for total time late in HH:MM:SS
as my working time is 09:00
Format(IIf(IsNull([dbo_Punctual.TrTime]),#12/30/2010#,[dbo_Punctual.TrTime]),'Short Time') AS [TRANSACTION TIME]
"Nancy Tang" <NancyTang@discussions.microsoft.com> wrote in message
>I would like to generate report for those who late to ...TRUE/FALSE NUMBER CLOSER/NEARER??-please help anyone
can anyone help me with this problem.
i am after a formula that produces a TRUE or FALSE when 2 or mor
different numbers are the closest to the objective number.
below are some examples.
is 275 closer to 500 than 400:answer: FALSE
is 400 closer to 500 than 275:answer :TRUE
basically the formula should be like this:which is closer to 500, 27
(false) or 400 (true).
is 16 closer to 15 than 17:answer:TRUE
is 17 closer to 15 than 16:answer:FALSE
hope everyone can understand the examples.
i also help someone out there can help me with this formual.
thankyou for reading this THR...sum and minus columns and rows at the same time
How do I use the minus feature to subtract numbers in a row and then keep a
running total in the corresponding column? I have tried everything I know and
I can't seem to get it done right. PLEASE HELP!!!!!!!!!!!!!!!!!!
I have been using the Excel Program for several years (home use) but not
to a 1/10th of its potential.
I want to create an invoice for my business whereby the invoice number
automatically prints in sequencial order every time I ask it to print
and to remember the last number which was printed - if that makes any
sense. The invoice will be a template and not completed "on-screen".
Is this possible?:confused:
Message posted from http://www.ExcelForum.com/
I think it gets too dangerous to mechanize this a lot. If sheets are lost and
have to be reprinted, you could have more...adding minutes (> 60 ) to military time
I am using a spreadsheet with military time expressed as hhmm (no ":").
I need to be able to add time intervals, expressed in minutes (not i
decimals of hours) to these military times to get estimated timef o
completion in the same time format (HHMM). For example, at 1835 w
started a project estimated to take 145 minutes complete. I can do th
math in my head to see that 145 minutes = 2 hours and 25 minutes for a
ETA of 2050 but I can't make the spreadsheet do it. I'd appreciate an
---------------------------------------------------------------...Simple Date/Time Macro
ActiveCell.FormulaR1C1 = "9/16/2009"
ActiveCell.FormulaR1C1 = "9:25 AM"
I want to set up a simple workbook that enters the above information on the
current line in the sheet. When I recorded the keystrokes I wanted, I ended
up with the following macro, which only works once.
Starting with the second line, running the macro puts the date in the right
place, skips Column B and then leaves the cursor in R1C1.
How do I get this macro to enter all the information on the current line
(date in c...Updating charts in Excel
For some reason, my charts no longer seem to update when the source data
itself is updated. The source data cells are actually formulas themselves,
but they are updating with the new information just fine. It's very strange
that the table the values are drawn from have changed and are current but the
chart itself still shows old numbers. The only way I can fix it is to right
click, select source data, then re-enter the source data cells. (Actually I
change one cell and then change it back and it updates.)
Does anyone have any idea why my workbook is no longer updating cells? By...How do I get a column to appear along the horizontal axis of chart
I have two adjacent numerical columns; when I select them to create a chart
Excel chooses to plot both columns vertically side by side. Instead of that I
want the left column to appear along the bottom of the chart and the right
column to be vertical.
This is probably very simple but it is doing my head in.
Any suggestions most appreciated.
Sounds like it's a Scatter graph you want to produce - just select XY
(scatter) as your chart type and it should get the result you want. You can
then add a trend line to get linear representaion of your data.
Hope this works/helps.
Andr...when the size of view change,how can I also change size of the font,chart in this view
I want to change the size of font and chart go with the view's size
what can I do .
thx for anyone respone.
> I want to change the size of font and chart go with the view's size
> what can I do .
> thx for anyone respone.
> &best regards.
Handle the WM_SIZE message in the view. It is passed the new size.
To change the font you will have to call the CFont's DeleteOjbect, then
cal...How to get current date & time in a specific time zone
How can I get the current time of a specific time zone?
For example, my workstation was set in "(GMT+08:00 Beijing, Chongqing, Hong
Kong, Urumqi)", how can I get the relative datetime in "(GMT-06:00 Central
Time (US & Canada) with daylight saving changes".
>How can I get the current time of a specific time zone?
Have a look at the TzSpecificLocalTimeToSystemTime &