Recently added Tips & Advice

Most read Tips & Advice
Recently added Tips & Advice

All Domains

Latest news
- my News
Employment & HR
- Brexit
- Maternity, paternity, adoption
- Training
- Trade unions
- Termination of employment
- Retirement
- Redundancy
- Recruitment
- Pay & conditions
- News
- Legal developments
- Absence management
- HR/personal development
- Holidays
- Flexible & part-time working
- Employment status
- Employment contracts
- Discrimination
- Disciplinary, dismissal and grievance matters
- Data protection
- Working time
Health, safety & environment
- Brexit
- Contractors
- Noise
- News
- Manual handling
- Machinery
- Insurance
- Health & safety management
- Fire safety
- Environmental management
- Enforcement
- Energy
- Construction
- Pollution
- Chemicals
- Accidents
- Workplace
- Working at height
- Wildlife
- Water
- Waste
- Transport
- Tax
- Risk assessment
- PPE
- Occupational health
Running a business
- Banking, finance & insurance
- Brexit
- Property
- Office management
- News
- Insurance
- Directors' liability
- Debt recovery
- Cost cutting
- Company law
- Commercial & consumer law
- Cars & transport
- Buying/selling a company
Tax
- Extracting income from a company
- Inheritance tax
- Stamp duties
- Sole traders & partnerships
- Returns, forms & HMRC admin
- Pensions
- News
- National Insurance
- Land & buildings
- Income tax
- Brexit
- Expenses
- Enquiries & penalties
- Employment taxes
- Corporation tax
- Cars, vans and vehicles
- Capital gains tax
- Capital allowances
Technology for Business
- Apps
- Health & fitness
- Travel & transport
- Software
- Social media
- Security
- Search & SEO
- News
- Hardware
- Building & designing a website
- Entertainment
- E-mail
- E-commerce
- Culture & science
- Consumer matters
- Business affairs
- Web services
VAT
- Brexit
- Debt relief
- Enquiries and penalties
- Input VAT (VAT on purchases)
- Land & property
- News
- Output VAT (VAT on sales)
- Overseas matters
- Registration
- Returns, forms & HMRC admin
- Special schemes
- VAT rates
All Domains

July 2021

Last 7 days
Last 30 days
Last 90 days
Full year
All years

SPREADSHEETS - 06.07.2021

Calculations on visible rows only

You want to count the number of unique customers in a set of data that has a filter applied so there are several hidden rows. The problem is that the formula you are using also includes the hidden rows. How can you calculate just the number of unique customers from the visible rows?

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed bibendum, sapien nec interdum commodo, ex elit feugiat velit, vel tincidunt nibh massa nec turpis. Phasellus rutrum pulvinar tristique. Aenean vel maximus velit. Integer in purus dictum, commodo diam sed, facilisis metus. Duis sed consequat nisi. Phasellus et risus neque. Curabitur mattis, nibh ac finibus bibendum, nulla augue commodo ipsum, vitae tristique urna felis in velit. Cras et eleifend lorem, in convallis leo. Fusce id nibh et leo congue convallis. Vivamus imperdiet ipsum sit amet felis condimentum, a lobortis felis rutrum. Integer ullamcorper, turpis in aliquet tincidunt, est tellus volutpat leo, id pretium massa nibh sed orci. Pellentesque ac viverra lacus. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Ut ut ante eget nulla volutpat tempor. Donec commodo leo mi, congue blandit leo euismod ut.