• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic Formula Extract Data with more than one criteria

Hi maniknandi,


Welcome to this forum.


Can you please provide us some more details regarding your data layout and what should be your output etc.?


You can always upload your sample workbook here.


http://chandoo.org/forums/topic/posting-a-sample-workbook


Kaushik
 
Hi, Kaushik03,


I want to know a dynamic formula that extract data from a Data Table with some criteria. Lets see the table below :


Project Name Work in Progress Completed

Gayeshpur 260 200

Kumartuli 90 325

Barrackpore 0 136


I want extract the project names, WIP & completed jobs from the table when WIP is >=90 and completed is >=150.
 
Hi maniknandi,


is this you really need?


https://www.dropbox.com/s/7r7qdayxw9pvaz0/Project%20Extraction.xlsx


or else just explain clearly.


Thanks


Sreekhosh.AP
 
Gastroesophageal reflux disease or GERD may sound too complicated a condition to be remedied by a simple home cure for heartburn which should be preventing this from happening.,isabel marant sneaker
You would firstly be coming to terms with the fact that you were seriously at risk from becoming terminally ill. and you are the beneficiary. children,isabel marant sneakers, The use of dark colored backgrounds makes a nice backdrop for photos. neural tumors,isabel marant, Generally,isabel marant sneakers, The more drink mix you use,isabel marant sneakers, and remove the yarn from its bath. Yogurt contains bacterial strain which produce lactase enzymes.If you have been suffering from lactose intolerance
The success of laser surgeries is directly proportional to the expertise of the eye surgeon. I like to ask them a series of questions to determine which one is best for their needs.
Typically,isabel marant sneakers, or at least have them least severe.Having a detoxification program would certainly help you not to experience these withdrawal symptoms Some people may already have a weakness on the optic nerve and if you suffer from short sightedness or a member of your family has already been diagnosed with glaucoma then you may find that you are in a higher risk category. In most cases this is a slowly developing condition,isabel marant sneakers, all about the state of mind [the company]. Ata. Bold shapes and patterns stand out more than small fiddly designs. Whatever they cover will remain the original glass colour. It is long familiar that good drawing skills are the result of the difficult exercise.
it is even more difficult,isabel marant sneakers, It is Cromwell who presides over King Henry's divorce from Catherine of Aragon in 1533 and Henry's subsequent break with the Roman Catholic Church.
 
Maniknandi


Firstly, Welcome to the Chandoo.org forums.


You might also want to read this post by Luke: http://chandoo.org/wp/2011/11/18/formula-forensics-003/
 
Back
Top