Search results

thanks a lot, it works like a charm

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

could you please help me with this formula Peter

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...

sorry, I got the issue of date picker option going away root cause, then got the way to alternate months via scrollbar

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...

I see the values has been changed, it must be figured out like column H, but without duplication, just keep one of duplicated values then blank the others

Hello there, please, I need help as I have a column which has a duplicated values within Date Range, that I keep one value then blank the other duplicated value at the same day. I used a simple function at Column I, but it needs to keep columns sorted

Hello @vletm please I need your support at the sheet, as you remember the project based on 2 short Breaks with Red color and Lunch with yellow color, but I added an Extra Break with pistage color which I need to get its scheduled frame time and actual duration as used for the other Breaks. But...

yes vletm, I got your idea, i made a little modification at data range, then try to apply the code, but an error occurred, i need to fill the output at range ("BX5:CC") thanks a lot for your brilliant code, it saves a lot of wasted time anf effort for me :)

Hi @vletm sorry to back, your code does the function well but I'd noticed that it starts counting the number at the beginning of the colored cell then its next, but what if the previous colored cell have values e.g at row8 >> 1st Break, it should start from 11:14 till 11:29, because there is...

it works like a charm, thanks a lot vletm

Hello Vletm, |: we can overlook the minutes' fractions. ||: About solving breaks, every agent must take his breaks as scheduled, he must not Leads or lags his break, as I have the datarow of Scheduled breaks for every agent and in getting the Actual, i'll subtract the Actual from the scheduled...

the exported data is just the names and their such Breaks start and end

it's not a must for me, but if you will fill the output to another worksheet, I need the names at column A beside the output

Hello, please I need your support at an inquiry which somehow complicated, en recap, as shown, this is a shift schedule with breaks for employees, e.g: the first agent Red color is the 1st Break start: 11:15, end 11:30 >> Duration "0:15:00" Yellow color is the Lunch Break start: 12:30, end...