Forum Discussion
Solved
Create list from column
I want to output a list in column H where just the skills from column a are displayed, the person from B to D has a number assigned.
Is there a formula like filter / sort that can do that?
=FILTER($A$3:$A$17,B$3:B$17<>"")Maybe with this formula. The FILTER function requires Office365 or 2021 or Excel online.
Can you show a visual example of what you want to do with VLOOKUP and the values from columns B and D?
=IF(B3<>"",$A3,"")Maybe with this formula in cell H3. Then copy the formula across range H3:J16.
- Hey mate,
thanks for your reply.
I already did that. The problem are the empty cells.
I have a vlookup next to column H with the values from B to D.
I want to make an analysis for each person on the basis of column H.
As the file is growing I want to automate the creation of this list.
Is there a possibility with the FILTER function or something?=FILTER($A$3:$A$17,B$3:B$17<>"")Maybe with this formula. The FILTER function requires Office365 or 2021 or Excel online.
Can you show a visual example of what you want to do with VLOOKUP and the values from columns B and D?
