Friday, January 27, 2012

Excel question?

Is it possible to sequentially organize a column in excel, I am trying to organize raw data listed in columns either by zip code or city name. What i'm looking for is how to have one column put all the like zip-codes in order so i can group easier. Is this even possible?Excel question?
Yup.



Data %26gt;%26gt; Sort



Then choose which columns you want to sort by. Most likely whatever column has the area codes.
yes, there should be a way to alphabetize it. look on helpExcel question?
If you are talking sorting by a column here is a like that explains out to do that.Excel question?
Yes

1. Click on the Column you want to sort.

2. look for the Sort button and click on it. It should sort the column and the entire workbook accordingly.
First, select the data you want to sort. Then click Data menu, and Sort, then select the properties you want (ascending, descending, etc.)
Yes...once all your information is in you highlight all the columns, go to the menu under DATA then SORT. It allows you to sory by either 1, 2 or 3 columns in either ascending or descending order.
There is not much of work

ex:expenditure for a house.payments to builder, payment to House loan, EMI(EQUALMONTHLY INSTALMENTS},INPUT IN THE CLUMNS TOTAL LOAN.INTEREST IF BIG AMOUNT IN A BANK

THESE DETAILS IN COLUMNS.ALLTRANSACTIONS. CAN BE DONE BALANCES @RIGHT COLUM

VERY SIMPLE.SAVE TOO

DONOT USE CERTAIN MULTIPLYING FORMULAS AT TOP .YOU ONLY CONTROL NOT THE P.C



I DID FOR 5 YEARS.FOR MY DEAR ONE.
  • liquid eyeshadow
  • No comments:

    Post a Comment