Hi All,
I have data sheet where I have following columns starting from Cell A1 to P1
Work Order_WO000 Dummy Project (PC)WO000 Type_WO000 Dummy LLC Upload DateUS000 Node 2GWO600 2G Line Swap/LL Avoided StatusWO600 2G Line Swap/LL Avoided ActualWO600 2G Line Swap/LL Avoided Upload DateUS000 Node 3GWO600 3G Line Swap/LL Avoided StatusWO600 3G Line Swap/LL Avoided ActualWO600 3G Line Swap/LL Avoided Upload DateUS000 Node 4GWO600 4G Line Swap/LL Avoided ActualWO600 4G Line Swap/LL Avoided StatusWO600 4G Line Swap/LL Avoided Upload Date
and in sheet 2 from range F4 to N6 I have below mentioned criteria :-
_WO000 Dummy Project (PC)WO000 Type_WO000 Dummy LLC Upload DateWO600 2G Line Swap/LL Avoided StatusCalculationWO600 2G Line Swap/LL Avoided Upload DateWO600 3G Line Swap/LL Avoided StatusCalculationWO600 3G Line Swap/LL Avoided Upload Date
="Mwave"="Phase 1"="Swapped"=ISBLANK(Data!G2)=FALSE=ISBLANK(Data!H2)=TRUE
="Mwave"="Phase 1"="Swapped"=ISBLANK(Data!K2)=FALSE=ISBLANK(Data!L2)=TRUE
When I am running the Advance filter options than its showing blank result ?
Could anybody suggest where I am applying wrong conditions.
Regards,
Rajender
I have data sheet where I have following columns starting from Cell A1 to P1
Work Order_WO000 Dummy Project (PC)WO000 Type_WO000 Dummy LLC Upload DateUS000 Node 2GWO600 2G Line Swap/LL Avoided StatusWO600 2G Line Swap/LL Avoided ActualWO600 2G Line Swap/LL Avoided Upload DateUS000 Node 3GWO600 3G Line Swap/LL Avoided StatusWO600 3G Line Swap/LL Avoided ActualWO600 3G Line Swap/LL Avoided Upload DateUS000 Node 4GWO600 4G Line Swap/LL Avoided ActualWO600 4G Line Swap/LL Avoided StatusWO600 4G Line Swap/LL Avoided Upload Date
and in sheet 2 from range F4 to N6 I have below mentioned criteria :-
_WO000 Dummy Project (PC)WO000 Type_WO000 Dummy LLC Upload DateWO600 2G Line Swap/LL Avoided StatusCalculationWO600 2G Line Swap/LL Avoided Upload DateWO600 3G Line Swap/LL Avoided StatusCalculationWO600 3G Line Swap/LL Avoided Upload Date
="Mwave"="Phase 1"="Swapped"=ISBLANK(Data!G2)=FALSE=ISBLANK(Data!H2)=TRUE
="Mwave"="Phase 1"="Swapped"=ISBLANK(Data!K2)=FALSE=ISBLANK(Data!L2)=TRUE
When I am running the Advance filter options than its showing blank result ?
Could anybody suggest where I am applying wrong conditions.
Regards,
Rajender