I want to find row (number/position/index) using Reg No.
first of all I call The whole column and then make list using “list from csv table text” and then want to find the index of that reg number but getting 0 instead of index.
Hi dear,
Which extension are you using?
Try checking whether you’re already receiving a list directly, maybe it’s not necessary to use listFromCSVTable.
If you notice, each element of the column is wrapped in parentheses,
so each item is itself a list and indexInList doesn’t work on a list of lists.
You could use this approach if there’s really no other solution.
=
Or you could try an approach using splitTextAt.
Creating a new list by mapping nested lists working for me. Thank you so much for this tips.
But I am still looking for smart soluation. For now I am following your Trick.
Thanks Dear,
I am using this spreadsheet extension https://drive.google.com/file/d/11fm0By8vziniDWOg9TOYlRfSEz2tb9hE/view
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.