Software :: Excel Duplicate Removal And Compare 2 Columns
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.
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...
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
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?
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!!
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
I have a first generation Macbook that's starting to get long in the tooth. I keep hearing how the MBA sometimes feels sluggish... and I can understand how it would compared to the new aluminum MBs and MBPs. However, I would imagine it would be a fair bit faster than my old white MB. Am I right in assuming that... or am I way off?
[URL] Insert Retailing DVD and open Disk Utility, then select the DVD and follow the above image MD5 of ADC's 10a432 is (snowleopard_10a432_userdvd.dmg) - 1d1fb7eca55470143c153f7f902b4ada
Here's what I need and I'm not sure how I'd do it so I thought I'd ask, since I'm new to macs. I have a hard drive with mp3's on it. Each artist has it's own folder with their albums located inside. What I want to do is print or compile a text file [or whatever you recommend] just the Artist folder with another folder to determine what Artist's I'm missing on the one hard drive.
this is what im currently goin with.. SSD as boot/apps and a 1TB for data.. but a couple people suggest 1TB drives in raid.. 1. what do I need for raid? 2. how does it compare against the SSD+1TB setup? 3. can I add raid to the SSD+1TB and get more 1TB drives later?
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.
I recently purchased a HP MediaSmart Windows Home Server and I am wanting to find a solution for syncing my iTunes LIbrary to this network drive.
Can someone suggest some software that will compare a folder on my mac with a network drive and sync any changes it finds? I would like to have a duplicate copy on my home server. I would like this application to run everyday and update the Home Server with new or updated files it finds.
Before someone suggests something about Time Machine I am already syncing my MAC's to this networked server. I am looking for a straight folder to folder compare and sync.
I currently use a 4 year old MBP with an X1600 GPU. Thinking about going for an Air, and wondering what the 320M is like in comparison.
I play the occasional game but principally would use the machine as a holiday / travel laptop and would hope to be able to do light 3D graphics work on it. I know it's never going to replace a desktop machine but I'm quite good at working within hardware constraints.
Is the 320M a much better GPU? If so by what order of magnitude?
I don't actually own a Mac/MacBook yet (but have ordered my first), and was wondering how the trackpad compares to the old one. I have used the WhiteBook a few times and fell in love with the trackpad on that... so am I expecting to be totally blown away when I recieve my MacBook?
I am trying to sell my Rev. A MBA to get a Rev. C 2.13GHz 128GB SSD. Looking to read comments from people who did the same. Can Rev. C finally play a movie without skipping frames? Can it run 4-5 apps without the fans kicking up to 6,000 rpm? Also the iSight on the Rev. A is a POS. Have they upgraded it to a better one?
I am needing an app that can compare a directory of folders, or just individual files to compare the contents of each to see if they are different (not just modify dates and such).
I copied a folder that's 276 GB big and has 432 files in it from one external HDD to another one. It tooks about 2 hours to transfer. Now just to make sure I looked up the folder information (⌘+i) of both folders.
Strange thing is, that the new folder is 7 GB and 4 files short! It didn't give me any errors while transferring and I don't have the time to manually compare every single file.
Is there an application that compares 2 folders and tells me what files are missing/different?
Is there some Lion-compatible Finder-like utility that will do the following? Display the list of files from two different folders, in parallel columns.Preferably display, too, such other attributes as you select (kind, date modified, size).indicate visually the differences between the two folders: -- (a) which files in the first folder are not in the second, and vice versa;(b) which files are in both folders but are newer in the first folder than in the second folder, and vice versa?
Obviously if a utility can list the contents of two folders next to one another, you could go through the two lists file-by-file. But that's not what I'm asking about.note that I am not asking about comparing and showing the differences between two files. Thus so far as I can tell, the following apps do not do what I'm asking about:Araxis MergeKaleidoscopePath Finder Path Finder, at least, can display two folders in parallel columns; but so far as I can tell, there's no way to get it to indicate what I ask in #3, above.
Info: iMac, Mac OS X (10.7.3), 3.4GHz Corei7, 16GB, SSD + 2T HD
I was wondering how to add columns in Pages. In Word, I would add a column and then when I typed to the end of the page, it would print at the top of the page on the right. I don't need to add a column in a table.
I've been playing around with my spaces setup and I'd like to know if it's possible to unlock 5 spaces in a row (columns), as opposed to the current limit of 4 columns and x amount of rows. Maybe I'm just being picky but, when it comes to spaces. I like being able to just move horizontally from beginning to end without getting lost when additional rows are attributed.
For all of you who are looking to compare video cards here is a decent list: http://www.tomshardware.com/reviews/...rd,2011-6.html I think the 120 = 9500GT and the 130 = 9600GT. Please correct me if I am wrong as I am not positive about this.
I'm currently using a MBP 2.33Ghz with 3gb of ram.What I want to know is how much faster are the latest machines, I find Aperture slow to load images and Photoshop can be slow to apply filters at times.I'll be waiting for the announcement but how does my machine compare to the current fastest MBP's?