How to delete duplicates?
Sat, 20 Mar 2010 10:59:46 -0700
Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have a Bulk email software that can easily identify duplicates in a file.
So I know this can be done
What I'd like to do -- is this possible? (and maybe all within Excel)
Find duplicate emails and then delete the dupes out?
( ...
|
Ledger sheets
Sat, 20 Mar 2010 08:05:12 -0700
Operating System: Mac OS X 10.6 (Snow Leopard) We've created a custom ledger sheet that we need to set up for each month. However, when we try to create a copy, it will not work. We have contacted an Expert and he could not figure it out. We always get a message to report the problem which we have a dozen times, but n ...
|
Updating Links
Fri, 19 Mar 2010 17:49:02 -0700
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I've asked before without a reply: I have 13 workbooks (not sheets) linked to a 14th summary workbook. I have created the links to each of the 13 with properly referenced formulas in the 14th. Every time I do an Links>Update I am told that t ...
|
vlookup is reporting 0 when I want it to show a blank cell
Fri, 19 Mar 2010 17:06:11 -0700
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi,
My vlookup formula is giving 0s when it encounters cells I've left blank my table. I'd like to know how I can get it to provide blank cells when it encounters blank cells.
Here's my formula string:
=VLOOKUP($C506,'Threats &am ...
|
How can I do this? Is it possible with Excel?
Fri, 19 Mar 2010 08:35:51 -0700
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Not sure if Excel is the right program for this, but here's my question.
I have a work schedule, size is 7 columns, 30 rows. Each cell contains a single word name. I would like to have a legend, or small side grid, containing a vertical ...
|
excel highlighting emails
Fri, 19 Mar 2010 05:31:12 -0700
Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel I have a column labeled email addresses on my spreadsheet, but I do not want them to be highlighted. SOme highlight and when you click on it to make a correction it automatically goes to an email form, which I do not want. Some email addresses do n ...
|
Zero Values - vlookup
Thu, 18 Mar 2010 19:50:19 -0700
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel When using Vlookup i get #NA returned in cells that have a number with a 0 in front. ie: 04011 returns #NA. I then try and type the number 04011 in the cell and find the 0 vanishes but the correct Vlookup result is returned.
I need the 0 to re ...
|
|
|
How does excel note a newline (ie new line but in same cell)
Thu, 18 Mar 2010 18:35:52 -0700
Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Hi
Have legal transcription i need to manipulate partly in excel on mac. want each cell to be one question or answer in deposition, but can't allow excel to wrap the text of the question or answer, which is typically several lines, as in depos ...
|
Editing the contents of a cell
Thu, 18 Mar 2010 16:57:34 -0700
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel In previous editions of Excel the cell editing was different. Say I were working on monthly expenses and a cell represented that month's accumulated costs for groceries. As the expenditures became known you would simply enter that cell and i ...
|
Conditional Formatting
Thu, 18 Mar 2010 14:38:46 -0700
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I am using Microsoft Office 2008 and I am trying to use the conditional formatting in a basic worksheet to display negative items with a different background color, but i can not seem to find the conditional format button anywhere. I am a very green mac user ...
|
