Please help in perhaps a easy problem, but difficult for me. My client requests are registered in a table :
Client ID ! Name ! Product ID ! Product Name ! Date ! Problem (a-z) ! Status !
22222 ! Jeff L. ! 1321 ! Nuxe ! 12-05-2015 ! c ! ? !
333 ! Jeff M. ! 1327 ! Naxe ! 14-05-2015 ! c ! Ok !
44412 ! Jeff N. ! 1312 ! Nixe ! 13-05-2015 ! c ! ? !
22222 ! Jeff L. ! 1320 ! Nyxe ! 16-05-2015 ! c ! ? !
333 ! Jeff M. ! 1327 ! Naxe ! 14-05-2015 ! c ! Ok !
44412 ! Jeff N. ! 1312 ! Nixe ! 13-05-2015 ! c ! ? !
22222 ! Jeff L. ! 1320 ! Nyxe ! 16-05-2015 ! c ! ? !
In my result table I want to get the rowid of each clients requests :
Client requests (rowId) to use with OFFSET to list client requests :
! Jeff L. ! Jeff M. ! Jeff N. !
! 1 ! 2 ! 3 !
! 4 ! 5 ! 6 !
! 7 ! ! !
The client request table have from 200 rows to 1000 and I have tried Index formulas with no success.
Please help me in creating a formula on this !
Best regards
Cosima
Client ID ! Name ! Product ID ! Product Name ! Date ! Problem (a-z) ! Status !
22222 ! Jeff L. ! 1321 ! Nuxe ! 12-05-2015 ! c ! ? !
333 ! Jeff M. ! 1327 ! Naxe ! 14-05-2015 ! c ! Ok !
44412 ! Jeff N. ! 1312 ! Nixe ! 13-05-2015 ! c ! ? !
22222 ! Jeff L. ! 1320 ! Nyxe ! 16-05-2015 ! c ! ? !
333 ! Jeff M. ! 1327 ! Naxe ! 14-05-2015 ! c ! Ok !
44412 ! Jeff N. ! 1312 ! Nixe ! 13-05-2015 ! c ! ? !
22222 ! Jeff L. ! 1320 ! Nyxe ! 16-05-2015 ! c ! ? !
In my result table I want to get the rowid of each clients requests :
Client requests (rowId) to use with OFFSET to list client requests :
! Jeff L. ! Jeff M. ! Jeff N. !
! 1 ! 2 ! 3 !
! 4 ! 5 ! 6 !
! 7 ! ! !
The client request table have from 200 rows to 1000 and I have tried Index formulas with no success.
Please help me in creating a formula on this !
Best regards
Cosima