Help Needed, is a check list possible.

**GAVGAV27** · 02-10-2013, 01:30 PM

Afternoon All,

I was wondering if anyone knows if there is an easy way for me to do a check list with-in a spreadsheet.

For example if I have an column full of item codes is there away to type in the codes somewhere as we check them off and then when we are complete it would list the items that have not been checked off or list any extra that have been entered.

It would also be good if the qty could be entered and it would list any shortages.

No idea how this can be set up, your help and thoughts would be greatly received.

Gavgav

**Ace_XL** · 02-10-2013, 01:46 PM

Something like this..

**GAVGAV27** · 02-11-2013, 06:18 PM

Thanks for that, that would work, is there any way were it is possible to not have to do a separate list but just type the codes into a one dialogue box and hit enter or something and that would list them all. your solution is great and would definitely do the job but some of the lists i need to get people to check are 900-1000 lines long if they could just enter the codes rather than entering 900 lines that would be amazing.

**GAVGAV27** · 02-12-2013, 09:04 AM

Hi Ace,

Once all the items have been checked is there a way to pull all the codes that are missing (have a false next to them) into a separate summary sheet, I know you could just filter the column but it would be good if they were just listed on a separate tab.

Thanks for all your assistance so far.

Gav

**Fotis1991** · 02-12-2013, 09:48 AM

In A2 of another sheet, put this ARRAY formula and copy down. You can use the if(iserror(as you work on Excel 2003) to get rid of #n/a values.

=INDEX(Sheet1!$A$2:$A$1000,SMALL(IF(Sheet1!$B$2:$B$1000=FALSE,ROW(Sheet1!$A$2:$A$1000)-1),ROW(Sheet1!A1)))

**GAVGAV27** · 02-12-2013, 06:17 PM

Thanks for the formula but it does not seem to work fully and i am sure that is my fault somehow, I have attached the sheet with the codes in i would be using and the formula does not drag down and it also lists codes that have a true value.

any ideas what i doing wrong.

Thanks

**Fotis1991** · 02-13-2013, 02:42 AM

You use this formula that i suggested.

=INDEX(sheet1!$A$2:$A$1000;SMALL(IF(sheet1!$B$2:$B$1000=FALSE;ROW(sheet1!$A$2:$A$1000)-1);ROW(sheet1!A1)))

1) This formula is looks in column B to find any FALSE values. BUT in your last sample workbook FALSE values are in column C of your first sheet.

2) When you use an ARRAY formula, you have to confirm using Control+Shift+eNTER. nOT JUST eNTER.

You have to use formula like this.

=INDEX(sheet1!$A$2:$A$1000;SMALL(IF(sheet1!$C$2:$C$1000=FALSE;ROW(sheet1!$A$2:$A$1000)-1);ROW(sheet1!A1)))

Also i did a slight modification in formula of column C.

=IF(A2="";"";ISNUMBER(MATCH(A2;F:F;0)))