## Questions about my Excel works

Hi! I study use of Excel in my university, but I’ve encountered insurmountable challenge in my latest homework. No previous teaching material or …

Hi! I study use of Excel in my university, but I’ve encountered insurmountable challenge in my latest homework. No previous teaching material or …

I am tracking items taken from inventory. At any given time we take out tshirts and distribute to branches. I need to provide totals of all sizes distributed …

I have a spreadhseet holding a list of grade 1 learners. Obviously the number of learners can vary over time. I am using an array formula to find the reference …

I was able to count cells by their background color by the following: Function CountColour(rng As Range, clr As Range)Dim c As RangeFor Each c In …

Hi, hope you can help, I want to convert the formula below to a workable one in 2003 version. I’m aware that 2003 does not support the sumifs fiunction …

I have a spread sheet with 5 sheets, sheet (SH)1 is the master sheet, sheets 2, 3, 4 & 5 are different routes, on the master sheet i have 4 columns, col1 …

To quickly find the minimum number in a range of cells you can use Microsoft Excel’s MIN Function that will quickly tell you the minimum number from a …

i have an overview page. i need to add an entire column from a differant sheet if it says a certain word. the column will have 4 differant words i need to add …

A new function for Excel 2007, the COUNTIFS function returns the number of cells (of a specified range), that match a set of given criteria. So let’s say …

In a previous post I talked about how to use the COUNT function in Excel to count the number of cells containing data. Well, you can also combine COUNT with …

When using Excel, it’s often beneficial to know how many cells that contain data there are in a range. A real easy to work this out is using the COUNT …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.