Posts by tradertt

Re: Download daily data from webpage and plot them into graphs

Can access not be used as my office computer does not have access.

Re: Download daily data from webpage and plot them into graphs

Hi

It is actually 3rd July 2005. Different Date format.

Oh ... never used access before plus SQL - Does anyone have any sample of how this will work ?

Re: Download daily data from webpage and plot them into graphs

Thanks. BUt I do not know how to plot the graph of each Unit Trust and to input their daily data?

Re: Download daily data from webpage and plot them into graphs

Anyone can help here?

Hi Guys,

Have not been in here for a long time.

Need some help.

I have a webpage where I want to download the daily data from,

http://www.dbs.com/ratesonline/shut.html

and I want it to be inputted into Excel so that I can call up its graph

X Axis - Date
Y Axis - Price

base on the name of the Unit Trust.

How can I do it? Can the data be downloaded using "Import External Data" function?

How can it be inputted as a daily data?
How can it be plotted as a graph?

Thank you guys in advance.

Re: Vlookup fails on a column when the numbers are the same

But the columns are already formatted to Number but it still does not work - Please assist.

Hi

Can anyone help?

I did a vlookup as per the excel sheet.

In the Original column, the vLookup fails to reflect the data range but in the retype column the vlookup succeeds as can be seen in the excel spreadsheet attached.

Please assist.

If I do a F2 and Enter on the Original column, the vlookup works. Am I missing something here?

Re: IF Function - Can a wild card be used?

Quote from Domenic

Try...

=IF(COUNTIF(A1,"AU$*"),1,IF(COUNTIF(A1,"GBP*"),2,IF(ISNUMBER(A1),3,"")))

Hope this helps!

Wow - Thanks - How does that COUNTIF work?

Hi

I have a problem.

There may be 3 things in a cell

AU$1.00
GBP1.00
$1.00

The prices may change but the currency is the same...

How can I do a IF function or any other functions that will output a number say

1 if its AU$
2 GBP
3 $

How can I do it?

Re: Setup a cell that can only have 8 characters

Oops sorry I got what you meant ;p

By the way, if I want to copy data validation to ALL cells - Can it be done with a copy and paste special?

Re: Setup a cell that can only have 8 characters

Thanks for that but can it be done on the actual cell so that a error prompt will come up when a user tries to type in 9 chars?

Hi

How can I set a cell so that if a user inputs 7 char or 9 char - it will be an error - only if 8 char are input, then it will allow it to go through

Re: Share Outlook email between 2 computers network by a router

Anyone can help please

hi

I have a problem. I would like to share my outlook emails between 2 computers so that more than 1 user can access my email account using Outlook and actually answer the emails.

however, I want those emails that has been answered to have the Replied Tag and also the sent message be saved in both computers.

How can I do it?

Thanks and any suggestions would be appreciated on how to share outlook AND Outlook express between 2 computers connected by a router.

Re: Vlookup 2 columns & if match, output column 3 - Some data are seperated by a comma

Thanks for the reply. Do you have an example of how it would look like? If I do not wish to affect the source data sheet (payments) , can the macro still work?

Hi

Please have a look at the excel sheet and see if anything can be done.

some item numbers are seperated by a comma but I need them to be seen as 2 seperate item numbers.

Hi

Is there a way to check when a cell is Last updated?

A Macro to do it where a date is added so that I know when I last updated a certain CELL?

I would prefer it does not appear in the cell itself.

Any help?

Re: Formulae to show Hyperlink?

Hi thanks for the reply.

However, I want to SHOW the Hyperlink embedded in the cell in ANOTHER cell.

Is there a formulae for it?

Hi

Is there a formulae to show the Hyperlink from a column of links in excel

Say Yahoo - then a formulae will show http://www.yahoo.com

Please help

Re: Advance Filter - Macro to select cell references and filter it out in the main sheet

Hi

If I want to add 1 additional column to lookup - that is 4 instead of 3, how do I add it into the code?