Hi vletm, I need to sum Transaction_count till getting 46499 in each day like the first example that sum the values till getting 350 for each column,
so the expected result will be like below
I need help in building an evenly distribution model, as shown below I want to distribute the summation Total over the Days but keep giving every day only 300 and if the total cell is greater than 300 will fill only 300 then move the rest to the next day and vs if the cell is less than 300 will...
Hello Ashish,
I ask to compute attrition rate from two different data sources. I have 2 different sources:
1st: employee headcount (one row per employee) which has all employee details such as Name, ID, Date of Joining, Supervisor name, Department etc.
2nd: showing data for employees who...
Hello,
please, developers, I ask for help, I have a sheet called "CMS" contains columns from ("A1:BC"). I need to export these data into my SQL server from A2 till last indexed row.
I want to use this sheet to stock data into SQL DB as when I update the data then migrate it I need to be...
The problem centered in applying the formula for that huge range, I use that sheet as a template, I use it daily, each day I remove the old data then add the new day and surprisingly 700k row is for one day, so I need to keep the range with active formula as I can't Copy / PasteSpecial, when add...
Hi Marc,
I Know that VBA could replace the formulas function without high loading if the range is huge. I need to get the result indexed in columns [N] till [AA] via code instead of formulas.
for Access, is there is availability to create formulas like Excel
thannks
Hello there,
Please, I need help, as I have a worksheet with a huge range of data reach up to 700k rows and more and some columns which have a function. due to the long range, I can't apply the function, as the worksheet take a long time to load, or it crashes. So I search for an effective way...
hello,
please, I ask for help in how can I an empty cell which I will fill it with date value and have a table from two columns [Date] & [Comment].
I need to create two buttons:
1st: Insert comment >> I will fill the empty cell with date value >> click the button >> a text field form will...
Hello there.
Please i ask for an option for how can i control the chart bar manually to optmize the data source. i need to drag the bars up or down to control its data source easely. is that option is available in Excel?. if not? is there any other software provide that option.
Thanks alot...
Hello,
please, I need your support, I have a horizontal list of 2017 months, and I need to insert a scroll bar to alternate months and year.
the workbook contains a date-picker popped up with a double click anywhere, and as soon as I create the scroll bar I found, the date picker option goes...
Hello Chihiro,
I totally agree with you. but the survey wasn't based on ASA only, the ASA was just a question, and there were questions related to the product/service and other quantifications, but my team works on ASA plan, and how to optimise the service level and control the call center...
Hello,
please I need help as I have a data for a call center answering call survey, that survey set by a customer to get us his satisfaction grade about his waiting on Queue till call center agent answer his call, I have 4 Inputs:
Group of Customer
Average waiting time for customers on the...