Search results

Congratulations Deepak!!

Dear Thomas, You are always welcome. Keep visiting.

Please put this formula in D19 with Ctrl+Shift+Enter and drag to left =SUMPRODUCT((D10:D11*'Data Validation & Input Sheet'!$J$3:$J$4))+SUMPRODUCT((TRANSPOSE(D13:D15)='Data Validation & Input Sheet'!$G$3:$G$9)*('Data Validation & Input Sheet'!$H$3:$H$9))*D12

Hi Thomas. Please see attachment

Hi Thomas Please see if computation in row 18 is correct.

Just one more question. When you need to use Price1 and when Price2??

can you post the sample file giving error.

This will not make any difference. Please test it. Now what we need to with D17 it has already a formula.. Sorry i lost focus.

Hi PSG, I just tried on sheet 2, even if you copy from it and paste on sheet1 it is working. can you verify it?

Hi PSG, Please see attachment Source: http://superuser.com/questions/321131/color-text-content-contained-within-brackets

Hi Thomas, Please check values in Row 18 (yellow highlighted), i have tried to create all cases (1-7) with requirement of D10+D11, have a check if the results are correct. then we can move to the next step of retrieving values. For next step i can't find the value in your Data Validation &...

Dear Thomas, Sorry for delay, i have some reservation and you can find details in attachment. I have made and table and tree diagram that will help you understand the scenarios/cases.

Thanks for feedback. Please point out what is different in the original and my attempt besides the tilted lines. I will try to improve it.

Please see attachment if it works.

Can you post the actual chart also that you wan to make? It will help alot.

Hi All, The subject matter is called "Market Basket Analysis", i found a complete tutorial of how to do it on excel here: http://people.revoledu.com/kardi/tutorial/MarketBasket/ hope it helps, but in my opinion it is tedious and cumbersome, i suggest you should use something like SPSS so that...

Shahrukh can you post a sample file.

Please try this: =LOOKUP(MATCH(D12,$D$12:$D$49,0),{0,5,12,16,28,35,50},$C$3:$C$8) Where D12 contains the sub category

Asalam o alikum Qayyum, Can you elaborate further how your data is organized so that we can proceed. i am interested in this dashboard assignment.

Hi Joy, Do you have any specific layout for your sheet?? Here is a link to one of call center dashboard i found http://exceldashboardschool.com/excel-kpi-dashboard/customer-kpi-dashboard-excel/

Please see attachment. i guess your first two requirement for all blank cells is fulfilled. Now please explain for the last one . There are three cells D12, D13, d14, what you want them to do. Can you give me an example with correct result for the last calculation you are doing.

Dear its 12 am here so will (hopefully) revert tomorrow.. Gud Night

Please see attachment does it works, can you elaborate the last requirement further.

Do OP want current date to be followed by time or any date entered in a cell be followed by time? I think he just wants to knew when a certain date is entered a cell.