Showing only columns with data...

**NewExcelUser** · 11-16-2006, 05:29 AM

Hello and Good Day,

I have 3 columns of information.

In column a, I have a helper row (I think that's what it is called) to show a number if the cell next to it in row B contains information. In column C is where I would like the information to be displayed. The trick is, I would like the information in column C to begin on the first row as the information in column B (Based on criteria of month and date) expires throughout the course of the month. How can this be done?

I have attached an example...

Once again I call upon the help of the experts, and once again, thank you.

**Dav** · 11-16-2006, 05:53 AM

It can be done, but it is not entirely clear from your post what you require.

What criteria are being applied?
Does the list want to be sorted?

Can you be a little more descriptive

Regards

Dav

**Bryan Hessey** · 11-16-2006, 05:55 AM

Originally Posted by NewExcelUser

Hello and Good Day,

I have 3 columns of information.

In column a, I have a helper row (I think that's what it is called) to show a number if the cell next to it in row B contains information. In column C is where I would like the information to be displayed. The trick is, I would like the information in column C to begin on the first row as the information in column B (Based on criteria of month and date) expires throughout the course of the month. How can this be done?

I have attached an example...

Once again I call upon the help of the experts, and once again, thank you.

Hi,

Correct the formula in A1 to

=IF(OR(B1="",B1=0),"",COUNTA($B$1:B1)-COUNTBLANK($B$1:B1))

and your C1 formula to

=IF(ISERROR(VLOOKUP(ROW(A1),$A$1:$B$20,2,FALSE)),"",VLOOKUP(ROW(A1),$A$1:$B$20,2,FALSE))

note, I still disagree with your formula in B as it works for single months in the worksheet only, the 'anniversaries' answer is still preferred.

hth
---