Search results

Hello NARAYANK991, That's it. your formula works perfect without array. Thank you very much :) regards, Biray

Hi Hui, thanks for your post about scheduling in chandoo.org. it's also important source for me several years. In my file, what i need was to have a formula which sums shifts by day. So, i cropped other parts which calculate how much each source. i added my formula to calculate this. you...

Hello Stephen, your udf works for EJ3 unfortunately, it gives wrong results for other cells; for example, for july 8, for product1, total had to be zero, but it calculates "3" which sums all july 8th shifts (all rows) i think there has to be some correction in the udf. i also added...

Hello, i'm making a shift schedule planning sheet. As you can see in sample file ( http://sdrv.ms/12IKf2w ) i have product names in rows, dates in columns and shifts in columns grouped by dates. If there is work planned, i'm putting 1 in shift cell.(ie AF3) then, in other part of...

Hello, when i try to copy a sheet from xls workbook (excel 2003 file) to xlsx workbook (excel 2010 file), excel 2010 is crashing. When i move, it makes, no crashing. is this a common problem? or is there a solution for this? regards,

Hello, i have a table which shows distributors (140 dist) sales shares by months. i want to calculate number of distibutors whose total share reach 80%. but i couldn't write appropriate formula to do this. can you help me? table like this distributor 1 2 3 4 5 6 dist a 10...