Is your data validation list is so long that the endless scrolling makes you want to close Excel and never use it again? This post will review several solutions to this problem. Continue reading
Video 00158 Keyword Data Validation List
Posts Tagged → Debra Dalgleish
My Favorite Excel Tips From Other Sites Part 2.
As much as I enjoy sharing my knowledge I have found that this series is just as beneficial for me as it is for others. I sometimes ask myself or others “Do you remember that Excel thing that does….” Continue reading
Video 00042 Why would I need an array formula?
Why would I need an array formula?
I have heard this question so many times over the years! If you have never ever used an array formula than this video is for you.
Don’t worry….No prior knowledge is required. I explain things slowly. Continue reading
Video 00035 Solution_Dynamic array HYPERLINK
Create a dynamic hyperlink using an array formula!
This means that you can jump to a location in your data depending on conditions in the values.
This is one of my favorite ways to use an array formula! Continue reading