3/11/2023 0 Comments Geekmeter vs monity![]() ![]() Read this as…If the total number of rows is greater than the number of rows being displayed, show “List Filtered” and the number of items displayed. Here is the logic translated for normal humans. ![]() Now that is a pretty ugly looking beast, but don’t let that intimidate you. If you’re still with me, here is the formula: ( If this is making your head hurt already, go ahead and skip down to the bottom, I won’t be offended. The formula to make this work uses an IF statement in combination with the COUNTA and SUBTOTAL functions. If you’re still with me take a look below to see what this looks like in action. Warning this may register a bit high on the ‘geek meter’. And if it is, how many records are being shown. This week we’ll see a cool formula that will clearly show you and/or the people looking at your spreadsheets, if the data has been filtered or not. (You’ll be glad you did!) If you’re already using it, good for you – you know how useful it can be. If you use Excel much, especially with large amounts of data, and aren’t using the AutoFilter function, stop right now and go learn about it. #278 The Tips Will Live On & Why You Should Blogįollow Work Smarter Not Harder on.Creating Better Documents With PowerPoint.Why Write Excel Formulas When You Can Flash Fill?.#385 Middle Mouse Button Tricks You Never Knew.How to Embed Videos Into Microsoft Word Documents.The Fastest & Easiest Way to Arrange Multiple Slide Images.#272 Automatic Separator Lines in Excel.#293 Show Only A Few Rows & Columns of Your Spreadsheet. ![]() Do not read while operating a motor vehicle or heavy equipment or under the influence of anything that may impair your judgment. All relevant company policies and legal statutes supersede any content contained herein. Although I do my best, there may be occasions when I'm misinformed, delusional, or otherwise off-base. These views do not necessarily represent those of the company. All opinions and perspectives shown here belong to me. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |