No announcements

### how to sum values in same cell

Hi, I have values in excel cell separated by "," . how can I sum up them ? please help. regards
| 1 Replies | 11 Views | Created by drsantoshsinghrathore - 4 hours 42 minutes ago | Last reply by Hans Vogelaar MVP - 1 hour 26 minutes ago

I have data in column A1-A10 and B1-B10. I want to add A1 + B1, and also add A2 + B2, and also add A3 + B3, etc, so I will end up with 10 answers. I also will ...
| 1 Replies | 93 Views | Created by Bart-p - 3 hours 58 minutes ago | Last reply by trip_to_tokyo - 3 hours 29 minutes ago

### Conditional Formatting Problem with random input.

I am using conditional formatting to compare two cells and change the color of the cell if the contents match. The cells I want to compare both use a formula based on the same (randomly generated) ...
| 3 Replies | 45 Views | Created by fluti314 - Tuesday, September 27, 2016 11:36 PM | Last reply by fluti314 - 4 hours 40 minutes ago

### Calculate a percentage based on the sum of that same percentage

Hi, I have a situation where I must calculate a percentage based on a total that included that same percentage. I have a based price of 1000\$ and I need to add a ...
| 5 Replies | 65 Views | Created by Samuel Boulanger - Wednesday, September 28, 2016 11:05 AM | Last reply by Ethan Hua - 5 hours 23 minutes ago

### Excel Hyperlink Dependent on Cell Value

Hello everyone.  Hoping I can get an answer here. I am trying to get a hyperlink to work that changes based on cell value. For example, ...
| 2 Replies | 29 Views | Created by Brent1837 - Wednesday, September 28, 2016 4:54 PM | Last reply by Winnie Liang - 8 hours 20 minutes ago

### Excel shows error when trying to open

Hi, One of my users has this error when he try to open an excel sheet, any idea what is it? After my user click okay, he can still proceed to use it. But why is it ...
| 1 Replies | 32 Views | Created by Joshtechsolutions - Wednesday, September 28, 2016 10:04 AM | Last reply by Winnie Liang - 8 hours 40 minutes ago

### Pivot table filter not working

Hi, I created a pivot table and I am only using rows and values. I don`t have anything in my filter or column area.  One of the names in the rows is ...
| 2 Replies | 30 Views | Created by smilja_erak - Wednesday, September 28, 2016 2:10 PM | Last reply by Winnie Liang - 10 hours 8 minutes ago

### Minus or Plus days in date

i have following dates design target  design actual date  delay days  costing target   actual ...
| 2 Replies | 73 Views | Created by Dwarkanth Bari - Sunday, September 18, 2016 9:45 AM | Last reply by Ashidacchi - 11 hours 46 minutes ago

### Max Date using recursive function

=25-Apr-2016, date
| 1 Replies | 18 Views | Created by karthick_s09 - 13 hours 56 minutes ago | Last reply by Asadulla Javed - 13 hours 14 minutes ago

### Excel crash when adjusting margins in Print Preview Full Screen

1. Start new workbook in Excel. (No other apps running) 2. type in a value in a cell. (not needed to reproduce error) 3. Set print area. (not ...
| 10 Replies | 342 Views | Created by Richard Nuttall - Tuesday, September 06, 2016 9:05 AM | Last reply by Paul D CPA - Wednesday, September 28, 2016 6:23 PM

### Manipulating excel data to make a login card for 3rd graders

I am a librarian at a public school.  I would like to make login cards for the over 500 students in my school.  Can anyone figure out a way to manipulate this data?  Please see my ...
| 2 Replies | 51 Views | Created by Librari-Ann - Tuesday, September 27, 2016 7:30 PM | Last reply by Emi Zhang - Wednesday, September 28, 2016 9:56 AM

### Excel 2010 Help. =IF calculation result changes based on location of data?

3.5,"CRITICAL CONCERN",IF(((D4:D5*10)+(E4:E5*4)+(F4:F5))/15/C4:C5>2.5,"MODERATE ...
| 3 Replies | 49 Views | Created by startzc - Tuesday, September 27, 2016 12:27 PM | Last reply by Emi Zhang - Wednesday, September 28, 2016 9:26 AM

### Excel 2013 errors after upgrade to Windows 10 1604

I'm experiencing this issue on all computers that upgrade to Windows 10 1604. If I roll them back I'm not getting the error. Please help!!!
| 1 Replies | 40 Views | Created by Boltwebster - Tuesday, September 27, 2016 10:40 PM | Last reply by Emi Zhang - Wednesday, September 28, 2016 9:21 AM

### In Workbood Queries - what is the yellow triangle with the "!" trying to tell me?

I have been seeing a yellow triangle to the left of the query title ... it then goes away after a period of time ... what is it trying to tell ...
| 1 Replies | 33 Views | Created by SteveWagner-291 - Tuesday, September 27, 2016 3:24 PM | Last reply by Emi Zhang - Wednesday, September 28, 2016 9:03 AM

### 'Refresh Every' option grayed out

Hi, I 've exported data from a SharePoint list to an Excel file. That excel file got the connection string of SharePoint list. Now, when I do refresh it refreshes ...
| 1 Replies | 59 Views | Created by Radhai - Tuesday, September 27, 2016 6:00 AM | Last reply by Celeste Li - Wednesday, September 28, 2016 8:55 AM

### Excel Tables vb Create / Delete ?

Hi, I have a table in excel, header row 2, however working with the data in the cells is a pain, i.e. sometimes pasting data in several rows doesn't always work. What I would like is vb code I could ...
| 2 Replies | 36 Views | Created by Paul from Leeds - Tuesday, September 27, 2016 3:08 PM | Last reply by Emi Zhang - Wednesday, September 28, 2016 8:51 AM

### formatted colors on screen in Excel and Word don't show on screen but do print when printed

After updating to Windows 10 when using Excel and I want to have a color on a line for highlighting, I change the color from the formatting drop-down but it doesn't show on the screen. Yet when the ...
| 2 Replies | 109 Views | Created by Gerrylaptop - Monday, September 26, 2016 11:28 PM | Last reply by Emi Zhang - Wednesday, September 28, 2016 7:39 AM

### MS excel file: Link location on the cell are repeated

Hi, I have a problem on my excel file running on our MS Terminal Server 2003 R2 and in MS Terminal Server 2008 Standard. When I opened my file on our MS Terminal ...
| 0 Replies | 34 Views | Created by frostmir - Wednesday, September 28, 2016 1:38 AM