Search results

@SirJB7 This is my mistake - we can unprotect worksheets and not workbooks with open office. Sorry for the confusion.

Can you post some sample data?

Simply open it in open office and un-protect.

This should work if you have name of folder same as that name of emplyee. Simply put the path againt against eath empolyee name with final folder name taken from the "Name" Column and use HYPERLINK() formula. See attachment.

Congrats@Nebu

..What if there is a tie for a position?

Please see attachment should that work for you.

Kindly explain what do you mean by dynamic...

Please see attachment.

Hello Pardeep, I think that frequency of stoppage is the sum of the stoppages by X and Y? This seems true for May, but not for April, can you check plz. I think a stacked bar chart is what you need. Let me attempt.

Sorry for replying late, today was a busy day at office. Plz see attachment, avg values of individuals over time. I have been unable to understand your first idea, can you explain it?

Please see attachment

Thank you. We can create two more charts: person vise closure and level vise closures. Any thing else you can suggest.

Hello, Glad it is helpful. Please see the chart for analysis of effort level against standard and avg value. We can create a dashboard (sought of). You need to select the effor level from R20

Hello Frank, I used Col L to filter out unique names from the list, you delete it if you want. BTW was that sheet helpful or was just another sheet? Is the averaging method correct or you were looking for something else? :)

Arun's formula is correct. please stick to it! Thanks @Arun

..should you stuck somewhere as you try to understand it, kindly let us know! :)

Try this with CSE: =SUMPRODUCT((A2:A7="Apple")*(SUMPRODUCT(((B2:D7="Green")*1))>0)*1)

Please see attachment. Hope it works for you.

Please see attached sheet: Hope This helps.

Please try this formula: OFFSET(INDIRECT("D"&MATCH(H5,$D$6:$D$29,0)+6),0,0,MATCH(I5,$D$6:$D$29,0)+5,1) With ctrl+shift+enter

@xltime Please see this: ...I replied to this question: http://forum.chandoo.org/threads/protection-tab-of-the-format-cells-dialog-box-is-not-appearing.5571/ Hope that helps. :)

Hi @philbill Good evening from Karachi, Pakistan. :) I have changed the layout a little to a more concise one. Please see attached sheet. It gives value of 27.77 with given criteria (vouchers, weighted avg, voucher per person) this is just a try please point if i have missed something.

..Sorry for replying late, sure, i will share the screen-cast or you tube link. :)

Hello, Optimization problems comes with a statement of whether you want to minimize or maximize certain quantity. Can you elaborate your problem in this context. What do you want to minimize/maximize and how your vouchers and other quantities are related.