excel & lookup & search

First time posting.. I have a large data set with three columns: Date purchased, Item, and Transaction id. The transaction id can have multiple items for the same transaction id. I want to search how many times different item combinations repeat for each transaction id. I.e. I want to count...

Help Please, I know this has been answered a number of times already, but I don’t know enough <acronym title="visual basic for applications">VBA</acronym> to interpret the code and manipulate it to meet my specific needs. Basically, I need to update old account information with new account...

Hi All, I need help and suggestions: I had a list of contacts and their details its a bulk. I need to verify those names and contact details are matching with my database site or not. In detail my database site user interface have search option if I give name of person with id he have if it...

I am wondering if there is a way to search for a specific value in a column; then if the value is found highlight the entire row and copy it to another sheet or workbook. I know that you can do this manually, I was just curious if there was a way or writing a line of code or a string of macros...

<tbody> Hi All while calculating the average balance for my working I need to use the last working day of the month, however If the month end does not fall on the last working day, the average balance is not correct. For example, if 29th is the last working day of a 31-day month, the average...

I have a table that contains productid and price date. The price has gone through changes overtime and need to find the price value based on specific date but the this specific date fall between a range of dates. Here is my work table: <tbody> <tbody> Product ID Price Date Need price...

I' have a question somewhat similar to this post, but with some difference. https://www.mrexcel.com/forum/excel-questions/703080-find-value-table-return-column-header-row-header-each-occurrence.html <tbody> 01-JAN-17 02-JAN-17 03-JAN-17 04-JAN-17 05-JAN-17 06-JAN-17 07-JAN-17 99XX1002 0 1...

Hi All, I am currently handling multiple excel workbooks that each have a different spreadsheet that uses vlookup to extract information from a same data spreadsheet(same across all the excel workbook files). So basically lets say I have 6 excel workbooks, and each of the same spreadsheet "A"...

Hi All, Complicated one (for me at least) I have this rather all encompassing Shipping table document, I want to create a formula that will allow a user to input into one cell a country name (its easy to make this lookup the 3iso code) and then input a deadweight to give a shipping cost...

Thank you for taking the time to read my post. I have the below code which works for comparing 2 spreadsheets and the cell data when they are aligned correctly. The problem that I have is that a row of data can be deleted from one worksheet and not the other and this causes the formula to...

Hi, I have a list of keywords in Sheet A (2000 rows) and I have a sheet B (column B), where I want to highlight Column B or get YES/NO (in nearby column D) if the cell of column B contains any keyword. For example - Column B cell contains "30secondMBA.com" and I have a keyword "MBA". If I...

I Have a data sheet called 2017, in the R column there is the months. There is a January sheet i want this sheet to extract all the data from the 2017 sheet if in 2017 sheet column r it says January. here is the file you can check it out im so confused... Click Me

I have tried various types of searches to get the help I need, but it either doesn't exist or, more likely, I am not using the correct language to search. I'm not sure this is something that can be done with a formula. I'm not opposed to VBA, but prefer a formula. Essentially I feel like I need...

I am trying to find a formula for column A that will check an IP address in column B and find if if falls into a range (or between) 2 addresses in in two other columns. C and D. E.G. <tbody> Valid? address range start end yes 10.1.1.5 10.1.1.0 10.1.1.31 yes 10.1.3.13 10.1.2.16 10.1.2.31...

Hi all - Am trying to figure out how to to this. I have a list of job titles (column A) - I want to search each cell for a specific word, and then return that word in column C. Please help!! So if cell A2 has the word director in it, then I want cell C2 to say director, if cell A2 has the word...

Dear all, How the workbook looks like: Each sheet in the workbook represents one month of the year. In an additional sheet I would make a table with all the companies and 12 months of the year. I would like to put x in those months for company ABC in which that company has a contract (i.e...

Hi all, I have a list of Reference numbers in column A, I want to search for a specific value by asking user input and select first five columns from the same row if the input matches to cut and paste to the next sheet as top row. I also want to remove other column values from the old sheet. I...

Hi there, My example is that on column A, I have different names. Let these be, in order of appearance, starting with <code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono"...

Happy New Year to everybody, I am trying to make a time-sheet format from a row attendance data. Row data will look like as below: <tbody> ID # Date Time Type 100 1/1/2017 07:00 AM IN 100 1/1/2017 05:00 PM Out 100 2/1/2017 08:00 AM IN 100 2/1/2017 01:00 PM Out 100 3/1/2017 10:00 PM In...

Hello, I have the following data in two sheets Sheet 1 <tbody> Type Old Date New Date REFGT LKMNOP 1/13/2016 </tbody> Sheet2 <tbody> <tbody> Type </tbody> <tbody> Correct Date </tbody> <tbody> REFGT </tbody> <tbody> 1/13/2016 </tbody> <tbody> LKMNOP...