I am currently working on a project in which over the past couple weeks I have not been able to remedy. I would like to extract data from COL B to another row based on multiple search criteria including date ranges e.g. 01/01/16 - 09/29/17 in COL A , Name COL C, the current COL D (which will need to include "completed" in one extraction, then omit "completed" in the next extraction), status COL E (one extraction for numbers, another for "empty", Duplicate Entry COL F (only need to extract values here with the value of 0) then whether or not there is a date in Date 1 then Date 2 then Date 3 then Date 4 COL G,H,I,J.
COL G H I J will require separate results as the dates are particular to what stage the review process is in.
What I usually do to find my output data is utilize filtering however, this is very time consuming as there are several thousand lines of data that I must extract COL B numbers from based on different COL C names.....
I have an example to post however, my account will not allow me to add attachments...
I hope this makes sense! Thank you in advance for any help. It is greatly appreciated!
COL G H I J will require separate results as the dates are particular to what stage the review process is in.
What I usually do to find my output data is utilize filtering however, this is very time consuming as there are several thousand lines of data that I must extract COL B numbers from based on different COL C names.....
I have an example to post however, my account will not allow me to add attachments...
I hope this makes sense! Thank you in advance for any help. It is greatly appreciated!
