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? ht...
=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?
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?
- This works perfectly fine! I am on Office365. Thanks!!