categorize

Hello, I have a tool that spits out data to excel in a sheet with column headers and several rows of data. From that data, I'd like to transfer it to another sheet in a prettier format and grouped by a certain column based on the output. For example, I have a category column, for every repeated...

Hi i have huge dump ticketing report which needs to categorized.... there are many key words it has to lookinto in the summary to categorize the data can you tell me if this is possible?

Hello, I'm trying to categorize a number in a cell for example 4557808818 the formula I'm tying to write is =if(left(a1,1=4),"airbill",if(left(a1,1=5),"online" etc. what is the correct format o write this so it reads the first digit f a string and categorize it? thanks

Hello - I am looking for help with the following. Thanks in advance! I have a column with values that need to be categorized based on multiple criteria. I would like to categorize using below logic: If value contains "X" Or "Y", categorize as "Category1", if contains "A" or "B" or "C"...

Wondering how to format this... = IF(AS2="Y11Q4", "Established, IF(AS2="Y12Q1", "New", IF(OR(AS2<>"Y11Q4", AS2<>"Y12Q1"), "Unestablished") Basically, if AS2 doesn't equal Y11Q4 or Y12Q1, I would want to categorize this into a third Unestablished category... Thanks, hope this isn't a silly...

I am an interior designer with a lot of workbooks for different projects, but if possible I would like to streamline them into a master spreadsheet and then be able to select and print out, for example, all the tile selections in the entire house, or also just the selections for one room. Is...

Hi, Really having trouble with my Pivot Table. Need to categorize my rows by the results I get in data count. Okay so I've created the table successfully. Basic breakdown of what I have; in the rows I have individual users, in the data I have a count of different deliveries done by each (so...

Hi, I have two sheets. I want to sum a list of entries that I have on one sheet while grouping it by month and category on another sheet. I'll explain better. On the first sheet Here I have something like this As you can see, a list of months horizontally and a list of cost categories...

Hi all, I have an Excel file with names of people I have to divide into groups. On separate paper files they all wrote the names of people they'd like to be in the group with. The situation is a youth movement holiday with different groups of friends, so we can assume that if person A chose B...

Hi Can i please get some help with a formula. What i have is a sheet that is (or can be) 50000 rows by 14 columns. Col J has "Days" and Col M has "Type". Below is an example of how the 2 columns look like: <TABLE style="WIDTH: 89pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0...

Hi! I have a column with 3000+ rows of number data ranging from 0-100+. In order to adjust this data so it better fits a regression analysis, I need to replace the values with one out of five category numbers. The categories should look as follows: value 0 = category 0 1-5 = 1 5-10 = 2 11-30...

Hello, First I would really like to thank those of you who answer threads on this site, as it has proved immensely helpful for me and is greatly appreciated. I currently have a very integrated worksheet that is autopopulating based off the input of a unique identifier and an amount (mainly...