IF a cell is marked, then copy row to "Master List"?

**NCivitarese** · 04-13-2015, 06:14 PM

Hi guys,

I'm trying to come up with a special attendance sheet. It's pretty straight forward, except, if a particular row is marked with a * (or some other value), then I'd like that entire row to be copied over to a master list.

I've uploaded a screen shot to help illustrate what I am trying to do.

In a nutshell, it's a regular attendance list with the ability to mark a particular row as "requesting extra help", and then carrying over that row over to a "Master List' of people who requested a follow up.

Is this possible?

**AlKey** · 04-13-2015, 06:23 PM

Try this array formula
in E2 and pull formula to the right and then down

=IFERROR(INDEX(B:B,SMALL(IF($A$2:$A$10="*",ROW($A$2:$A$10)),ROWS(B$2:B2))),"")

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Row\Col	A	B	C	D	E	F
1	Criteria	Name	Server		Name	Server
2		Adelphia Cable	mail.adelphia.net		Ameritech (SBC Yahoo!)	pop.ameritech.yahoo.com
3	*	Ameritech (SBC Yahoo!)	pop.ameritech.yahoo.com		AOL	imap.aol.com
4		AT&T WorldNet	postoffice.worldnet.att.net		BellSouth	mail.bellsouth.net
5	*	AOL	imap.aol.com		Charter	pop.charter.net
6		Bell Atlantic	pop.bellatlantic.net
7	*	BellSouth	mail.bellsouth.net
8		BlueLight	mail.bluelight.net
9		Cableone	mail.cableone.net
10	*	Charter	pop.charter.net

**NCivitarese** · 04-14-2015, 04:26 PM

Thank you so much AlKey. It worked like a charm. I noticed your signature and clicked add reputation.

Thanks again.

**AlKey** · 04-14-2015, 04:35 PM

You're welcome and thank you for the feedback!

Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools -> Mark thread as Solved).

IF a cell is marked, then copy row to "Master List"?

LinkBack

Thread Tools

Rate This Thread

Display

IF a cell is marked, then copy row to "Master List"?

Re: IF a cell is marked, then copy row to "Master List"?

Re: IF a cell is marked, then copy row to "Master List"?

Re: IF a cell is marked, then copy row to "Master List"?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macros help - when cell marked with "X"

[SOLVED] Copy contents from "Child" file to a "Master"

[SOLVED] What can stop a cell from being marked "Dirty"?

Options marked with an "X" listed in a single cell separated by commas

create links to check boxes marked "good" fair"and "bad"

Bookmarks

Bookmarks

Posting Permissions