Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
Actually YouTube holds a bunch of good vids on any aspect of excel, normally a simple search like 'excel table' would do...
If you have any specific questions, just shout and I'll try to help.
But here is a general question..... say you have data in the format of:
Where in the above example, the column headers are blue, and Have 'Date and SizeX.' But then on a row under that in color green, for each 'Size' value, there is a corresponding code associated with it in green.
So for each DATE/DAY, I essentially have various 'Sizes' associated with it, along with a code.
I am primarily wanting to filter on 'Size', which is just a number I want to apply a sort to. So if I sort a cell in THAT column, it will sort the size along with the date fine.
The problem, is, that it also throws the 'Code' Row out of whack, in that the Codes don't stay with the original size value it was associated with.
So basically, is it possible to sort on a value in a given column, while keeping the actual value of the data of the cell beneath it with it?
Is the 'Code' entered manually or is it calculated by a formula? If its a formula, then there might be a slim chance it could be done without too much fuss, but i would say probably not.
So basically you would need some helper columns and code the sort function, which is not that easy....
The easiest way would be to have the 'Code' in the same row as the other stuff....if that's an option, I would be happy to help any time if you provide some more details of what exactly you want to accomplish.
Is the 'Code' entered manually or is it calculated by a formula? If its a formula, then there might be a slim chance it could be done without too much fuss, but i would say probably not.
So basically you would need some helper columns and code the sort function, which is not that easy....
The easiest way would be to have the 'Code' in the same row as the other stuff....
vvhg
All those values are actually placed in there by NT. So there aren't any formulas associated with the sheet, just the values.
I was afraid that I would have to put everything on the same row, which I can do, just makes the data a bit harder to read.
All those values are actually placed in there by NT. So there aren't any formulas associated with the sheet, just the values.
I was afraid that I would have to put everything on the same row, which I can do, just makes the data a bit harder to read.
If it is only readability, I'd swallow that pill. The other option would likely end in a major coding project.
If the data is put in there by NT, have you had a look at @petrmacs importer for the journal in this thread? Perhaps the things he uses would be useful to you too?
Btw, once you got that issue sorted, if you want to use the table feature in excel for your data, I could easily provide a code snippet that re-sizes the table based on the existing data.
I used THIS tutorial, but it seems like it just doesn't work?
Actually, just to plot the number of occurrences, then plot a distribution of frequency/occurrences.
It's working for me, are you highlighting the whole range where you want the formulas to be entered first and after entering the formula, are you hitting ctrl shift enter?
It's working for me, are you highlighting the whole range where you want the formulas to be entered first and after entering the formula, are you hitting ctrl shift enter?
Here's the video for what I am doing. Not sure what I'm doing wrong? You can see I select multiples cells, then type in the formula, and select the dataSeries, followed by the range. But it just does what it wants it seems?