LinkBack URL
About LinkBacks
Hi all,
I have come across a situation where I am required to list all the category names in a cell where the corrosponding cell in not blank.
attached is the sample file with expected result.
any help is highly appriciated.
Regards,
Kiran
Hi all,
I have come across a situation where I am required to list all the category names in a cell where the corrosponding cell in not blank.
attached is the sample file with expected result.
any help is highly appriciated.
Regards,
Kiran
First I think it is difficult to make a list with the expected result, if you don't add the imput data.
2nd I think you better use a table structure and use a pivot table afterwards.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
You can get these in separate cells like this..
=IF(COLUMNS($A1:A1)>COUNTIF($B3:$W3,"<>"),"",INDEX($B$2:$W$2,SMALL(INDEX(($B3:$W3<>"")*(COLUMN($B3:$W3)-COLUMN($B3)+1),),COUNTBLANK($B3:$W3)+COLUMNS($A1:A1))))
Copy across
Life's a spreadsheet, Excel!
Say thanks, Click *
Re: formula required to list cell values based on condition
Got the answer Kiranpat,
check the attachment...
Don't forget to click *
Thanks a bunch...
This seems good...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks