How I move data to another tab if criteria met?

[Saint Nick]

I have a list of controls with each control rated 1 to 3. I have 3 tabs labelled 1, 2 and 3. Based the number given to each control, I want that control to appear in the corresponding tab. Any ideas?

[:) Sixthsense :)]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Saint Nick]

Here you go.

I have changed the "controls" to tasks and changed "rating" to owner. The outcome is still the same.

[:) Sixthsense :)]

In A2 Cell of Owner1 / Owner2 / Owner3 Sheets - Array Formula - Requires CTRL+SHIFT+ENTER

=IFERROR(INDEX(Tasks!A$2:A$16,SMALL(IF(Tasks!$B$2:$B$16=RIGHT(REPLACE(CELL("filename",$A$1),1,FIND("]",CELL("filename",$A$1)),""),1),ROW(Tasks!$B$2:$B$16)-ROW(Tasks!$B$2)+1),ROWS($1:1))),"")

Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.


Drag the formula's down and right...

[Saint Nick]

Thanks for this.

Would you mind breaking down the formula? I need to apply it to another spread sheet.

[Saint Nick]

I have tried to apply the same formula to a different spread sheet but it does not work. I have attached an example of the excel file I want to apply the formula to. Basically it’s that same process as in the first example I sent. I am a bit of a novice with this type of formula so any layman translations are appreciated.