jay

I have about 150000 rows of data like below. I would like to look up a bold value. For instance if I have New York in cell D1, I want to bring back all of the values underneath New York so it would return <tbody> Jay Fred Mary Ted Sam </tbody> Here is what the data looks like below...

Hey i log information for my weekly work football and am trying to automate more of my collection of data. I have a set of data that looks like this: <tbody> <tbody> Date Game No. Win Draw1 Draw2 Loss Win Goals Draw1 Goals Draw2 Goals Loss Goals Win Scorer Draw1 Scorer Draw2...

Hi, Please help me regarding these below: 1st. How to get all capital letters in a cell. I want to get only the "DEL REY(AM)" Sample: Alejandro Jay DEL REY(AM) 2nd. How to get the remaining full first name. I want to get only the "Alejandro Jay" Thank you.

Hi I have searched high and low for this solution... If I have 4 sheets in a workbook, named Summary, Anne, Jay, Simon. I am looking for Anne to view only her sheet, Simon to view only his sheet, and Jay to view all.... (Their names could be in cell A1 of each of their sheets). How would I do...

Dear Friends, I know good command in Excel, but now i wanna set program which will trigger on the basis of date. I have all data in excel. If this work then.This will help in our routine work also like birth date, and other imp date, If possible then also give some idea ir it based on some...