How to make every third line take data from a list one by one, visual attachment included.
I'm writing a 3 line script for SQL in Excel.
Every third line needs to take a number from the list (Excel Issue Ed.jpg.
At the moment, if I drag the script down it only picks up every 3rd number down the column. How do I make it take every number down the list. See Attachment.
I need to be able to drag to 3 lines (block of script) down as I need to apply it to about 500 different numbers.
Any help would be much appreciated!
Last edited by Petonium; 03-18-2014 at 09:40 PM.
Using your posted example (BTW..we very much prefer excel files)
This regular formula, copied down, begins the list of every-third-item
Is that something you can work with?
Please Login or Register to view this content.
Thanks Ron
How do I apply that into this file, each number must sit between the ' ' on each line.
Than, must be able to just drag it down so a block of script is written for each VCHRNMBR.
Kind Regards, you help is very much appreciated!
I attached an edited version of your file.
These are the changes I made:
• In Col_C, next to the VCHRNMBRs I put a list of VendorIDs (in case they change)
These regular formulas begin the script-creation
Copy those formulas down as far as you need.Please Login or Register to view this content.
E3:E11 will have these results:
Is that something you can work with?Please Login or Register to view this content.
Last edited by Ron Coderre; 03-19-2014 at 09:10 AM.
Ron that is exactly the formula I was looking for. Thankyou so much for developing that it has brought me much joy,
Kindest Regards,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks