objective

Dear all, I am Stuck in this. Please Help I want to restart the running total of column 'A' in column 'B' if the value in condition column 'C' is more than 0. the required result is shown in objective column 'D' <colgroup><col><col><col><col></colgroup><tbody> A B C D Data Runnnin TOTAL...

Hi All, I have the following data: <colgroup><col width="100" style="width: 75pt; mso-width-source: userset; mso-width-alt: 3555;"> <col width="66" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2360;"> <col width="183" style="width: 137pt; mso-width-source: userset...

Hello, I receive an auto generated sheet every day in which multiple lines are combined in only one cell. Every line ends with either ' or ). My objective here is to get each line in different cell. How can I get this done? Will split() be useful in this scenario or is there any other way...

SQL View: a view created from SQL query from different tables Unpivot SQL View: and unpivot version of table created in point 1 through power query Report : Desired presentation Objective: adding contribution column next to sales column where contribution is total sales - total prime cost...

Hi, My objective is to produce a list of all the numbers of three non-similar digits which do not contain digits 0, 1 & 7. May you please advice. Thanks.

Hello guys, i have table with different projects on each row. i need to create a sheet for each row/project mantaining the title row and naming each new workbook as the project name. Is there a way to do it in vba, im really new to this :/ Example: Original workbook ProjectCode ProjectName...