| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Data Fill function to copy a Countif formula
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Data Fill function to copy a Countif formula | Excel Worksheet Functions | |||
| Help - copy a formula using the fill handle | Excel Discussion (Misc queries) | |||
| Use data to copy/fill other cells. | Excel Discussion (Misc queries) | |||
| I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) | |||
| Concatenate Countif formula for VBA fill-in | Excel Discussion (Misc queries) | |||
Threaded Mode
