Search results

Good one Décio!. There are many ways to use function or formula, it is completely depends on user or formula coder

+ One more point. For a better formula understanding and accurate result, i would strongly suggest you to always use parallel range in all criteria. like you have used...

can you please upload sample sheet with required output.

Hey Sachar, You can use 3D reference using INDIRECT function, pFA

Also u need to make define formatting as per sheet2. This will be time take task

Yes, this is possible without using VBA, you can make name range and use offset or if condition to get data from range.

Hey DunnDunn, Firstly, welcome in our family. This is not excel related issues, I would suggest, please contact to your IT team or AntiVirus provider.

Little correction cell a2 =IFERROR(INDEX(INDIRECT("Data"&IF(ROW(A1)+1<=$E$1,1,2)&"!A2:A"&IF(ROW(A1)+1<=$E$1,$E$1,$F$1)),IF(ROW(A1)+1<=$E$1,ROW(A1),ROW(A1)+1-$E$1)),"") cell b2...

Please use sumproduct function

Can you please upload a sample sheet with required output. brief idea is to use =If(first_condition,1,snd_condition,2,thrd_condition,3,4) and put condition formatting using like =If(first_condition,1,snd_condition,2,thrd_condition,3,4) =1 then red color condition...

Which attachment you are referring, unable to find, can you please post complete formula or attach sample.

Please modify formula as per your requirement

Hey Davidator, First create unique list in separate column then create make dynamic drop down, please refer attachment

Hey FIFA, Firstly welcome to our family!. REPT function is use for repeats text a given number of times REPT(" ",32) with reference of above formula, the REPT function create " " 32 times. REPLACE(REPT(" ",32) with reference of above formula, REPT(" ",32) is the first argument of REPLACE...

in exception (error handing ) part add rename file current_file_name to current_file_name&variable_name and on top you can assign variable or store value somewhere in your wbook.

Hey Phanindra, Try below url, hope this works http://www.mrexcel.com/forum/excel-questions/635638-lock-report-filter-pivot-tables-excel-2011-a.html

Hi Jurgen, Please see if this is ok

Awesome NARAYANK, very good use of TRANSPOSE

Please see attached.

Wow Thanks Luke!!. Can you please share some useful links related to security. Once again Thank you so much!!..

=stdev/or any formula (if((range1=criteria1)* (range1=criteria1) ,output column)) with ctrl+sft+enter (array formula) you can add n numb

Nothing, Just shared the workbook :)

File uploaded, please check

Hey Masters, Just curious to know about few things - Is there any way to delete protected module if aware of module password (but wanted to delete using another macro) if unaware of module password How may type of excel workbook password security Is there any way to understand the...

Hey Abdullah, Firstly, welcome to our family!!. This is not easy and quick task to resolve, would suggest you to please go thru blow urls and let us know if need any help after this. http://www.onlinepclearning.com/excel-userform-login-form/...