• 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.

How do I...

E

emig100

New Member
I have an excel sheet with about 7K rows and 40 columns and I need to find some information in it. Each row contains a task for someone to complete. I need to find how many tasks each person needs to compete by a certain date.


Currently I'm using if statements to match the persons name, if it matches 1, if not 0. Then that's multiplied by an if statement that looks at if it's before the due date or not. Then another if statement doing the same thing for what type of task it is. Basically Im dragging these equations down 7k times and getting 1s and 0s then using a sum function. There are about 5 tasks so Im using 35k rows to just get 5 answers per person, I need a better function! PLease help!
 
Can you post an example of your relevant headers/data? I'm guessing you can either use a COUNTIFS or SUMPRODUCT function, but it's very difficult to write w/o some idea of what the data looks like.
 
Hi, emig100!


First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here.


As a starting point I'd recommend you to read the three first green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).


Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.


Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, you'll always be welcome back here. Tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.


And about your question...


I agree with Luke M that the structure of the worksheet with the 5 answers explained will help a lot. And maybe you can upload a sample file too, it will be better indeed. Please refer to second green post for uploading guidelines.


Despite of that, have you tried using the built-in Autofilter feature? If your conditions are not so complex, maybe it's suitable for your job.


Regards!
 
You must log in or register to reply here.
Back
Top