Recent content by niallc
-
N
Formula to calculate average if greater than or equal to 30
Tested again and noticed the >= citeria, so sumif(range,">=30")/countif(range,">=30") should do what you asked cheers -
N
Formula to calculate average if greater than or equal to 30
I suggest sumif(range,>30)/countif(range,">30"). I think this should do it. regards -
N
Extracting values from a list based on a count
Sorry RayH, I don't think i have the hang of reading to the bottom of the page yet :o Apologies -
N
Extracting values from a list based on a count
What about creating a Pivot table where Count is the "Page" Event is the "Row" Count of Event is the "Data" then Filter the Page-"Count" for required value , in this case "1" First ever Reply , so forgive me if in wrong format etc niallc -
N
Saving file with name derived from cell contents.
I need to save data from a sheet as a tab delimited.txt file for exporting to another dept. Currently i "Save As" ; Type filename in quotes eg todays file was "Pos.txt.20070417" ;and save as type Tab delimited. The format of "Pos.txt.YYYYMMDD" is forced upon me. Cell A2 of the file today...