If i search based on account number Getting below table,.
Need Extarct the Main account,Sub Acnt,…condition is which row has 0.00 (Allocated FC),.
Above case 1 row have 0.00 (Allocated FC),. Some time 2 nd row having 0.00 (Allocated FC),… Table have 3 or 4 row only,…
I have 50 Account number, each account number has above table, with different positions in allocated FC (0.00),.
Can any one help? I try for each loop works but unable to extarct the text/value repeatedly,. need save as Excel or CSV,… !!