1. B

    I need to count one or the other cell as One

    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)...
  2. P

    detect in the front pair in each group of the corresponding 7 and its frequency

    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)...
  3. H

    Formula to extract unique records only

    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"...
  4. F

    Workbook with several worksheets

    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...
  5. C

    Data in unuseable format

    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...
  6. D

    Count number pairing

    having vba code 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...
  7. N

    Extracting text from cell

    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...
  8. T

    Looping through each file in two different folders and extracting data to a new workbook

    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...
  9. R

    Remove duplicated pairs of data when counting time between dates

    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...
  10. N

    Ranking Unique Pairs with Duplicate Data

    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...
  11. A

    I need to take one column as Key and other as values, and get resulting sheet with one key one value.

    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.
  12. A

    vector multiplication.

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

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
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 "".
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.
Go back