kaulishmehta
New Member
- Joined
- Mar 23, 2021
- Messages
- 4
- Office Version
- 2016
- Platform
- Windows
Hello,
Now as shown i want to try make my C column, look like my E column.
I tried this formula, but didnot work
=IF(ROWS(D$2:D3)>COUNTA(C:C),"",INDEX(C:C,SMALL(IF(C$2:C$20<>"",ROW(C$2:C$20)),ROWS(D$2:D3))))
if somebody can help me it will be great!
Now as shown i want to try make my C column, look like my E column.
I tried this formula, but didnot work
=IF(ROWS(D$2:D3)>COUNTA(C:C),"",INDEX(C:C,SMALL(IF(C$2:C$20<>"",ROW(C$2:C$20)),ROWS(D$2:D3))))
if somebody can help me it will be great!