Upgrade to enjoy this feature!
Vital MX fantasy is free to play, but paid users have great benefits. Paid member benefits:
- View and download rider stats
- Pick trends
- Create a private league
- And more!
Only $10 for all 2024 SX, MX, and SMX series (regularly $30).
=Rounddown then the cell and number of decimals Vaughns worked much easier.
The Shop
Thanks for asking though.
What is most important is , if you are questioned or are questioning yourself, that you FULLY understand the expression you wrote. I have seen people copy expressions/formulas from the web and they have no idea what is going and just pray that the answer they are giving is correct.
Since you are using it everyday things will start to come easier and easier to you.
If you want.... Post some sample dummy data and what you are trying to achieve... Maybe we can help out.
I agree with the above you really need to check the answers because when I was trying different things I was getting answers I knew were wrong but did not know why.
The formula I use that I should convert to a vlookup formula looks at a cell and determines what to display depending on if a cell contains a number of different values.
Here is the formula I've written. I'll probably pull this in a bit since it's technically work material but I'm just using it for reference. Rather than writing a million "IF" statements, I probably should create a new table that has each available value, then reference that table with a VLookup. When I started this, it was only 5 or 6 IF statements, but as time has gone on, the statements grow more and more. Oh and I just did a character count and it's 5,490 characters long. Yeah that's probably bigger than it should be.
Sticking to Excel, I would do what you said. Create a reference table for your reason codes. I would then break apart your codes into partial descriptions. Finally, use a combination of VLOOKUP and TEXT to bring it all back together.
Also. you may want to look into making your own VBA Functions. Specifically, a "Select Case" statement. Basically an easier way to read IF statements. As you can see, nested IFs can get tricky.
http://www.techonthenet.com/excel/formulas/case.php
http://www.excel-easy.com/vba/examples/select-case.html
Hopefully this helps get you going in a more sustainable direction as your spreadsheet grows...
Pit Row
I keep track of monthly parts expenses I use 3 things DATE VENDOR and AMOUNT
at the end of the month I go Alt-N-V-T and make a pivot table , this works good most times but I noticed the totals are wrong some times. any clues on what I might be doing wrong ?
When selecting your source data... are you selecting entire columns?
If you add data after creating the table you need to possibly re-size and refresh your source.
Also... how are you entering data? Typing straight into the cells?Are you using any type of data validation or forms? Its important that your dates, numbers are being entered as the correct data types. True dates and true numbers.
or are you pulling from some type of source? Accointing program etc...
Typing from phone... Sry for typos
6/01/2016 vs 6/1/2016 ? it was 16 rows nothing fancy or imported from other file
DATE Vendor AMOUNT
6/2/2016 ABC 486
Tip of the cap guys.
What part is not calculating correctly? Total by vendor?
On the pivot... Right click the metric and check "summarize field values as" do you have it set to "Sum", "Count", "Average"? Is that what you want?
Maybe post screen shot of raw data and pivot. Of course change vendor names if business sensitive.
I'm sure it has to do with formatting or the data entry.
it was doing things like the total when I would highlight the values 10889 then when pivot tabled the total would real 1108 and the vendor numbers were wrong, some to high some to low.
I forgot to bring it home will revisit it next week.
Thanks for the help.
Post a reply to: Anyone here know excel?