I am working on a process to remove inactive users from a system that we are trying to automate. The problem is we decided we want a 30 day buffer on deleting users and our current system does not make that easy.
I can export a list of all inactive users ever and a list of users made inactive...
Hello,
Apologies if my post title is not the best summation of what I need. I am currently working with two different data sets that contain a unique identifier in column 8. This unique identifier is a concatenation of other fields within each row on each data set.
What I would like to do is...
Hi,
I'm pretty new to Excel, and I'm still not 100% around the functions, so any help, that someone could give me on my question would be much appreciated!
I have 2 sheets with similar hierarchies of 5 levels in the following format:
Sheet1
Row L1 L2 L3 L4 L5
1 a b c d e
2...
Hi All
N00b to excel
I have a excel file with two sheets with some HR type data.. so we can consider column A for both sheets (say Sheet1 and Sheet2) to contain employeenumber
Now what I want to do is
1) Find if Sheet2 contains employeenumber (A in both sheets) - some kind of vlookup?
2)...
Okay all great minds out there I am at a stand still. I have two sheets with the 13 columns and ~700 rows I need to know what data is different in each row. NOT what is different by each column/cell just what data is different in each row.
Example
Sheet1
<tbody>
ROW1 GridName
Page1
Page2...
Hi, I'm trying to compare two columns worth of data. I'd like to use conditional formatting (I think?) to compare cells in column A with cells in column B and highlight the matching cells if/when any cell in column A matches any cell in column B. For example:
<tbody>
Sparrow
Eagle
Thrush...
I've got a rather sticky situation with a spreadsheet that is calculating sales commissions.
1) Within my spreadsheet, I have a tab (COGS List) that contains all of our inventory items (by item number), their cost, and their price (Columns A, B, and C respectively).
2) I have another tab that...
I'm looking for a UDF, Macro or Array that can solve the following challenge >
I have Text in Columns A + B, which could include up to 35,000 Rows.
The Text will be mixed with various forms of punctuation and numerals (see List below of ALL possible "Text" characters).
I want to run a...
Hi All,
I'm pretty new to mrexcel and vba and wondered if you could help me...
I have two sheets - sheet1 (last week's report) and sheet2 (this week's report). Each sheet is the same format:column A is the unique identifier, column B text and C to F are numbers. Each sheet has over 1000 rows...
Hello all,
I wish to compare a list of text (Name to Match) to a static list of text (Standard Name) and pull the best match from the static list along with a matching value in percentage.
The values under the Standard Name column are static values. The values under Name to Match are string...
:confused:I am working with 2workbooks and need to enter values from one into the other's corresponding data. I am rusty on creating formulas; it has been a decade since I worked with them regularly. The sheet on one workbook is over 600 lines so it is a lot of data in text form (names of...
Hi,
I am at my wits end with this. i have searched everywhere but nothing seems to be working for me.
I have a spreadsheet of products that i am looking to purchase for my company.
I have a column for each of the companies that are quoting for these products. I have put in conditional...
Hello guys!
I have an very big Excel file that has exactly same columns but dirosa. ent many rows. I need help with an VBA-script to compare each entire Eos in sheet1 with sheet2 If it dont finds an pair I want it to write the row in sheet3.
Its very important that the script starts in row 1...
Hello - I am relatively new to analyzing data in Excel - using Windows 7 and Excel 2010. I have two sets of data and am trying to validate data between them. Data sets have columns titled FirstName, LastName, Ethnicity, Gender. I am trying to compare the Ethnicity and Gender to determine...
Hi
I have a problem that is hard to solve. Im looking for an VBA script (not funcion) that:
1. Compare entire rows (Column A-K) in Sheet1 with Sheet2 (Columna A-K). NOTE! Important that its entire row.
2. If it finds an dublicate somewhere show it in Sheet3
3. The big problem is that the rows...
Hello Everybody,
I got a simple sheet in which I got some columns of data representing certain grid-line i.e. A-25, B-35, C-41 etc and I got another column in which the data is like B-25.5, C-26.5 etc. I want to compare the both columns and know for each item that which item is bigger or...
I manually sort a column of data and the results appear as follows:
3GPHONER710OLD</SPAN>
40G_EL_TEST_01</SPAN>
40GC-TX-ASSY---</SPAN>
4593FCT-03</SPAN>
45GS05</SPAN>
I then run a macro with variables defined as STRING.
When I compare "40G_EL_TEST_01" against "40GC-TX-ASSY---", it tells me...
I have two columns of data. Column A has 7,000 names and Column B has 1,500. I need to compare the two and delete all the names in Column A that don't have a match in Column B. How do I do this?
Thank you in advance!
Hi,
I have this script to compare:
'Option Explicit
'Sub FindDuplicate()
'Dim LastRow As Long
'Dim MyRg1 As Range, MyRg2 As Range
'Dim A As Range
'Dim F
' Application.ScreenUpdating = False
'LastRow = Range("a" & Rows.Count).End(xlUp).Row
'Range("B1:B" &...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.