#1   Report Post  
Junior Member
 
Posts: 1
Default Unify dates in rows

Hello,

I need to unify data from the Bloomberg portal, the problem is as there are assets from all around the world, they are not uniformly.

Meaning, that for example Europe has no trading day on Christmas, so there is no input on this day, but the assets from Asia for example got traded on this day, so there is an input for them. and as the data set is for the past 17 years, there are many of these discrepancies .

How can i unify them without going through them each by each?

Thanks for the help :-)
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,182
Default Unify dates in rows

Hello,

I need to unify data from the Bloomberg portal, the problem is as
there are assets from all around the world, they are not uniformly.

Meaning, that for example Europe has no trading day on Christmas, so
there is no input on this day, but the assets from Asia for example
got traded on this day, so there is an input for them. and as the
data set is for the past 17 years, there are many of these
discrepancies .

How can i unify them without going through them each by each?

Thanks for the help :-)


Why then, would the dates where no trading was done not be just left
blank? Otherwise, what do you mean by uniformity/discrepancies? What is
it, exactly, that you want to accomplish?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
paste to different rows on different dates hsg Excel Discussion (Misc queries) 3 February 26th 09 02:12 AM
delete rows with dates between dan Excel Programming 2 June 30th 06 09:34 PM
Delete Rows whose value is not between 2 dates Dominique Feteau[_2_] Excel Programming 4 March 3rd 05 02:59 PM
Delete Rows with particular dates Al Mackay Excel Programming 3 November 2nd 04 10:14 AM
hide rows with any dates JE McGimpsey Excel Programming 1 July 21st 04 03:35 PM


All times are GMT +1. The time now is 04:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"