Hi guys,
I have an excel sheet that have a large set of datas. In these datas in one column most of the datas are indicated as green but some of them are red. I can pick the red ones by using filter option but I also wanted to show the red cell values in one cell. For example, Cell1;Cell2;Cell3 like this (the ; should be between them). I try to use macros but that is not the program that I have full knowledge about it. So i can not solve the issue.
How can I solve this?
Thanks
( Like this
IF
A(i)= red
Then
B(i)=A(i)
end if
)
Bookmarks