Search results

Just a word: I've done a similar project at least a half dozen times over the last 2 years or so. Doing it with excel works, but the absolute fastest way to get it done is access.

I think the last time I encountered this I ended up changing the colors with vba.

I think I can work with this. Thanks Narayank.

One of my olap gadgets drops out date series calendar week. I need to return the month associated with that week using vba. It's actually part of a vba driven automation routine, so I could probably insert a formula wit hvba, I"m just having trouble cooking up the vba to do it. 40.2012...

I dig. Is the wysiwyg editor xinha?

Pivot table? Row Labels A B C Grand Total 1/1/2013 6450 3950 2750 13150 1/2/2013 5050 3850 2600 11500 2/1/2013 1350 1350 2/2/2013 1500 1250 2750 3/3/2013 1350 1350 4/3/2013 1100 1200 2300 Grand Total 15300 10500 6600 32400

cool. you're now a vba expert;)

Try to find a cli utility that will extract the metadata from an avi file- ideally to a .csv file. Sourceforge may be a good place to start. If you can do that, I _think_ you can get coax vba to open the text file and get all the data.

is there a function that will return the type of a variable? IE somefunction(myvariable) results as long, double, variant, whatever?

Bob, I've messed with the format function: trouble it brings the value back as text which doesn't really play nice with pivot tables. And you're probably right, but I"m still a n00b:) Hui, Can that be portable or do I have to put it into each workbook individually? Also, why the double?

So this UDF returns a date as a serial. Every time I run it over my data set, I just right click and format the cells as date, and go on with my pivot tables. That's fine, but I wonder if it's possible to return the value as a formatted date. I tried format([serial],"MMDDYYYY"), but that...

thanks fellas.

So, I've got some really noisy, messy, bad data that I have to 'make useful'. I've been able to do most of it with a combination of a handful of UDF's, standard excel functions, and a CSV editor. One part still has me a little worried. So I've got cells that look like this: Product...

I guess for somebody it's called 'onshoring'. heh. :) Share your data. I think a lot of times stuff like this ends up being really simple (and low maintenance too)

I just want a good code tag. Also, just my 2 cents - I don't have a dog in this fight: don't discount phpbb. I think vbulletin costs about 400 bucks usd. phpbb is FOSS and, at least from a user perspective, as feature rich.

dot plot with connectors maybe?

bwa! one gawker site got it last week, the other got it this week. sorry

http://www.spoon-tamago.com/2013/05/28/tatsuo-horiuchi-excel-spreadsheet-artist/

That's actually not a bad idea though. I wonder if that's something you could put in AHK, to hot key parenthesis over a given element in a formula.

shift+9 and shift+0 :)

http://www.powerpivotpro.com/2010/12/another-way-to-get-and-use-slicer-values-in-formulas/ http://www.excelguru.ca/content.php?263-Retrieving-Selections-From-A-PivotTable-Slicer Do either of these help?

Probably the easiest is to arrange your data into a table with all of those values calculated out. Use data validation or a drop down box to 'choose' which result is delayed.

I don't know if there's a quick way to achieve this. Maybe you could code the cities and pilots in numeric values and use a pivot table. There's this too: http://www.clearlyandsimply.com/clearly_and_simply/2011/06/emulate-excel-pivot-tables-with-texts-in-the-value-area-using-vba.html

Year([date]), month([date])

You may need to post sample data. I get the first part, the second part I'm not getting "but in some area(route) they will get double commision,(>125=2.00,>15=3.00) sale entry in same cell commision value only change how its work?"