• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

google sheet problem, need solution

Status
Not open for further replies.

Alok Mishra

New Member
Here is the google sheet link- Copy of WPR - Google Sheets

1- I am not able to fetch data in column P row 6 and onwards. I am trying to create an arrayformula that fetch the data from Backup Data A9:A and but not able to create. I need the data in column P whereever data is there in COlumn J of wpr sheet. formula is there in P6 and P16 for your reference. I need to apply arrayformula in P6.

2- There is problem with the script as well where I am selecting any data in column M, it is giving me dropdown in column N in wpr sheet fetched from backup data sheet but when I am selecting data in bulk, it is not creating the dependent dropdown.

Please help for the both the problems!
 
Status
Not open for further replies.
Back
Top