Forum Discussion
Formula to extract running data.
I am using Excel 2010. I have a simple spreadsheet that I am attempting to extract data from. I need a formula in cell E3, E:4, E:5, ect… that will look down column A:A to find a value that starts wi...
Thank you for the input. However, as you can see in the example, even when changing the references cell, I get the same responses. So it is not pulling out the data required. I may need to bypass the formula all together and create a separate work book that has the data filtered 100 different times to extract the specific parts for each order.
In the attached file you can select a search value from the dropdown list in cell F1 to display the results dynamically. Is this what you want to do? I adapted the formulas for the search values in cells I1, L1 and O1 and it works as intended in the attached file.