S
SamuelT
Hi all,
I've got a report spreadsheet, that shows the status of around 30
projects as either "Red", "Amber" or "Green".
In another worksheet of the report I want to display all the projects
that are displayed as "Red".
Now, I know that I could have a column that looks at a specific cell
with the project status in and displays it if is says "Red":
=IF(A2="Red",A2,"")
However, this would also mean that where the projects aren't "Red",
there would be gaps in the table.
Is there a formula I can use that looks at specific cells (for example
- A2, A102, A202, A302 and A402), and if they are "Red" displays the
status as such, but if it's not, not leave to a gap in the table.
I hope that makes sense - it's quite hard to explain!
TIA,
SamuelT
I've got a report spreadsheet, that shows the status of around 30
projects as either "Red", "Amber" or "Green".
In another worksheet of the report I want to display all the projects
that are displayed as "Red".
Now, I know that I could have a column that looks at a specific cell
with the project status in and displays it if is says "Red":
=IF(A2="Red",A2,"")
However, this would also mean that where the projects aren't "Red",
there would be gaps in the table.
Is there a formula I can use that looks at specific cells (for example
- A2, A102, A202, A302 and A402), and if they are "Red" displays the
status as such, but if it's not, not leave to a gap in the table.
I hope that makes sense - it's quite hard to explain!
TIA,
SamuelT