sets

Hi, It may sound ridiculous what i'm asking, but i made a macro to sort in descending order the first 2 pairs of column (among 120 sets), But it seems that if i sort 120 sets of columns the macro is going to be huge, and that's why i'm requesting help to see if i can get a VBA or code with...

Dear, I need to compare two Exceldata sets (1 Original data set and 1 Test data set from the original one) toverify and validate whether they are equal or not? I also would like to see visually (E.g. In green or red colors) were the data sets are different or equal. If possible I would like to...

Looking for help trying to calculate the median of both sets of numbers in B18. The formula should only include numbers with a positive value in column C. Any help is appreciated. Book1ABC1201215-23824163566612-17Set A Median13.589139102041112612153139214441511-516Set B Median11.51718Median...

Hello, <tbody> Column 1 Column 2 Column 3 B 1 24 A 2 22 A 2 28 C 1 21 B 2 18 A 2 32 A 1 20 </tbody> Say if I have 3 columns as above, I want to get the minimum value of column 3 among the matching sets in column 1 AND 2 only. i.e. result should only get 22 (min. of A-2) Any...

Hi So I currently have two sets of data, per below (unique ID and cost center). Where I need to get to is to have a separate row of data for each unique ID and cost center (e.g. 4 unique ID's x 4 cost centers = 16 rows of data). I feel like I'm missing something really simple here - and I...

I have a interactive userform where users can select any number of 15 sets of data and then plot them (x axis is time and is common to all data sets). The data sets are picked by a "yes", "no" combobox before clicking the "Load" command button. How do I get the legend to plot only those...

Hi guys, I have a question about the "count" formulas in excel. In the cell below, there are 10 sets of 3-digit-code in there. I'm wondering what the formula would be in order for me to count the sets with in this cell. Can anyone help me with this please? <tbody> <tbody> M22 D01 D07 D09...

Hello, I am looking for a formula to add 100% of the largest number or sets of that number with 50% of the second largest number or sets of that number. For instance, the following numbers may be in cells 12 35 14 14 6 14 So the formula will first see 35 is the biggest number, and there is...

I have this data: Imgur: The most awesome images on the Internet and so on… (up to 500 sets of data each with 7 cells, and the first cell being the set's number 1-500; so 3500 (500*7) horizontal cells in total) What I need to do is to get each set of data (7 cells) to stack up on top of each...

I have a database with 300 rows and 50 columns. The cells are populated with either zero, one or blank. I'm looking for a formula that I can plug into column number 51 for the 300 rows, that will tell me how many sets of 7-consecutive-zero's there are in each row.

Cells A1:A4 (group 1) contain the values 1, 2, 3, 4 Cells B1:B4 (group 2) contain the values 5, 6, 7, 8 Cells C1:C4 (group 3) contain the values 9, 10, 11, 12 Cell A6 contains my variable value - use for example 7. Cell B6 should contain the value "2", because 7 is in group 2. My question...

Good morning, I have a concatenation of unique identifiers, separated by commas, in column A. I have a formula in Column B which is as follows: =LEFT(A1,FIND(CHAR(1),SUBSTITUTE(A1&",",",",CHAR(1),2))-1) which identifies the first two unique identifiers in A: A: 01,02,03,04,05 B...

I have a row of 16 numbers, one number in each column. I want to sort these numbers into 8 sets, each set containing 6 numbers with no one number being repeated in any set of 6. The sort can be random. :eeek: