User Profile
MalcolmBrowning
Copper Contributor
Joined Feb 06, 2022
User Widgets
Recent Discussions
Re: Filter function help
JU51M3 I am trying to insert this formula into the spreadsheet as you have mendtioned. Could you give me a written out complete formula for the first group of boxes please as i cant seem to get it to work. Do i change every n for one row number or for each consecutive row number? so In cell I4 the formula would be IF(An="",I(n-1),An) In cell I5 the formula would be IF(An="",I(n-1),An) In cell I6 the formula would be IF(An="",I(n-1),An) In cell I7 the formula would be IF(An="",I(n-1),An)Filter function help
Hi, I am in the process of updating and managing our work projects log. As you will see from attached document I have merged rows at the beginning of the table to allow each project to include a basic Gantt chart to detail timeline for different aspects of each project. When filtering I cannot perform the function correctly to hide a complete project when I say, deselect any project which has reached 100% progress, as this only hides the top row (where the merged data is located) Is it possible to have a function to allow me to hide each completed project when selecting either project phase (to-do, ongoing, complete) or percentage complete?
