Forum Discussion
List of Items from Data Entry Form
For such layout
in E5 you may use
=IFERROR(INDEX(dataentry[Department],MATCH(0,INDEX(COUNTIF($E$4:$E4,dataentry[Department]),0),0)),"")and drag it down till the end of future range. With every new department in A it will appear in B.
Negative, I am using microsoft 365, dynamic array option is not available in 365.
thank youRiny_van_Eekelen
For such layout
in E5 you may use
=IFERROR(INDEX(dataentry[Department],MATCH(0,INDEX(COUNTIF($E$4:$E4,dataentry[Department]),0),0)),"")and drag it down till the end of future range. With every new department in A it will appear in B.
Hi SergeiBaklan
How do we can do this on criteria basis?
Means: I want the same data in table B as Regular criteria and Table C as Non regular Criteria
Attached the excel for your ref.
For
that could be for Table B
=IFERROR(INDEX(dataentry[Department],MATCH(0,IF(dataentry[Condition]="Regular", 0, 1)+ COUNTIF($F$4:$F4,dataentry[Department]),0),),"")and for the Table C
=IFERROR(INDEX(dataentry[Department],MATCH(0,IF(dataentry[Condition]="Non Regular", 0, 1)+ COUNTIF($F$15:$F15,dataentry[Department]),0),),"")Above are array formulas (Ctrl+Shift+Enter)
Excellant- Thanks a lotSergeiBaklan
this is what I want, thanks a lot dearSergeiBaklan
Sameer_Kuppanath_Sultan , you are welcome