Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 298
  • Last Modified:

Include Unit Numbers for Single and Paired Rows

Note that one of the column names has been changed to Unit/Pair# to be tightly associated with the date of the named spread such that sorting them from top to bottom will have no impact on the default order which should still be from the oldest spread to the newest spread.  Sorting by the Unit/Pair number should put each spread in this default order.  In other words, each Spread has it's own number.  This is a critical step in moving the project to the next level.
TradeHist-2.2a.xlsm
0
rtod2
Asked:
rtod2
  • 5
  • 4
1 Solution
 
MakriniCommented:
Unsure what you want added in this column.  Can you give me an example?
0
 
rtod2Author Commented:
On the way....
0
 
rtod2Author Commented:
Boy did I do a bad job of explaining that.  I want each spread/strategy to have a number.  No change in order or sequence from the original.  Ignore the sort comment as that doesn't work either.  See if the attached doesn't provide a clearer picture.  Note the change in the name of the column again.
TradeHist-2.2b.xlsm
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
MakriniCommented:
So are you wanting to increment the sequence number every time the time/date changes - otherwise use the same sequence as above it?
0
 
rtod2Author Commented:
Yeah, that's one way of putting it I suppose.  Eventually, I will want to group them into positions and do the same thing with a single number for the entire position (which could contain more than one strategy).  Here we are just giving each pair (or single) a number.
0
 
MakriniCommented:
0
 
MakriniCommented:
I thought of a simple way to do it.  Does the above do what you need?
0
 
rtod2Author Commented:
OK yes,   Let's change everything to say "Strategy" and "Strategy#" respectively as that a correct depiction of what is actually going on.  I'll make the change again to the names of the columns and leave the macro change to you in the next question.  It's on it's way...
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now