2nd

In column A I have a distinct part number. In two other columns, i have that same list of parts, but it is not unique in the lookup table. each instance will have a different value in the 2nd column. One part in Column A may exist 3 times (or more) in the look up table. In column B, i want the...

In column A I have a distinct part number. In two other columns, i have that same list of parts, but it is not unique in the lookup table. each instance will have a different value in the 2nd column. One part in Column A may exist 3 times (or more) in the look up table. In column B, i want the...

I have 2 workbooks open that I want to compare using view side by side function and also synchroinous syncing . Is there anyway that I can create a macro so that it looks down the two workbooks comparing data and if missing from 1st sheet it highlight it. I want to look in the 1st sheet on...

Hi mrexcel forum. I registered here by googling only to solve my problem. If this problem is solve than my task would be much much easier. I have data on two column till 600 rows. first 300 is grayed and 2nd 300 is white. I want some kind of conditional formatting or filter or rule or anything...

I really can't word this well, so I'll explain what I mean. I have 2 sheets, the first one you manually type things and the 2nd formats it into a certain way. The first sheet is setup vertically with names being the rows, and the formatted sheet has the names as the columns. To format the 2nd...

<tbody> 1 <tbody> Date Batch 1 1st time Batch 2 2nd Time Hour 28/01/2019 AA103 BB100 6:09 AM 0.75hrs 28/01/2019 AA104 BB101 6:15 AM 1.23 hrs...

Here is the Table. I would like to have them in this order. Measure 10,11,12,18 are in the 2nd set (40% weight) the rest are in the 1st set. I know if I reorganized them to where the 10, 11, 12, 18 are the last four rows it can be done with these formulas: 1st set...

Hello everyone, I have a problem with controling CheckBoxes. 1st I want to forbid checking both of CheckBoxes, maybe like automaticly uncheck 1st box when I check 2nd. 2nd Since it is imposible to check both boxes in a same time, I want to in cell I3 show value of cell C2 if Checkbox 1 is...

I would appreciate some help with this task as I am really stuck trying to work this out. I will try my best to explain it. I have 2 worksheets in the excel file. The first worksheet is where all the data is sent from the 3rd party software. I have no control over how the data is displayed on...

Hello everyone! I would kindly ask you for help with macro which would save file #1 with name of file #2 .

Hi all, I'm trying to work a formula that always subtracts the 3rd visible row and cell data from the 2nd visible row and cell data to return the result from a filtered list. Every time i filter it returns 3 rows of data (a header, and 2018 data and 2017 data). But when you filter different...

Hi all, I have to columns of data and I am looking to copy the first non blank value and move it to the adjacent cell. The raw data looks like this: <tbody> -1 0 -1 -2 -3 -2 -1 0 1 2 3 4 3 4 5 4 3 2 1 0 1 0 1 </tbody> In the...

Guys, not even sure if this is possible. I have an excel table called 'Newport' which consists of the following 9 columns: Dealer, DecsR Attempt - (this column will only consist of New, 1st, 2nd and 3rd) RegNO, Salute, Updated, Contdate, Completecode The table normally has around 2000...

Hi, New to this, but have tried this: Two workbooks open side by side in the display. In a cell in a sheet in one workbook, I type an '=' sign. I then click on a cell in a sheet from the 2nd workbook, and press Return. Nothing seems to happen. No formula referencing the cell in the 2nd workbook...

So, I have 3 sets of 50 point with x and y coordinate. Each set start from origin (0,0). What I must do is arrange all the points so that 1st point and 2nd point is nearest compared to 3rd,4th and 5th point. After locating 2nd point, I must then find the nearest point to the 2nd point. And so...

If I have a Named-Range that has multiple areas, such as ... TempRange =Sheet1!$C$2:$C$4,Sheet1!$X$2:$X$4 And I want to get the 2nd Value in the 2nd Area, in this case ... Sheet1!$X3 Using the Named Range, How do I reference that cell in regular Excel formulas?

Hi All, I would like to know if there is an excel formula to extract data in the middle between first and 2nd last delimiter. I have a sample data as below. device_hostname1_rootvg_lun1_1_vol device_hostname1_vgDBapp_lun397_1_vol device_hostname1_vgDBbkp_lun398_1_vol...

Hi, I've got a list of numbers that are all the same (eg. 80,80,80,80,80) The first vlookup is fine as it matches the first 80 to the cell i want it to. Is there a way to match the 2nd 80 to the 2nd cell along the list as a normal vlookup will just lookup the first one wouldnt it. Here's what...

Can you advise if the following is possible? I have two workbooks - 1st workbooks contains the request form and the 2nd workbook contains the data I need that information selected on the request form trigger a search in the second workbook where the results are emailed to the person The...

In one sheet, I have an raw data like this: <tbody> Invoice Number Date Amount 1st <tbody> 6086876869 </tbody> <tbody> 13-Sep-18 </tbody> <tbody> USD 755.17 </tbody> 2nd <tbody> 6086453273 </tbody> <tbody> 13-Sep-18 </tbody> <tbody> USD 945.88 </tbody>...