Notepad++, place grouped data into separate columns

I have data sets that have one column with several data IDs and another column with the corresponding value of all those IDs. So imagine some data on notepad++ that looks like this: ID:123;ID:456;ID:789 12 How would I separate the data so the output would look like: ID:123 12 ID:456 12 ID:789 12 I’m using […]

Index(Match( on multiple criteria (Column D or Column E)

I’ve been trying to solve this for a few days in excel. I have an Access table connected in the layout shown below: This has thousands of rows of data which I would like to filter/Index(Match( by 2 different columns. I need this to meet the criteria of: IF Sheet2!A1 = Column D or Column […]

Scrolling table + Conditional formatting = Unstable

I made a Gantt graph with a “Scrolling table”, which is basically a 11×12 table with a vertical and horizontal scroll (Offset method). The issue appears when I want to add conditional formatting to this table, the scroll go crazy and move by their own will. Does anyone know how to prevent this and actually […]

Exporting a text file in rails with the data in model

I got some 5 field in my model named “Data” in a rails application say – Name, Age, Place, Country, Marks. I want to get that data in an text file in the below format Name : Lokesh Age : “20” place :xxx country : yyyyyyy marks : “90%” Name : Ramesh Age : “23” […]

Excel – Formula to sum sequentially but only add like employees

My manager needs to know when her employees (EE) are reaching overtime. There are 80+ EEs on the job site so it is crucial for her to be able to see what day the EEs reach 40 hours. Once I get the Sequential Sum by employee column figured out I will add on straight time […]

How do i randomly select more than one item from a list in excel?

How do i randomly select more than one item from a list in excel ? For example:- Column A Column B Itemcode Quantity COM#004 2 COM#005 3 COME001 10 COMT000 3 COMT001 3 COMH000 1 COMH000 1 COM#006 2 CT100H000 1 Inputs:- the number of item to select for example :- the number of item […]

Import multiple Excel files to create 1 table in SQL Server 2012

I have a few experience in using SQL Server 2012. All I know to import a excel to database is like the following: open SQL Server Management Studio right click on the “table” folder -> Tasks -> Import Data set data source to MS Excel. It seems that only one Excel is entertained. But I […]

Attaching files to email

Evening I’m having a bit of trouble with some code bugging out and I cant figure out why. Sub Send_Files() Dim OutApp As Object Dim OutMail As Object Dim sh As Worksheet Dim cell As Range Dim FileCell As Range Dim rng As Range Dim strbody As String Set sh = Sheets(“Emails”) Set OutApp = […]

Complex Interest Calculator Excel – Variable Payments, Variable interest rates

I’ve searched for a while on this topic, but any keyword “interest” just seems to override the others so you get nothing useful. I’m trying to create an interest calculator which takes account of: Key factors of the debt (PrincipalAmount, PeriodStart, PeriodEnd) Variable and uneven payments (stored in a table of ReceivedAmounts and ReceivedDates) Variable […]

Issue when trying to look for any of the strings contained within a string array inside another string

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; using System.Reflection; using Microsoft.Office.Interop; using Excel = Microsoft.Office.Interop.Excel; using Microsoft.VisualBasic; namespace CheckList { public partial class AdHocChecker : Form { // declaring variables private string _file = @”D:\test.xlsm”; Excel.Workbook wkb; Excel.Worksheet sheet; private int _columnToCheck; private string […]

MS Excel Spreadsheet is the best Office Software, Excel VBA and Excel Formulas make Spreadsheet work faster.