| Thread | Last Post | Replies |
|
| Find Duplicate in a Row | 23 May 2008 19:46 GMT | 8 |
Here is my dilemma…..I am using Excel 2007. I have a spreadsheet with 17,3322 row of data that spans to Column W (A2:W173322) excluding the header. I am trying to do conditional formatting to bring to light the duplicate values that are identical across the row and highlight
|
| EXCEL 2007 Right clik options not working | 23 May 2008 19:40 GMT | 6 |
"When I right Click in a cell, then click on "Format Cells" nothing happens. The other "..." options show options to choose from, but "Format Cells" does nothing! Can someone help me, PLEASE!
|
| Excel 2003 vs Excel 2002 | 23 May 2008 19:12 GMT | 2 |
Can I open and work on a excel 2003 spreadsheet on excel 2002? Please Help I hate to buy excel 2003 upgrade.
|
| document not saved | 23 May 2008 18:17 GMT | 1 |
i have created a single sheet template. Whenever i insert this template (by clickking on the tab-insert- template) and save the file, the file is not getting saved. it is saying "Document not saved"
|
| Excel Formula from one workbook/worksheet to another | 23 May 2008 18:06 GMT | 3 |
I have entered formula =('L:\Quality Improvement Projects\2008\[2008 Advanced Directive Monitor.xls]Summary by Provider'!c10) It does not bring the information from worksheet Summary by Provider to the
|
| Trying to average col c if col a = "value" and col b = "value2" | 23 May 2008 17:47 GMT | 1 |
I'm having a hard time sorting the format of the formula out - any assistance is appreciated.
 Signature MBS
|
| linking cells from workbooks in a folder | 23 May 2008 17:37 GMT | 3 |
I am trying to create a sheet that will sum all the values from a given cell reference from each workbook contained in a particular folder, the workbook names in the folder change and the number of them varies as they are moved to another folder when finished with. The cell ...
|
| Compare the Cell between + or - value | 23 May 2008 17:14 GMT | 4 |
Good evening, I need to compare(look up ) the value in cell A and cell B (plus or minus of the value in cell A) and put the result in cell c "false " or "true" Ex :
|
| Sumproduct & Numbers | 23 May 2008 16:46 GMT | 4 |
I have a spreadsheet where I have 2 columns of numbers and am trying to use SUMPRODUCT count paired cominations. Each person has a score Rating & Score of 1, 2, 3 or 4 The database looks like this:
|
| How do I remove non-numerical charaters from a string? | 23 May 2008 16:30 GMT | 3 |
I have data formatted like 038-1439-00 and I would like to remove the dashes so that the cell reads 038143900. Is there a formula in Excel that can strip out the dashes?
|
| Compare 2 columns and align duplicates into same row | 23 May 2008 16:16 GMT | 3 |
Hi Im trying to sort out my email list. After doing a mail out to the list of 1500 I found that about 220 had bounced. I am now faced with trying to link up the bounced emails to the
|
| How to get YTD Summary | 23 May 2008 16:08 GMT | 4 |
Hi, I have a 12-m sales number. I know it is easy to get MTD number by using vlookup, but is there a way to get YTD number when month changes? For example, if I use a cell to input month, then use vlookup to get a
|
| I want to key numeric values in one row like a1 and total them in | 23 May 2008 15:19 GMT | 1 |
I have a report that the numbers change daily with people who key info in, I want to track their efficiency, so I want to enter the daily number in the same row like a1, b1, etc. for every day of the month and I want to tabulate that in row 2 , a2, b2, etc. because I have so ...
|
| Why would someone buy a microsoft product? | 23 May 2008 15:16 GMT | 3 |
I was trying to auto-increment dates in Excel when I realized this was the least intuitive program I have probably ever used in my life. I could write C-Code that would allow me to do it just as easy. Why am I forced to exchange data in excel format? Am I going to have to make ...
|
| tax status in payroll | 23 May 2008 15:10 GMT | 1 |
what is the tax status in payroll sheet
|