Using Data Fill function to copy a Countif formula
Instead of using the actual name in your formula, put the names in separate
cells, say A10:A15. If "Claire" is in A10, your formula should read =countif(b$1:b$8,A10) Notice that the B1:B8 address has been modifed, too. This formula you can drag down/fill "Rachael F" wrote: I have a worksheet that contains the dates on which an user has logged on to a computer network - sample data below: Date User 22/1 Rachael 22/1 Sue 22/1 Claire 22/1 Sam 23/1 Sue 24/1 Rachael 24/1 Sue 25/1 Claire I have used the countif formula to count the number of times that an user (Claire)has logged on: Claire =countif(b1:b8,"Claire") Sue Rachael Sam I would like to copy this formula for all users without needing to change the name for each of the copied formulas. Can/should I use data fill to do this? Many thanks. Rachael |
All times are GMT +1. The time now is 08:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com