find & return

So I have two worksheets. One with raw data imported from a .txt file and another that I plan to use to organize and pull the data I want. I would use Access but the formatting of the .txt file does not allow for easy importing. I am trying to search the Cells in Column Data!A:A for product...

Hi everyone! I've tried to find the answer for that question but it doesn't seem that it has ever been quite resolved. So here I am, trying to get resolution on it! I want to be able to return the value of the first non blank value above a given cell (as parameter). Example A1: A2: x A3...

Alright i have a term i want to search say "Large Dog" I have a list of about 200 rows of files (located in a few main folders on my computer) that i want to search through each of the text strings. Is there a way that i can search through the entire list and have the formula return return a...

Hi, I am hopeing that this is an easy question for one of you. Allthough I have mastered vlookup's I dont know how to takle this particular problem. I am a product manager and am trying to make an anylisis workbook. On one sheet (Promotions Forecast) I have each appropriate month listed in the...

Hello friends of excel For planning reasons we maintain an ever changing matrix of values. I would like to use a formula to count how many times the last value in a row has appeared at the end of that row. For example. My data-row looks something like this: A,A,B,B,B,C,D,D,B,B,B,B,A,A,C,B,B...

Hi, I have a set of data. Date........Price........Volume 7am.........99............10 701am......98.............2 702am......98.5..........12 etc. Record set of 46k rows so looking for the most efficient formula. I want to graph the volume shifts but struggling with an efficient formula to...

Hi Everyone, I am trying to figure out how to return the text between two different instances of the same symbol. For example, I have this in a cell: 100% Cotton / 55.0 in / 3.2 oz/sq yd / 120 x 70 / 40 NE x 40 NE / Yarn Dye I want to be able to to extract all the information between the fifth...

Hi this is my first post and I'm a excel vba beginner. I tried to find other relevant threads that would help me with this challenge but I was unable to apply it correctly to my situation. I am trying to make a UserForm for the first time. The goal of my userform is to take the headers of each...

Hi, Could someone please help! I've created a brainstorming activity in which we create a list of text answers in column 1, then in column 2 we go through and assign each text a specific numeric value 1-5. Each numeric value is actually assigned to a category name. Here is where I need...

Hello All, This will be my 1st posting and I would greatly appreciate some advise on the best way to handle what I am attempting to accomplish. Basically, I would like to open an excel workbook file (.xlsm) and rename the file using the PC name ("Book1" & PC_Name). Obviously, I do not want...

I need to retrieve rows of data from a closed workbook based on a number entered by a user in a cell on the open workbook. The closed workbook has a number of worksheets therefore the code will need to search each sheet and retrieve matching rows. Column a has the number to be searched...

I want to know how to build a macro that can look into a column of numbers ranging from 0 - 9 that contains duplicates of each number and returns what numbers exist in the column and not how many times it is in the column. Say I have a column with 2,3,4,1,3,2,3,6,4,6,3,2,1 in it, is their some...