Ready, steady… save!
You don’t need a chart to join in. Here are 2 ways to record your savings:
1. Cross it off
Pop a chart into your first post. Saved an amount? Cross it out! Read more »
£0.01 £0.02 £0.03
2. Write it down
Skip the chart and add updates to your first post. Read more »
“Another +£3 saved today. Go me!”
Use +£ before each new saving so it counts towards your total.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Need a formula for an excel workbook
JuneBow
Posts: 302 Forumite
in Techie Stuff
I am working on an excel spreadsheet.
It is a bank account analysis of spending on about 30 properties, so there are many entries.
First colum date, second detail, third column identifies the particular property, next, cash in, then cash out.
Each property has three columns after that, and the info gets transferred to the three columns with the formula =IF($C6=$I6,+E6,"").
This means that each property has its own income and expenditure columns which I have transferred to a different sheet.
Now when I go into that sheet, there are therefore loads of blank rows.
How do I delete all of the rows in a single formula.
I hope I have explained this properly.
Thank you.
It is a bank account analysis of spending on about 30 properties, so there are many entries.
First colum date, second detail, third column identifies the particular property, next, cash in, then cash out.
Each property has three columns after that, and the info gets transferred to the three columns with the formula =IF($C6=$I6,+E6,"").
This means that each property has its own income and expenditure columns which I have transferred to a different sheet.
Now when I go into that sheet, there are therefore loads of blank rows.
How do I delete all of the rows in a single formula.
I hope I have explained this properly.
Thank you.
0
Comments
-
Do you mean that you have blank rows where $C6 did not equal $I6, etc?
Are you transferring the columns manually by copy and paste? If so, you could filter on those columns to exclude the blank rows before copying.Charlie0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 355.9K Banking & Borrowing
- 255K Reduce Debt & Boost Income
- 456.2K Spending & Discounts
- 248.4K Work, Benefits & Business
- 606.1K Mortgages, Homes & Bills
- 179K Life & Family
- 263.9K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.2K Discuss & Feedback
- 37.7K Read-Only Boards