Automatically insert blank rows between data in Excel
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting
00:00 Inserting blank rows between data in Excel
00:20 Create lookup numbers (even numbers only)
00:36 Create the VLOOKUP to pull through the matching items
02:10 Create IFERROR to make the blank rows
From https://www.auditexcel.co.za/blog/ins...
Images on website
Although it goes against all database good practice, sometimes you have to insert blank rows into a dataset to accommodate some other system. Perhaps your accounting system needs to have a gap between each journal entry. Below we look at some ways on how to insert blank rows in excel automatically
Make the insert blank rows automatic
If you want this to be more automatic e.g. you copy and paste it into an area and in a new sheet it creates the blank rows you can use a VLOOKUP.
Below in the blue area we can paste our data. Note that in column A we have created a Lookup Index which is even numbers.
In cell A28 we created a column going in number order (1, 2, 3 etc). Now all we need to do is create a VLOOKUP that pulls through the number if it finds a matching number (e.g. the 2), but if it doesn’t find a match it puts a blank in.
To learn more about VLOOKUP and how/ why we have the column numbers in row 1, look at our online VLOOKUP course.
How to insert blank rows in excel automatically
Смотрите видео Automatically insert blank rows between data in Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь AuditExcel Advanced Excel and Financial Model Training and Consulting 08 Октябрь 2020, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 8,033 раз и оно понравилось 14 людям.