pair

If anyone could help me with this formula I would be super grateful.. Thanks in advance. This formula below works fine with the exception that I now require the formula to only count “one” if there is two inputs on each cell of the nine pairs (“W128 & W129” is what I call a pair for example)...

please detect the front double of the pick3 and see the amount of each groups. Step 1, put the pickings of the pick3 in ascending order Step 2 separate the front pair. 3º detect in the frontal pair in which of the 7 groups 4º to see the frequency (quantity of each group)...

Hi, I need a formula to extract only the first occurrence of the data or unique records I can say. The formula should look all the 3 columns in a row and should treat it as a duplicate if all the 3 cells are equal - otherwise not. here is a sample data in A2:C17 <colgroup><col width="64"...

Hi, could youhelp me with the following excel problem: I have aexcel workbook with several worksheets (Workbook X with worksheets A1 , A2, B1,B2, C1, C2…). I would like to write a macro, which can copy each pair ofworksheets (i.e. A1& A2; B1 & B2…..) and that saves the new workbookswith the...

Hey guys I am trying to compare delivery shipping opens for different zip code pair and the ata is coming out in a format that I really can not use. I want to be able to see the zip code pair and all services that are available with all the other info. <colgroup><col width="107"><col...

having vba code but....how to Number pair counting with vba in excel 2007 B2:U27 data range count any number with other in data range rows in between 01 to 80 numbers pair counting in following chart by help me! how to do it with vba code? e.g. of...

Hello guys, I have large xls file wherein one cell has 100+ words... Out of that specific cell (J1,J2,j3...) I want to extract content which is in "[ ]" square brackets. The problem is that there is sometimes one pair of brackets in the cells, but sometimes is also 3-4 pairs of brackets... I...

Hello everyone, I am very new to VBA (I have used it for some minor tasks), but at the moment I am faced with a challenge and I am not sure how to approach it. The task is as follows: 1). I have two folders (two different locations) which contain a number of .csv files (200+) 2). What I need...

Hi all, I need to count the total time spent for one task among various people, by counting the starting time and ending time of the sub-events. Example here: <tbody> Event 1 1 2 2 3 3 Time S E S E S E Alex 1 Jan 2 Feb 3 Mar 4 Apr 5 May 6 Jun W days Brian 2 Jan 2 Feb 2 Jan 2 Feb...

Hello everyone, I'm new to the forum, but I look forward to contributing to other peoples questions in the future! I currently have a question involving a scenario where I want to rank pairs of data while ignoring any duplicates in the data. What I am working with is located below. Column A is...

Question, Column A has key values. In column B, few rows just have one values and few have multiple values. I.e. A B 1 x 2 x,y,z 3 y,z,e 4 n,m I need the resulting sheet as follows, A B 1 x 2 x 2 y 2 z 3 y 3 z 3 e 4 n 4 m I have a huge list for this, If anyone can help.

hi, i need help in knowing how to use an array formula for the following (and even help in knowing if i need an array formula!) i have my data in pairs like this: (ax1, by1),(cx2, dy2),... (im using the numbers 1,2,3... only as index to denote the pair, not as powers!) and in excel i have...