Signum12
02-08-2012, 09:18 PM
Hi i m having problem with using a INSTR function to offset data into spreadsheet which requires me to skip a line and get data from the next line
For eg
Ref no.
Jan12 222.00. 222.00. 222.00
Dec10. 111.00. 111.00. 111.00
Dec11. 111. 111. 111.
Total.
Each acc may contain various dates but i wan to offset those lines for each account until then TOTAL and loop it . Any ideas?
For eg
Ref no.
Jan12 222.00. 222.00. 222.00
Dec10. 111.00. 111.00. 111.00
Dec11. 111. 111. 111.
Total.
Each acc may contain various dates but i wan to offset those lines for each account until then TOTAL and loop it . Any ideas?