sets

Hello everyone, I have to lookup a set of values through other sets of values (almost half million rows total). Could anyone suggest any approaches to this task? I thought of creating named ranges with each set, then iterate through each range to get all the matches. But would there be any...

Am missing something? I'm trying to use the Analyze/Fields, Items, & Sets to create a new pivot column that is merely the first letter of any items in an existing column in my data set. Otherwise I would need to add a new column and use a formula like =left(a1,1) Seems like a waste of...

I always have trouble with nested IF AND formulas. Trying to figure out how to combine the two formulas below based on whether a number falls between these two sets of numbers: <tbody> A B 1 11 13 2 23 25 </tbody> =IF(AND(N$3>=$A$1,N$3<=$B$1),"PY last 3","") and...

Hi All, I am looking to compare 2 data sets and identify any differences using colour. I have demand from a customer and want to compare against an internal demand book. I have created data set to test this. I have added 2 data sets into a simple table with one column identifying data source...

Hi, I'm looking for a way to seperate sets of bars in a graph. I've been inserting a gap by inserting a column between the data, which isn't ideal. Is there a 'proper' way to do it? A tick box or something?!?! Thanks!

Dear Experts I am using a choose Formula as follows: CHOOSE((VALUE(F2733)>0)+(VALUE(F2733) > 50)+(VALUE(F2733)>145)+(VALUE(F2733)>500)+(VALUE(F2733)>750)+(VALUE(F2733)>1000),0.65,0.6,0.55,0.5,0.45,0.4) At the end of formula I have few fixed factors which i want to name as Set A, Set B, Set C...

I would like to use icon sets to display and arrow next to a value if that value is up or down against an adjacent cell. I.e Up if higher, red if lower (amber if level) Also, if possible, I would like to put a variation in where if the value is within 10% of the value of the adjascent cell it...

I'm not sure if this is possible, but figured I'd be the (possible) hero in my department and ask. The desired result is below. We're trying to compare CLIENT 1 to PEER GROUP. As you can see, it's plotting two different sets of data...but not really. I had to manually color the "peer group"...

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> 1st data in cells C6:E7, I need to get possible sets in the cells H6:O7</SPAN></SPAN> 2nd data in cells C9:E10, I need to get possible sets in the cells H9:O10 </SPAN></SPAN> 3rd data in cells C12:E13, I need to get possible sets in the...

Hi everyone. I'm new to PQ but I am working to I'm learning because its obvious it can make my daily life easier. I get data sets off of our test facilities in excel. They are unique data sets, so I do not want to combine them. But they each have the same number of columns and need the same...

Hello all, I need help in the following. I have a sheet with players and the results of their game (in same line) I want to automatically add 1 point if the player won the match (in the points column) and add the number of sets the player won or lost some tennis rules about winning or losing ...

Hi, I have a database with sets of data containing long numbers such as 1132334256. I want to pull all the data for the sets of numbers from 1132334256 to 1132334270. what would the expression be? I was thinking string between (ends with "256" and ends with "270"). I need to return all values...

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

Hello Friends, I need help to Extract DATA from one workbook to another.... Here is the DATA Sample <tbody> REF P.O # P.O.DATE Customer Factory Article Quality Dyed or Printed Fiber Content Construction Size Quantity UNIT 132 78118 19-Dec-13 ABC GA Bed Sets CVC Renforce - 90 Gsm Pigment...

Hello, I have data in cell S1:T7 (column S contains units and column T contains quantity) Column Column S T Sets 123,456 Pcs 109,887 Pairs 123,001 Dozens 256,001 xxx 123,456 Sets 111,009 what i want in cell U1 is a...

The icon sets in excel are pretty basic and boring. Is there a way to make your own or upload better looking sets from the internet?:confused:

I have two sets of two columns, in column A I have an ID and in column B I have a version. I pulled another set of IDs and versions, column D has the ID and column E has the version. I need to compare these two sets of lists. I have to match up the IDs from A and D and then pull the...

I want to use Icon Sets for a sales spreadsheet based on the status of the sale. For example when something has been allocated, it is one colour, when it's invoiced and waiting payment it is another colour and then when it is fully paid it's a third colour. Unfortunately I dont' believe the...

Make all possible sets Hello, I am looking to get all-possible sets of the 14 numbers are listed in the A1:A14 Example attached <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead> A B C D E F G H I J K L...

I'm trying to graph two different data sets but the associated date range for each data set is different. When I try to edit the date range for each item is applies the edit to both. Is it possible to edit the data source they each have a unique date range? Thanks