Ok, I can't quite get this figured out. I am trying to auto populate data in one sheet using a dual column criteria from a master sheet. I have attached an example. In this example I would like to take all rows that meet the criteria of say "Cowart" in column E when the criteria of say "Progressing" is also met in column C in that same row. If those two criteria are met I want to auto populate that entire row of data to the 2nd sheet labeled progressing.
Any help is greatly appreciated. If I am pointed in the right direction I should be able to figure it out if given an example. Thank you in advance for any and all help!
Last edited by Hydro215; 02-10-2012 at 04:59 PM.
Hi and welcome to the forum
One way to do this, is using IF(AND functions and then Auto filter.
You put the same(almost)formula in second row and then copy down.
In A2:
=IF(AND('Global List'!C2="Progressing";'Global List'!E2="Cowart");'Global List'!A2;"")
Then you use Auto Filter.
Hope to helps you.
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Ok, I get it thank you. However I am not not having luck doing this in Google Docs....darn google. I can reproduce it as I wish in Excel though. Thank you for your help! I have to hunt down this type of task in the google docs world.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks