Automate missing cell value report

[queysoft]

Hello. I have a worksheet A. It has about 25 columns and the rows are added to daily as new information is entered. Some of the columns are important IF one of the columns is populated with the word "BLUE" (this is important, as not every row of data will need every column filled out if one particular column has the word blue in it. People can forget to fill in the information for that row. I can find the missing information by filtering, but I want to be able to create an automated report. I ideally want a report that i can run that has the the same header columns as the important columns in worksheet A and shows any rows that have blank information - it can use the serial number in column A as a reference.

so, for example - the master sheet A has 25 columns called A to Y. Column B, C, F, G and J are important. If column L has the word BLUE in it and column B is blank then i need the report to show the serial from column A and also something like the word "missing info" for column B.

any idea?

 

[bobaol]

how about something like concatenate in columns AB AC AF AG. like this: ab2 =IF(B2="","missing_info_"&$L2,"") ac2 =IF(C2="","missing_info_"&$L2,"") af2 =IF(F2="","missing_info_"&$L2,"") ag2 =IF(G2="","missing_info_"&$L2,"") then you can filter based on "missing_info", or sort based on "missing_info". would be helpful if you want to paste your sample data. cheers!

 

[mumps]

It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).