How to get list ignoring blank cells

I am having data in table with 2 column in one sheet. Column 1 has data in text form. Column 2 has data in number form. I need result in another sheet with following condition. - Ignore blank ...

excel

Formulas and Functions

OliverScheurich
Aug 28, 2023
Yashesh_Shah
=IFERROR(INDEX($A$2:$A$25,SMALL(IF($B$2:$B$25<>"",ROW($A$2:$A$25)-1),ROW(A1))),"")
You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.

nimesht

Iron Contributor

Aug 28, 2023

Hi Yashesh,

Do you want all the applicable data from the source sheet or only based on some condition using lookup formulas?

Yashesh_Shah
Copper Contributor
Aug 28, 2023
nimesht To all applicable data
- Riny_van_Eekelen
  Platinum Contributor
  Aug 28, 2023
  Yashesh_Shah If you are on Excel365 or 2021, perhaps something like this?
  - Yashesh_Shah
    Copper Contributor
    Aug 28, 2023
    Yes, Like this. Please share complete formula.

Forum Discussion

How to get list ignoring blank cells

Resources