Blank rows at bottom of sheet

TEATom · 06/03/24

I have 12 rows at the bottom of a sheet that I have deleted but they instantly come back. These are messing up my calculation sheets. How do I get rid of them? Why are they there anyway?

Peggy Parchert · 06/03/24

@TEATom

Hello. There is always 10 blank lines in a sheet - I can't find the article that says this but I know it is true. I have adjusted my formulas to ignore a row if a column is blank. For example, if the primary column is blank, don't count that row.

Hope this helps.

Peggy

TEATom · 06/04/24

I need to use the columns for vlookups and this doesn't work for me. Is there any way to do this?

Peggy Parchert · 06/04/24

@TEATom

Could you provide some screenshots, removing any sensitive data for context?

Thanks,

Peggy

TEATom · 06/04/24

Peggy Parchert · 06/04/24

@TEATom

Thank you for the screenshot. What column in the above screenshot do you have your VLOOKUP formula in? Column 2?

Peggy

Peggy Parchert · 06/04/24

@TEATom

If Column 2 contains your VLOOKUP formula, I would add this to the beginning:

=IF(ISBLANK([Primary Column]@row), "", "VLOOKUP(…

This will process the VLOOKUP as long as the Primary Column has something in it.

Hope it helps.

Peggy

TEATom · 06/05/24

THe 13 no assigned should only be 1, the 12 blanks at bottom of sheet skew the data. Yes column 2

TEATom · 06/05/24

Thank you Peggy. This is my formula, Where do I put the beginning formula portions?

=COUNTIF({Little Sheet Range 1}, "PERSON NAME")

TEATom · 06/05/24

Actually I have another concern. If my formula says ISBLANK at rows 25-37, once those rows get data from the form that populates it, I would have to go back and change the formula to move down each time? It would seem that would be true. Am I wrong?