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.
View 2 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
Mar 13, 2012
Any recommendations for quick removal of duplicate files from Lion?
View 6 Replies
View Related
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
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
Jul 1, 2012
I am unable to use search, merge, locate or duplicate removal function on Lion address book.
Info:
MacBook (13-inch Late 2009), Mac OS X (10.7.4)
View 1 Replies
View Related
Jul 19, 2010
does anyone know how to delete duplicate cells in Excel 2008 for mac?
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
Mar 8, 2008
I am starting to develop a website using CRE Loaded and the manual suggest that Beyond Compare, a code comparison program, is used.
View 1 Replies
View Related
Jan 11, 2009
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?
View 10 Replies
View Related
Aug 28, 2009
[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
View 24 Replies
View Related
Sep 3, 2009
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.
View 2 Replies
View Related
Nov 4, 2009
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?
View 12 Replies
View Related
Dec 14, 2009
How does it compare to SpeedDownload?
View 5 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
Feb 9, 2009
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.
View 2 Replies
View Related
Oct 26, 2010
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?
View 3 Replies
View Related
Jan 14, 2009
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?
View 24 Replies
View Related
Aug 12, 2009
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?
View 3 Replies
View Related
Aug 23, 2008
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).
View 6 Replies
View Related
Mar 11, 2010
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?
View 10 Replies
View Related
Apr 6, 2012
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
View 14 Replies
View Related
Jun 20, 2014
I'm searching for software that can compare two files and find differences.
View 4 Replies
View Related
May 26, 2008
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.
View 13 Replies
View Related
Sep 9, 2009
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.
View 4 Replies
View Related
Mar 5, 2009
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.
View 1 Replies
View Related
Jan 6, 2010
Update: You can read about my Experiences in 12 Hours here: [URL]
Update: You can read about my Experiences in 48 Hours here: [URL]
Download Coconut Battery and post your stats. Capacity only. Here goes mine:
MacBook Air - REV A 80GB HDD
Current: 4651 mAh
Original: 5090 mAh
Loss of: 9% Performance
Load Cycles: 186
Age of Mac: 20 Months
View 24 Replies
View Related
Jan 14, 2010
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?
View 4 Replies
View Related