CODEWITHSUNDEEP
excelexcel-formula
harnithu
harnithu

Reputation: 93

how to get First not null/empty values in excel

Hi I have doubt in excel how to get First not null/empty values when valid value available else display empty value that field in excel enter image description here

input data :

 Empid |Name
    1  |1
    2  |
    2  |c
    1  |
    3  |
    4  |i
    5  |g

based on above data I want output like below :

Empid |Name 
1     |1
2     |c
3     |
4     |i
5     |g

enter image description here

please tell me how to achieve this task in excel.

enter image description here

Upvotes: 0

Views: 1476

Answers (1)

Harun24hr
Harun24hr

Reputation: 36880

If you have Excel-365 then try below formulas.

D2 cell formula =UNIQUE(A2:A8)
E2 cell formula =@FILTER($B$2:$B$8,($A$2:$A$8=D2)*($B$2:$B$8<>""),"")

enter image description here

Upvotes: 2

Related Questions