Search results

If I have got your query correctly.. then I think, a simple IF will also work.. Check the attached.. But, still curious to know.. how you want to use this .. in real life..

Hi Jack! Which cell you are talking about!! Did you unhide.. Column Q to AA in the sheet... Did you checked.. Which cell are having a Data Validation applied. Please give your 100%.. we are here if you are missing something..:)

oops.. I completely forget B-Search :( Thanks @shrivallabha .. for saving me from ruining my weekend.. I will upload a demonstrate file.. soon..

=IF(INDEX($AC$8:$AC$250,MATCH(Y8,$AY$8:$AY$250,0))=INDEX($AL$8:$AL$250,MATCH(Y8,$AY$8:$AY$250,0)),"YES","NO") Check closing parenthesis for Index Functions..

Hi Team, curious to know.. how VLOOKUP works.. or whats the flowchart to get the answer.. When data is not sorted. Range LookUp set as TRUE. https://dl.dropboxusercontent.com/u/78831150/2014-08-16_0933.swf

Excel has a rarely used, formula called "CONVERT", It help to convert from one unit to another very easily..

Hi Mike.. Themes and chart template are works great in this situation.. in case of vba.. please upload a sample file..

Wish you a very Happy Independence Day..

Just a funny way.. * View > Formula bar > Unhide. * Excel > Option > Advance > Uncheck "Edit Directly in the cell.."

Hi Bianca.. I have deleted your attachment.. as its property of chandoo.org.. I would request your to contact @vijaySharma or @r1c1 for the amendment personally..

Hi.. Target.. Can you please upload a sample file for the same..

I agree Narayan.. however.. somehow getting 9.9 only in 10 Survey.. and 9.5 in 70 Survey has more better quality... (as per our honorable visualization expert bosses) So they want to look both as a Quality measure.. I think its easy to create the requested chart.. then proposing them to...

OK in complete week.. (4th may to 10th may) we have received 111 survey results.. and average Score provided by customer is 9.00 (out of 10) So, Count is just a measure value to show.. how many customer has completed the survey.. Now Average is the Key indicator.. where target is 9.05...

Hi Hui.. as expected.. you gave me the clue.. :) after a lots consideration, I end-up with Area & Scatter.. Atleast its plotting both series in same gridlines... unlike our both above chart.. Still looking if you can able to change the Area (Count Series) to Column .. like below...

Here is another basic solution using chart.. :)

Did you tried.. Goal Seek.. In case of multiple parameter.. check Solver too..

Hi Team, Two parameter : CSAT Survey Count & CSAT Average Score, I want to plot Count as Column Chart (Primary) and Average as Step Line Chart (Secondary). So that I can show the Customer Satisfaction level more clearly. Just a glimpse below.. how the final chart should look like.. PS...

Hi hooman! Do you think.. your explanation is enough to understand for anyone.. :eek: Try again.. :(

Here is another tricks.. PS: in case of exclude 1st row.. In Advance Filter List range section.. start from Row 2..

Mr.. Redij.. A open handed congratulation to you.. Thanks for all your supports... direct & indirect.. :)

Lets double your bet.. :) =V10*(G10*(1-W10))

Hi Khalid, Did you checked.. my "C$17" and your "C17" has little bit difference.. :) So when you apply this formula in C6, it will check accordingly C17 ad when in D6, it will check corresponding D17. due to that $ sign. and Conditional Formatting check each cell in C6 to E6, and apply...

Hi Khalid, Select C6:E6, and apply Conditional Formatting > Formula as.. =MAX($C$17:$E$17)=C$17

Hi Ram.. Try this formula in Inser sheet .. B2 =INDEX('Main Database '!G$2:G$324,INDEX(MATCH(C2&F2&G2,'Main Database '!B$2:B$324&'Main Database '!E$2:E$324&'Main Database '!F$2:F$324,0),,))

Any sample file .. with expected output.. :mad: