excel2013

Please help, currently i'm working on a massive number of data (up to 50 000++). i need to separate or filter out the numbers which have only 3 decimal places into a new column as shown in the table below. is there any specific formula or advanced filter option in order to succeed this task ...

Hi everybody, I have a quadrant graph that contains 7 series, and I have been plotting XY Scatter points (starting at series 8 and increasing until the last of the data set is plotted) in the graph using VBA in Excel 2010. I now have one machine running on Excel2013, and the code that has run...

I have a combo-box, (using as a Dictionary lookup) which looks up a column of Greek text. When it is in the selction window, many of the characters show as ?; thus commonly the greek α shows as ?. When selected in the window the text looks ok, but once the user comes out of the combo box into...

Hi, We currently have users on both versions of excel (2010 and 2013). The 2013 user is using an addin that converts currency to text which is pasted below. We believe there is a compatibility issue or a security setting that i'm not seeing to make it work 100% on the 2013 user. here's what...

I have a file where the names of about 500 employees come up that have not taken a course. I have a total of 10 columns in the file with the information needed to send the employees reminders of the courses that need to be completed. Basically in column "B" we have the names of the employees and...

Happy 2014 to you all Hi I would really appreciate any help and/or guidance offered to hopefully resolve a custom rounding problem in Excel 2010/2013. The function will be applied to a results column containing numbers with two decimal places. For general layout please see Table 1 <tbody> E...

I have a large spreadsheet (~100 tabs) that gets data from an SQL server using SQL queries. I am about to run a Year-End on Sage (for the first time) and am concerned that this will screw-up the data in the spreadsheet. I know that I can open each Tab in turn & unlink, or Copy/Paste...

I have started to use Excel 2013 and got issue with circular reference which I never have had before. So there is 3 columns: 1. TOTAL SUMIF DATE: which counts totals for invoice if there is no invoice number but there is invoice date. formula...

I had run the following simple code in excel 2003 well, but when I open the file in excel2013, excel may crash. please give me ideas Private Sub WorkSheet_BeforeDoubleClick(ByVal target As Range, CANCEL As Boolean) ActiveWorkbook.Close End Sub the following rus well both in excel2003 and...

Hi The code I wrote to save a file with the last row counter and month counter looks as follows (this was working on my Mac) ActiveWorkbook.SaveAs FileName:= _ "Macintosh HD:Users:myratriegaardt:Desktop:Quotes" & M & ":Quote" & LastRow & ":QuoteHG" & LastRow & ".xlsm", FileFormat _...