pulling

Hi there, I have somehow stumbled my way across to get an index function to work with a project plan. Please find spreadsheet attached. On the Project Planner snapshot sheet, you will see to the right hand side (ID) and 'Actions for the next meeting'. Using the relevant ID number, actions for...

I have this on A1 and B1 NOTAIRE AEINORT OTARINE AEINORT ETAERIO AEEIORT ANEROID ADEINOR AILERON AEILNOR ALERION AEILNOR I need formula on b1 and c1 to do the following , formula to point B AEINORT NRT AEIO AEINORT NRT AEIO AEEIORT RT AEEIO ADEINOR DNR AEIO AEILNOR LNR AEIO AEILNOR LNR AEIO...

Hi, Is there a way to create a list pulling names from another sheet that includes a certain date range? Using this data below: <tbody> A B C D E Madison 1/16/17 2/3/17 5/15/17 6/2/17 Tony 1/18/17 2/5/17 5/30/17 6/17/17 Tiffany 2/20/17 3/5/17 5/23/17 Claire 2/26/17 3/6/17 4/28/17...

I have this equation in cell a1: 15x2 + 13x – 20 I want to pull out the coefficients and the constant in three separate cells. I use =LEFT(a1,FIND("x",a1)-1) to pull out the 15…..I am having trouble pulling Out the 13 and the 20 Help please The function should work with other similar equations...

I am a newbie to VBA. I have multiple workbooks and each workbook has multiple worksheets. Al these workbooks are basedof same template, so all workbooks have same names and same # of worksheets with same names etc. In each worksheets columns are also same. Its just same templete but data is...