Applications :: Sorting Out Columns In Excel
Dec 6, 2010
I want to sort out my finance spreadsheet where I have the category of the spending and the adjacent cell is the amount I spent.
[Category, Price]
[Gas , $50]
[Grocery , $80]
[Lunch , $15]
[Gas , $34.50]
What I'd like is for a function that can sort the categories into individual columns for the categories. So that this big list of purchases I have is sorted out into their own column that matches the category and then sums it too. Does this make sense? I was sort of avoiding any VBA for this but if thats how it has to be done then thats cool
View 9 Replies
ADVERTISEMENT
Apr 13, 2010
1. Turned the List Manager on by accident in Excel. Can't figure out how to turn it off now. I am using Excel 2004, and a MAC mouse - so no right-clicking for me...
2. How do I move columns in Excel? I select the column on top, but then try dragging it to a place I'd like it to move, but nothing happens. How do I do that?
3. General Mac Word/Excel question - how do I get to use "Home" and "End" buttons? When I hit them I simply jump somewhere, but not to the beginning or end of the paragraph. I have a MAC keyboard with the "Home" and "End" buttons along with the "Help", "Delete", "Pg Up" and "Pg Dwn" keys - basically it looks a lot like a PC keyboard...
View 1 Replies
View Related
Aug 12, 2009
Having switched recently from Entourage to Mac mail, there is one thing that i am missing and would like some help. I have a large inbox and normally find mail by clicking on the "From" column header, to sort the by the names of people sending me mails. Using entourage I would then press "d" on the keyboard to take me the first name begining with d. However in Mail when I press d, it takes me to the first email in which the subject line starts with a d. How do I get it to take me to the first name begining with d?
View 5 Replies
View Related
Nov 13, 2010
I am using Mac OS X 10.6.4 with Excel Mac 2008. I am trying to find a compatible duplicate remover. On my PC I used Ablebits which was great. Now that I have moved to Mac I cant find a similar product that is compatible.
View 2 Replies
View Related
Jun 18, 2012
excel 2011 - screen frequently scrolls a few columns to the right on its own.
Info:
iMac, Mac OS X (10.7.2)
View 3 Replies
View Related
Feb 6, 2009
I am searching for a plugin, software or a solution for a situation I have with an Excel/Word Mail Merge.
It's a law firm we specialize in DUI/DWI and Reckless Driving defense. We subscribe to a data collection service that pulls data from various court systems around the state. We are then given this data by jurisdiction. The Excel files we receive come with 2 workbooks in one file for Traffic and Criminal arrests data with name, address, reason for arrest, etc, etc.
What I have been doing is opening each Excel file and copying and pasting into a new worksheet only grabbing the DUI and Reckless driving arrests because tis is all I am needing from the various files. I then save the new workbook and do a mail merge with Word from this newly created workbook.
Now my question is there such a plugin or software that will combine all the Excel files I receive from the Data collection house and then be able to filter out only the DUI and Reckless Driving arrests to a single Excel Workbook?
View 6 Replies
View Related
Oct 21, 2010
I have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do!!
View 3 Replies
View Related
Oct 21, 2010
I have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do
View 1 Replies
View Related
May 22, 2010
I recently purchased my first MAC with Excel for Mac 2008. I am unable to open any files created in it on my PC which has Excel 2003. Apple is of no help. They had assured me of compatibility at purchase citing the new open format. The MAC Excel 08 file won't open on the MAC on which is was created with their Numbers program either.
View 4 Replies
View Related
Aug 24, 2010
I have a column that has name / phone and i'm trying to break out the two into two separate columns. I can't figure out a way to do this? I'm trying to figure out to use the line break to trigger the column separation but no luck? Here is an example of what i have in a column:
Joe Blow
888-888-8888
View 3 Replies
View Related
May 28, 2010
I can't find the option to get rid of them. The first two, arrows and the dot. I only have 'Attachments', 'Date Received' and 'From' selected under 'View > Columns'.
View 2 Replies
View Related
Nov 21, 2009
In Numbers '08, is it possible to link cells/columns between sheets; so that in the below spreadsheet selecting an item from Column A in "Hub Dimensions" sheet in the drop down box of the "Spoke Calculator" sheet would fill out the cells in Column D of the "Spoke Calculator" sheet with data from the related cells in the "Hub Dimensions" sheet?
View 1 Replies
View Related
Mar 21, 2010
Fairly simple, I've added an automatic contents page to my document, but I was hoping to have it use two columns instead of one to conserve space since none of the headings are especially wide. However, when I change the number of columns, it screws up the contents, whatever is used to space out the titles and the page numbers doesn't seem to adjust automatically.
I'm wondering if anyone knows a way to do this without manually entering the contents?
View 2 Replies
View Related
Nov 10, 2009
When I send my .xls files from my Mac (Office 2008) to my boss's Windows machine (Office 2003), he gets an error message when he attempts to open the excel spreadsheet: Excel has encountered an error and must shut down. I've sent files to other computers and not had a problem, and my boss has received other excel files and been able to open them. So it must be something between these two machines/softwares that is affecting it. Any suggestions or ideas? I can add any additional info you need.
View 2 Replies
View Related
Nov 26, 2010
I have a column that has name / phone and i'm trying to break out the two into two separate columns. I can't figure out a way to do this? I'm trying to figure out to use the line break to trigger the column separation but no luck? Here is an example of what i have in a column:
Joe Blow
888-888-8888
View 13 Replies
View Related
Dec 23, 2004
Is there a way to alphabetize my Bookmarks in Safari? They seem to be in random order. I'm not asking about the Bookmark "headers" that I keep on the bar, but the items under each heading.
View 14 Replies
View Related
Feb 8, 2009
I have a bunch of episodes of The Office, but I want to sort them by Episode. Which is it? In Get Info there's "Episode Number" and "Episode ID" episode number seems to be the definite one for labeling which appears first in the season (what I want to do), but there's no option to display it in the normal showing screen. There is for Episode ID, but it doesn't seem to be the right one.
View 1 Replies
View Related
Jan 8, 2010
I've set up Rules and they work if I go to Messages/Apply Rules and click each of the rules. However, it does not apply the rules if I click All Rules at the head of that list. Someone advised me to check the boxes of each Rule under Tools/Rules so they would be applied when mail arrives, but that doesn't work. All of those boxes are checked and the rules are not applied when mail arrives.
1. Any idea how to make rules apply as mail arrives?
2. If that's not possible, do you know how to make "all rules" work so I don't have to highlight and click through each of the several rules?
View 10 Replies
View Related
Jan 18, 2010
I am having trouble sorting my itunes library. I have numerous different songs by different artists (i.e 700+ lil wayne songs). What I would like to do is sort my entire library alphabetically by artist. Then, I want each artists songs to be alphabetized. Its just way to hard to look through 700 shuffled songs from one artist.
View 1 Replies
View Related
Feb 23, 2010
For some reason iTunes messes up my complaitions if I sort the albums by anything else than "album", such as year. It "breaks" the compilations up (you know what I mean) even if the year is the same. The weird thing is that some (up to 3 I've seen) tracks keep in bundles (even despite having different artists). Also, if the album stays "intact" by some wonder when I sort by year, the track order usually becomes totally random... (14, 4, 2, 13, 3, etc).
Yes, they are marked as compilations. Yes, album artist is the same (blank field). No, there are no typos.
As a disclaimer, I'm on a Windows machine. Can anyone tell me how to set the "sort by year" a default? It's pain to re-set it every time I launch iTunes.
View 18 Replies
View Related
Dec 28, 2010
Over the years, I have amassed GBs worth of music, spread over many different iTunes libraries, as a result of having desktops, laptops, replacement machines etc. When I first started my collection, I stupidly "let iTunes manage my library" which has resulted in all my tracks being put into thousands of different folders because iTunes likes to create a separate folder for each artist. I was wondering if there was any way of exporting all my music in the iTunes database to a new location, organized by album. eg. A State of Trance 2010 Yearmix being exported to a folder called that, not each of the 80 tracks going into a separate artist folder.
If this can be done, I'm hoping to consolidate my music collection into one library, once and for all! It's probably worth noting that I'm now on Windows, but I thought I would ask here as iTunes is an Apple product. I have access to a Mac should I need to do anything "Mac-specific" to make this happen. Tune up looks like a promising piece of software. However, it only seems to clean up the music files themselves, not their organization within my music folder. Does anyone have any experience with it? Sorted! I'm sure there are loads of people out there that would like me reorganize the file structure of their music after iTunes obliterates it...so here's what I did.
1) Downloaded Songbird. What a great application! It has addons!
2) Went into the applications options. (Tools >> Options)
3) Selected the 'Manage Files' tab.
4) Ticked the box to 'Allow Songbird to manage files'. In the 'Structure Folders' section underneath I changed it to 'Album/Song Files'.
5) Clicked OK at the bottom to save changes and Songbird then wizzed through my collection and put all my music into Album folders!
6) Uninstall iTunes.
View 12 Replies
View Related
Sep 13, 2006
Since installing iTunes 7, all of my Various Artists Soundtrack albums are now all broken up. For instance, 5 songs might be grouped together, and then another 4 songs grouped together elsewhere, even though all of them are labeled the same. Any idea on the proper way to label them to keep them all together?
View 17 Replies
View Related
Feb 6, 2009
Alright, so I have two songs by The Beatles, Sgt. Pepper's Lonely Hearts Club Band and With a Little Help from My Friends. If you don't already know, these songs cut into each other, so if you play With a Little Help right after Sgt. Pepper, it will sound like one song (this was intended). What my problem is is that the way that the songs are sorted (by Artist), With a Little Help from My Friends is before Sgt. Pepper, where it should be vice-versa. Is there any way I can fix this problem, without having to change the way the songs are sorted (I like them organized that way) or creating a playlist? Maybe an Applescript or application?
View 2 Replies
View Related
Feb 11, 2009
I have a lot of mp4 files; vmovies, TV shows, music video's, everything. But, when I load them into iTunes they all show up under the movies tab, and I can't find a way to move them to different categories.
View 2 Replies
View Related
Mar 4, 2009
I have noticed for some reason in my contact it lists my work information before my home stuff. Normally I would not care but the autocomplete Safari uses always pull the first information. I deleted the person in the address book and readed in the order I want but it still fails.
View 2 Replies
View Related
Apr 27, 2009
Recently I went on a trip and am looking to arrange my photos by the date taken, i know on my camera it embeds the time taken into the photo file, and i was wondering if there was any easy way to arrange the photos so they are in chronological order?
View 1 Replies
View Related
May 29, 2009
At work I receive various medical records for clients. It would be helpful to take a stack of medical records from a specific doctor, scan them into PDF's, and then tag each page of the stack with the name of the provider and date of service. Then, as additional records come in from various providers, and I repeat the process, I would hope to have the ability to combine all the records if need be sort the entire set of records by date, or if I choose to have them sort by provider. I know it would require some manual tagging but overall I think would save a great deal of time. I cant find a single program that will enable me to do this. I'm looking to have the ability to quickly rearrange the pages of a pdf file based on tags or labels that I add.
View 4 Replies
View Related
Dec 28, 2009
My wife and I recently purchased our third Mac system (iMac). She is an aspiring photographer. We have our oldest family pictures (most in iphoto) being moved to the IMac from our Mac Mini and also her DSLR photos from our Macbook to the IMac as well. (she uses lightroom/photoshop). The problem we are running into is we have probably about 100GB in photos and I know there are many duplicates. The problem is the pictures are mixed formats (jpeg and raw) and some are the originals and some are edited. I'd like to get some sort of program(s) that could remove duplicates (if there is a dup in JPG and RAW, I'd like to keep the raw) and maybe group (its asking alot, I know) up the edited photos.
View 1 Replies
View Related
Dec 30, 2009
I sometimes use Limewire and make playlists with my most recently added (downloaded) songs. I just can't figure out how to sort it?
View 3 Replies
View Related
Mar 31, 2010
I prefer seeing my music list sorted by artist's last name. I have gone through and changed all of the Sort Artist fields to lastname, firstname. The new iTunes update has broken this view. When using the Artists column view, Al Green and Adam Sandler are now listed in the goddamn A's.
View 6 Replies
View Related
