Delete the content if it has complete set of data

**ccs_1981** · 11-15-2009, 11:10 PM

hi all,

good day.

i facing a problem here how to delete a data in 1 column.
i don't know how to explain, so i attach the excel file here to explain.

Hope can solve it.

Thanks.

**stanleydgromjr** · 11-16-2009, 12:47 AM

ccs_1981,

See the attached workbook "Create Summary - Countif Match - ccs_1981 - SDG10.xls" with macro "CreateSummary".

Detach/open the workbook and run the "CreateSummary" macro.

**ccs_1981** · 11-16-2009, 06:47 AM

Originally Posted by stanleydgromjr

ccs_1981,

See the attached workbook "Create Summary - Countif Match - ccs_1981 - SDG10.xls" with macro "CreateSummary".

Detach/open the workbook and run the "CreateSummary" macro.

thanks, but you already hardcode to 3 restaurants. anyways can solve it beside hardcode? i may hv more than 10 restaurants...

**ccs_1981** · 11-16-2009, 07:21 AM

anyone can help?

**stanleydgromjr** · 11-16-2009, 09:27 AM

ccs_1981,

How about another workbook with examples of "i may hv more than 10 restaurants...".

And, what is the logic for more than 3 restautants?

**ccs_1981** · 11-16-2009, 08:59 PM

Originally Posted by stanleydgromjr

ccs_1981,

How about another workbook with examples of "i may hv more than 10 restaurants...".

And, what is the logic for more than 3 restautants?

thanks for your reply, i thought u had hardcoded to max 3 records.

Please Login or Register  to view this content.

**stanleydgromjr** · 11-17-2009, 04:11 PM

ccs_1981,

thanks for your reply, i thought u had hardcoded to max 3 records.

That is correct, based on your original requirements, and examples in your attached workbook.

How about another workbook with examples of "i may hv more than 10 restaurants...".

And, what is the logic for more than 3 restautants?

**ccs_1981** · 11-18-2009, 04:04 AM

Originally Posted by stanleydgromjr

ccs_1981,

That is correct, based on your original requirements, and examples in your attached workbook.

How about another workbook with examples of "i may hv more than 10 restaurants...".

And, what is the logic for more than 3 restautants?

yes,
my data more than 3 restaurants may be from restaurant A to restaurant Z and so on. pls refer to the attachment i upload here. i cannot hardcode the data to 3. my question is how to check the total unique data in the column restaurant, if 1 of the meal has total restaurants, then remove the data. it means if it has complete set of data, just remove it.

**stanleydgromjr** · 11-18-2009, 05:08 PM

ccs_1981,

Now I finally understand.

See the attached workbook "Create Summary - Countif Match - ccs_1981 - SDG10.xls" with the updated macro "CreateSummary".

Detach/open the workbook, and, read the instructions in column K.