column comparison

Date Committed OnHand 28/11/2018 1 11 29/11/2018 3 10 30/11/2018 3 9 01/12/2018 4 8 02/12/2018 2 7 03/12/2018 5 8 04/12/2018 6 10 05/12/2018 8 6 06/12/2018 4 8 07/12/2018 5 5 08/12/2018 6 3 09/12/2018 7 8 Hi there, I'm trying to compare a list of values in the...

Hi, I am trying to compare 2 columns in Excel one contains numbers and the other contains a vlookup formula that returns a number. When I try to compare the 2 columns using the IF statement it doesn't recognise the vlookup column as a number and produces the wrong result. Is it possible in...

<tbody> 282.97 156.34 285.12 126.57 234.14 285.89 157.97 285.71 126.65 234.17 </tbody> Row 1 above would count 4 - Column 1 matches column 3 within 10 and Column 4 matches 5 Each column represents Degrees 0 to 360 (around 40,000 records) It is a quality assurance metadata for a...

I am having trouble moving data from one column (I am using this column as a helper column for data based on another sheet) into a different column on the same sheet, but without bringing along blank cells. This is the situation: <!--StartFragment--> <colgroup><col width="65" span="2"...

Hello All, I've been attempting to make some comparison's in a Pivot Table but have run into some struggles. I have a PT setup in Excel 2016 with 2 columns "Month" and "Year", and they columns represent sales data for their respective months and states in a corresponding row. As such I would...

Hi all, I'm looking to compare surname and first name columns in one worksheet with surname and first name columns in another sheet. If there is a match it's deleted from the first file only. The user enters the range of data to be inputted. So far i've been able to work on one column but i'm...

I am currently scouring and plugging numbers from years prior into a spreadsheet for graphical purposes and as such have numerous date based cells assigned individualized data. Now, the data points I am pulling from aren't exactly what you would call 'consistent' and miss quite a few days here...

Hi Forum! I have the same reptitive task everymorning. In Excel 2010, I have figured out the sort but cannot get my head around adding comparative columns. I am looking to add two columns between different headers. The first column would be titled '$ Change' and contain a formula subtracting...

This module compares columns "S"&"Q" and "Z"&"I" against each other. I am not sure why it works like this; however, this code produces the enrll_Mismatch_Msg only when they match at the moment. I managed to write a short snippet which fixes this; however, it seems to be unreliable. I'm looking...

Hi, I have two columns of data in excel. There is no common values between these two columns. Few values in column1 is mapped manually with values in column2. Now i need to display both columns with mapped and non mapped values. I attached a sample sheet with this. Thanks Regards, Kannan S...

Consider the following data set: <tbody> Month Product Unit Price Sales Volume Revenue Discount % Discount Value Jan A 5 10 50 5% 2.5 Feb A 5 15 75 5% 3.75 Mar A 5 20 100 5% 5 Apr A 5 25 125 5% 6.25 May A 5 30 150 5% 7.5 Jun A 5 35 175 5% 8.75 Jul A 5 40 200 5% 10 Aug A 5 45...

hi, i have a spreadsheet of staff training needs with over 145 courses.. some of these columns (of the name of the course) have the same heading, so some of the staff data is in the former and some in the latter - but its not duplicated... I just want to merge the two columns with same headers...

Hello everyone I have a list of company names that I would like to match up to a list of other company names. The list in column A goes from A2 to A11087. The list in column B goes from B2 to B57013. What I am trying to accomplish is I want to create a some kind of macro code such as the...

My current data sheet looks as under; <tbody> Row ColumnK ColumnL ColumnM ColumnN ColumnO 3 21-Sep-2013 4 27-Sep-2013 5 03-Oct-2013 6 11-Oct-2013 7 23-Oct-2013 8 17-Sep-2013 9 01-Oct-2013 10 08-Oct-2013 11 23-Oct-2013 12...

Excel friends, This problem looks like “easy” but I decided to ask the experts. I have two lists: both with company names. Names were input in different word order or adding different words to very similar names. I need to identify the occurrences and position of any of the words in each name...

Hi. Thank you for any guidance or help. I'm not that good with Excel and hope to solve a problem, but need help. Here's what I would like to do - if possible. I have software specs and would like to compare the software specs to any computer specs. I have the ability to run a program to give...