Silicon Investor (SI) -- The First Internet Community

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Strategies & Market Trends : Bonds, Currencies, Commodities and Index Futures -- Ignore unavailable to you. Want to Upgrade?

To: Chip McVickar who wrote (1949)	6/19/2001 11:15:41 AM
From: fut_trade	Read Replies (1) \| Respond to of 12411

"How does one flip data in excel...?" I use star office, but one usually needs to select the column that needs to be sorted.

To: Chip McVickar who wrote (1949)	6/19/2001 11:16:55 AM
From: Jack of All Trades	Read Replies (1) \| Respond to of 12411

I think you need to use pivot tables? not an expert on Excel... I could write you a program to modify the data before importing??? Jeff

To: Chip McVickar who wrote (1949)	6/19/2001 11:41:20 AM
From: Lee Lichterman III	Read Replies (1) \| Respond to of 12411

>>How does one flip data in excel...?<< Highlight the whole spread sheet or your data will get scrambled, DON'T highlight only one column, Make sure you have the whole spreadsheet highlighted!!! Then go up to where it says "Data" then select "Sort". From there you can select if there are headers such as Volume, open, high low close etc. If so then select which column you want to sort by. If you don't have headers and it is just raw data, then make sure the headers is off and then select the column you want to sort by. Hope this helps. Good Luck, Lee