Skip to Content
0

split on one column value and filter on that

Dec 20, 2017 at 11:19 AM

15

avatar image

Hello All,

I have to combine 2 reports Alist and Blist

I have a column name ABC in that the value are coming

2235-02-106-11-04-010,

2235-02-106-11-04-500,

2235-02-106-11-04-230,

2234-01-367-12-10-210.

The criteria is in 6 levels. on last value i should filter it . if the value is

XXXX-XX-XXX-XX-XX-XXX="010" then show Alist

if the values XXXX-XX-XXX-XX-XX-XXX # "010" then show BList..

Please let me know how i have the write a formula on one column...

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers