categories

Hi everyone, So for the sake of an example, say I want to calculate a prices per pound, but there are different colored containers that indicate different prices. Like a red container is $1/pound, a green container is $2/pound and a blue container is $3/pound. So my Data Table would look...

I have two columns, Category of Equipment and Labor Hours. Each individual cell of the CoE column is one of a few different categories. Door, Rack, Kit, Base, Shelf, Accessory, etc. The Labor Hours shows the time taken to install specific products, based mostly on category. What I'm trying to do...

Hi folks! I've got a folder that has 5000+ pdf's in it. I've got a spreadsheet as shown below. I'd like to run a sub that copies the pdf's in the original folder and pastes them into the new folder.. Is anyone able to help? <tbody> PDF Name PDF Type Current Folder Copy to New Folder...

Hi, had a good look but could not find an exact answer... I am looking to categorise each text description into 1 of say 10 categories. I need to assign multiple words to equal each particular category, if 1 or more of those words occur then the category that they correspond to will be...

Hi everyone! My question is as follows: I have a database that shows the start and exit dates (for each entry a separate start and exit date) from a commodity that is going through processing. The commodity has 3 different categories and each entry (lot) has a different volume. The database...

Hi. Situation: I am analyzing data of a courier company. The data is organised into rows with each row representing a delivery from pickup to destination. I now wish to understand performance of the couriers over different distances (delivery lengths). The total distance of each delivery...

Hi All, I'm going to try to explain this as best I can. I've created an Excel spreadsheet, in which there is an Inputs tab. In order to keep the sheet tidy and organised, I have created a row at the top, where I can add the hardcoded information. The idea is that, upon pressing a button that...

Hi I am trying to get an Excel template where I can categorise bank statement data. Say I have a bank statement with 1000 entries covering a year of data in Excel I would like to get some kind of lookup formula that would look at the bank statement and then from a list of possible...

Hello, I am trying to work out a formula for the example spreadsheet below. <tbody> Item Cost Category Kroger 100 2 Gas 50 3 Movies 35 4 Phone Bill 170 1 Category 1 Total ? Category 2 Total ? Category 3 Total ? Category 4 Total ? </tbody> I am trying to write a if...

Hi, I have a spreadsheet at work that I am trying to build. I work for the Supply Chain group of a major EPC company in Houston. I have a spreadsheet of approx 15K rows, each row contains a PO number in the following format - A0001, B0002, C0003. What I need to do is assign names to the prefix...

Hi, I use VBA quite a lot but I wouldn't say I'm an expert - I have a limited "vocabulary" and work around that with help from MrExcel.com :) I have an outlook vba macro that I've been using for some time to help file the items in my inbox and it worked fine, however the other day it started...

Hi everyone, I'm having an interesting but difficult issue. I've searched Google and this forum, but still can't figure it out. I am taking ranges of time and then need to break them down into two categories -- day time hours and night time hours -- and need to repeat this process daily. I am...

Hi folks, I have a simple website export of category names which are parent & childs of each other. They all reside in column "A". In column "B" & "C" I have the Category ID & Parent ID which is effectively a parent Category ID. "0" is the "Default Category" or master root if you like and what...

I have a budget spreadsheet and the top 40 rows are for DAILY entries. Under this section I have a MONTHLY TALLY which I want to be able to subtotal EACH category from the DAILY section to the MONTHLY section. (i.e. Dining 1/2/2012 $4.50; Dining 1/7/2012 $25.50 Gas for Car 1/10/2012...

hello everyone, I would need to classify subjects by crossing two existing categories. I have two variabiles with 4 categories each, giving rise to a 4x4= 16 categories classification. |var01|var02|NEW| | A | A | 1 | A | B | 2 | A | C | 3 | A | D | 4 | B | A...

Greetings, I'm hoping to categorize data based if it fits into a following range of numbers. For example, if I have <TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=64 border=0><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 12.75pt"...

Hello everyone After giving it a good thought for several days and looking around in this and other EXCEL forums, I finally gave up on finding out on my own on how to do the following operation (tried several countifs and sumproduct variations but could not get it to work): Let´s say I have a...

Hi all, I have a problem and do not know how to solve. I have the following sample worksheet: <table width="192" border="0" cellpadding="0" cellspacing="0"> <col style="width: 48pt;" width="64" span="3"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt...

GOAL: Create table of debit card transactions, by month and organized into summed categories (food, entertainment, education, etc.), each of which being compared to income for that month (percentage of) WHAT I KNOW: - If statements (haven't ever used them in excel though) - basics of excel -...

Windows XP, Excel 2007 Okay, Column A is filled with bank transaction descriptions like: 123456789 ACCOUNT WITHDRAWL CHECK CARD 1234 GOODY'S CLOTHING CHECK CARD 5678 APPLEBEES RESTAURANT 123456789876 SOU WAL-MART 092834750298 SOU JCPENNYS STORE 20938209837 ... AND SO ON Column B is the...