excel & lookup & search

Hi, I am looking to find the Max Alphanumeric Serial Number that is in a column and increment by 1 by meeting multiple criteria provided. here is what I found on this site http://www.mrexcel.com/forum/excel-questions/749540-find-max-alphanumeric-serial-number.html [CODE][{="GI-"...

i want to convert Quarter year to date.please help. for eg- i have Q1 2010 i will be replaced with 01/01/2010.

Hi, I've got an interesting problem, which has stumped me for a week now. I have a dataset that lists customer IDs and the product IDs for the products they currently own. Simple example: Tom, iphone Tom, ipad Tom, Minecraft Lego Emma, iphone Emma, ipad Emma, guillotine Emma, Ham sandwich So...

I started with a vlookup but moved to an index match. I am trying to match two columns 1 column has an ID in it the other column has a ^ with an ID. If I put the formula of the cells I get a match but when I use the index match it won't match. I am comparing value from one sheet with values from...

Hi there, I just wanted to fix the following problem that last few days struck my work. Data: <tbody> A B C D E F G H I J K 1 10/5/2016 RAM 10/5/2016 RAM RAHIM SUJA 0 0 0 0 2 10/5/2016 RAHIM 10/6/2016 RAM RAHIM SUJA SANGEETHA 0 0 0 3 10/5/2016 SUJA 10/10/2016 RAM RAHIM SUJA...

Hi, I have sample table like this: <tbody> ID 1 2 3 1 0 1 0 2 1 1 1 </tbody> Then I want to generate a new table from that table. It will take the second row (1) then compare with each column (1, 2, 3) then print value of the matrix ( 0 - 1 - 0 ). For example: <tbody> Row_ID...

I have a formula that is giving me a #value error. I am trying to match the value in Sheet1!B2 to Sheet2|ColumnB I have tried different combinations with no luck. The value I am looking for is in Sheet2!B94. =VLOOKUP(TRIM(Sheet1!B2)|TRIM(Sheet2!A1:B94)|2|FALSE)

Hi, I have Table 1 and Table 2. Both have different data. I want to create a table 3 that includes both table 1 and 2. The end goal is for table 3 to automatically update when I update table 1 or 2. Below is a view Would appreciate all the help! thank you!

I have 2 tabs of data with a unique identifier. The identifier is not in any particular order. I need my vlookup / index / match to show me all the identifiers that are not present in tab 2. Reason: I am working where the systems they used failed a data transfer. I have to see what...

I need an excel formula that searches within a range, a cell that contains a word with letter "W" and then multiply the number stored in the cell from the right of it by 2 and display the sum of all this multiplied values in another cell. Example: Range A4:Y4; B4 contains word "Woo" and C4...

I am making an LPO Tracker for flight tickets, with the vlookup i can take one name for each LPO number. My problem is that i need to put multiple names with the same LPO number, unfortunately the vlookup takes only the first name and ignore the rest. here is an example, <tbody> Lpo Number...

Hi, I need help with this query-I want to split the data present in one of the column to multiple rows keeping all other info same.I am using excel 2013.Vlaues in column D will be multiple and separated by spaces.for eg- Input Columns value- A B C D...

<tbody> I want to display/show columns based on cell values or button commands – VBA Eg : I am trying to compare monthly sales values for the period Jan to Dec via VBA Code, I want to show only two columns (range of columns) for two months which I am comparing among 12 months. So if I...

Dear Excel Wizards- I have a list of about 105,000 email addresses in Sheet1, and in Sheet2 I sent a opt-in/opt out email to 15,000 contacts. Now I am trying to separate out the action each email took IF they were the lucky 15,000 list- bounce, clicks, unsubscribe, opened, etc. using a...

I have calendars for the whole year created inn excel 2013. Each month a page. Different churches are scheduled each day during the year. I need a way to prit the calendar for each individual church that doesn't show others for privacy reasons. For example: IF "First Baptist", BOLD...

I am wanted to simplify the task of transforming 1000's of data in rows into a table with specified column headings. I do manual copy paste of data which is tedious. <colgroup><col><col><col><col></colgroup><tbody> g l m 1 PT-55002 0 135 2 PT-55002 0 135 3 AIT-98932 -200...

I've the below two excel worksheets Sales and delivery sheet. Both worksheets contain 1000 -1500 rows and 40 columns. I need to combine both these worksheets in to a new worksheet " Worksheet 3" which contains combined data from these worksheets. In the below example I've given only 3 columns...

Good afternoon, I've spent most of today attempting to automatically copy a number of rows of data from a table into a separate sheet. The idea is that I enter a ticker into a cell and the formula will retrieve the data from the different rows and columns in the table. VLOOKUP does the job, but...

Hi, I have below table1 (sheet1): <tbody> <tbody> StartDate(A1) </tbody> <tbody> EndDate(B1) </tbody> Month(C1) Quater(D1) Year(E1) <tbody> 29/07/2012 </tbody> <tbody> 25/08/2012 </tbody> 1 Q1 <tbody> 2013 </tbody> <tbody> 26/08/2012 </tbody> <tbody> 22/09/2012...

Hello. I did a search and really couldn't find anything that returned row header information for this kind of problem. Hopefully someone here can lend me a hand. So here is what I am trying to do Name English German French John Yes Yes Yes Kim Yes Yes George Yes Yes...